?? cw_ysdxm.cs
字號(hào):
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對(duì)象CW_YSDXM的定義
/// 根據(jù)表 CW_YSDXM
/// </summary>
public class CW_YSDXM
{
/// <summary>
/// 對(duì)象CW_YSDXM的構(gòu)造函數(shù)
/// </summary>
public CW_YSDXM()
{
m_YSDH = "";
m_XH = 0;
m_CPDM = "";
m_ZLZK = "";
m_DJ = 0;
m_SL = 0;
m_YSJE = 0;
m_YSYE = 0;
m_HXZT = "";
}
private string m_YSDH;
private int m_XH;
private string m_CPDM;
private string m_ZLZK;
private double m_DJ;
private double m_SL;
private double m_YSJE;
private double m_YSYE;
private string m_HXZT;
/// <summary>
/// 屬性 YSDH
/// </summary>
public string YSDH
{
get
{
return m_YSDH;
}
set
{
m_YSDH = value;
}
}
/// <summary>
/// 屬性 XH
/// </summary>
public int XH
{
get
{
return m_XH;
}
set
{
m_XH = value;
}
}
/// <summary>
/// 屬性 CPDM
/// </summary>
public string CPDM
{
get
{
return m_CPDM;
}
set
{
m_CPDM = value;
}
}
/// <summary>
/// 屬性 ZLZK
/// </summary>
public string ZLZK
{
get
{
return m_ZLZK;
}
set
{
m_ZLZK = value;
}
}
/// <summary>
/// 屬性 DJ
/// </summary>
public double DJ
{
get
{
return m_DJ;
}
set
{
m_DJ = value;
}
}
/// <summary>
/// 屬性 SL
/// </summary>
public double SL
{
get
{
return m_SL;
}
set
{
m_SL = value;
}
}
/// <summary>
/// 屬性 YSJE
/// </summary>
public double YSJE
{
get
{
return m_YSJE;
}
set
{
m_YSJE = value;
}
}
/// <summary>
/// 屬性 YSYE
/// </summary>
public double YSYE
{
get
{
return m_YSYE;
}
set
{
m_YSYE = value;
}
}
/// <summary>
/// 屬性 HXZT
/// </summary>
public string HXZT
{
get
{
return m_HXZT;
}
set
{
m_HXZT = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實(shí)現(xiàn)對(duì) CW_YSDXM對(duì)象的管理
/// </summary>
public class CW_YSDXMMgr
{
/// <summary>
/// 添加新的CW_YSDXM對(duì)象
/// </summary>
/// <param name="theCW_YSDXM">要添加的CW_YSDXM對(duì)象</param>
public bool AddCW_YSDXM(System.Data.SqlClient.SqlConnection cn ,CW_YSDXM theCW_YSDXM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_YSDXM (YSDH, XH, CPDM, ZLZK, DJ, SL, YSJE, YSYE, HXZT) values (@YSDH, @XH, @CPDM, @ZLZK, @DJ, @SL, @YSJE, @YSYE, @HXZT)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YSDH", theCW_YSDXM.YSDH);
cmd.Parameters.Add ("@XH", theCW_YSDXM.XH);
cmd.Parameters.Add ("@CPDM", theCW_YSDXM.CPDM);
cmd.Parameters.Add ("@ZLZK", theCW_YSDXM.ZLZK);
cmd.Parameters.Add ("@DJ", theCW_YSDXM.DJ);
cmd.Parameters.Add ("@SL", theCW_YSDXM.SL);
cmd.Parameters.Add ("@YSJE", theCW_YSDXM.YSJE);
cmd.Parameters.Add ("@YSYE", theCW_YSDXM.YSYE);
cmd.Parameters.Add ("@HXZT", theCW_YSDXM.HXZT);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_YSDXM(CW_YSDXM theCW_YSDXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_YSDXM對(duì)象
/// </summary>
/// <param name="theCW_YSDXM">要更新的CW_YSDXM對(duì)象</param>
public bool UpdateCW_YSDXM(System.Data.SqlClient.SqlConnection cn ,CW_YSDXM theCW_YSDXM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_YSDXM set CPDM=@CPDM, ZLZK=@ZLZK, DJ=@DJ, SL=@SL, YSJE=@YSJE, YSYE=@YSYE, HXZT=@HXZT where YSDH=@YSDH and XH=@XH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YSDH", theCW_YSDXM.YSDH);
cmd.Parameters.Add ("@XH", theCW_YSDXM.XH);
cmd.Parameters.Add ("@CPDM", theCW_YSDXM.CPDM);
cmd.Parameters.Add ("@ZLZK", theCW_YSDXM.ZLZK);
cmd.Parameters.Add ("@DJ", theCW_YSDXM.DJ);
cmd.Parameters.Add ("@SL", theCW_YSDXM.SL);
cmd.Parameters.Add ("@YSJE", theCW_YSDXM.YSJE);
cmd.Parameters.Add ("@YSYE", theCW_YSDXM.YSYE);
cmd.Parameters.Add ("@HXZT", theCW_YSDXM.HXZT);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_YSDXM(CW_YSDXM theCW_YSDXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_YSDXM對(duì)象
/// </summary>
/// <param name="YSDH">主鍵</param>
/// <param name="XH">主鍵</param>
public bool DelCW_YSDXM(System.Data.SqlClient.SqlConnection cn ,string YSDH, int XH)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_YSDXM where YSDH=@YSDH and XH=@XH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YSDH", YSDH);
cmd.Parameters.Add ("@XH", XH);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_YSDXM(string YSDH, int XH)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據(jù)主鍵標(biāo)識(shí)獲得CW_YSDXM對(duì)象
/// </summary>
/// <param name="YSDH">主鍵</param>
/// <param name="XH">主鍵</param>
public CW_YSDXM GetCW_YSDXM(string YSDH, int XH)
{
try
{
CW_YSDXM result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_YSDXM where YSDH=@YSDH and XH=@XH";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@YSDH", YSDH);
cmd.Parameters.Add ("@XH", XH);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_YSDXM();
if (dr["YSDH"] != null)
if (!System.DBNull.Equals(dr["YSDH"], System.DBNull.Value))
result.YSDH = (string)dr["YSDH"];
if (dr["XH"] != null)
if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
result.XH = (int)dr["XH"];
if (dr["CPDM"] != null)
if (!System.DBNull.Equals(dr["CPDM"], System.DBNull.Value))
result.CPDM = (string)dr["CPDM"];
if (dr["ZLZK"] != null)
if (!System.DBNull.Equals(dr["ZLZK"], System.DBNull.Value))
result.ZLZK = (string)dr["ZLZK"];
if (dr["DJ"] != null)
if (!System.DBNull.Equals(dr["DJ"], System.DBNull.Value))
result.DJ = (double)dr["DJ"];
if (dr["SL"] != null)
if (!System.DBNull.Equals(dr["SL"], System.DBNull.Value))
result.SL = (double)dr["SL"];
if (dr["YSJE"] != null)
if (!System.DBNull.Equals(dr["YSJE"], System.DBNull.Value))
result.YSJE = (double)dr["YSJE"];
if (dr["YSYE"] != null)
if (!System.DBNull.Equals(dr["YSYE"], System.DBNull.Value))
result.YSYE = (double)dr["YSYE"];
if (dr["HXZT"] != null)
if (!System.DBNull.Equals(dr["HXZT"], System.DBNull.Value))
result.HXZT = (string)dr["HXZT"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_YSDXM(string YSDH, int XH)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_YSDXM對(duì)象
/// </summary>
public ArrayList FindCW_YSDXM()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_YSDXM";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_YSDXM obj = new CW_YSDXM();
if (dr["YSDH"] != null)
if (!System.DBNull.Equals(dr["YSDH"], System.DBNull.Value))
obj.YSDH = (string)dr["YSDH"];
if (dr["XH"] != null)
if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
obj.XH = (int)dr["XH"];
if (dr["CPDM"] != null)
if (!System.DBNull.Equals(dr["CPDM"], System.DBNull.Value))
obj.CPDM = (string)dr["CPDM"];
if (dr["ZLZK"] != null)
if (!System.DBNull.Equals(dr["ZLZK"], System.DBNull.Value))
obj.ZLZK = (string)dr["ZLZK"];
if (dr["DJ"] != null)
if (!System.DBNull.Equals(dr["DJ"], System.DBNull.Value))
obj.DJ = (double)dr["DJ"];
if (dr["SL"] != null)
if (!System.DBNull.Equals(dr["SL"], System.DBNull.Value))
obj.SL = (double)dr["SL"];
if (dr["YSJE"] != null)
if (!System.DBNull.Equals(dr["YSJE"], System.DBNull.Value))
obj.YSJE = (double)dr["YSJE"];
if (dr["YSYE"] != null)
if (!System.DBNull.Equals(dr["YSYE"], System.DBNull.Value))
obj.YSYE = (double)dr["YSYE"];
if (dr["HXZT"] != null)
if (!System.DBNull.Equals(dr["HXZT"], System.DBNull.Value))
obj.HXZT = (string)dr["HXZT"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_YSDXM()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -