?? cw_gdzc.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對象CW_GDZC的定義
/// 根據(jù)表 CW_GDZC
/// </summary>
public class CW_GDZC
{
/// <summary>
/// 對象CW_GDZC的構(gòu)造函數(shù)
/// </summary>
public CW_GDZC()
{
m_ZCBH = 0;
m_JGDM = "";
m_ZCMC = "";
m_GGXH = "";
m_GMRQ = DateTime.Now;
m_GMJE = 0;
m_YZJL = 0;
m_BGR = "";
m_ZTBJ = "";
m_BZ = "";
}
private int m_ZCBH;
private string m_JGDM;
private string m_ZCMC;
private string m_GGXH;
private DateTime m_GMRQ;
private double m_GMJE;
private double m_YZJL;
private string m_BGR;
private string m_ZTBJ;
private string m_BZ;
/// <summary>
/// 屬性 ZCBH
/// </summary>
public int ZCBH
{
get
{
return m_ZCBH;
}
set
{
m_ZCBH = value;
}
}
/// <summary>
/// 屬性 JGDM
/// </summary>
public string JGDM
{
get
{
return m_JGDM;
}
set
{
m_JGDM = value;
}
}
/// <summary>
/// 屬性 ZCMC
/// </summary>
public string ZCMC
{
get
{
return m_ZCMC;
}
set
{
m_ZCMC = value;
}
}
/// <summary>
/// 屬性 GGXH
/// </summary>
public string GGXH
{
get
{
return m_GGXH;
}
set
{
m_GGXH = value;
}
}
/// <summary>
/// 屬性 GMRQ
/// </summary>
public DateTime GMRQ
{
get
{
return m_GMRQ;
}
set
{
m_GMRQ = value;
}
}
/// <summary>
/// 屬性 GMJE
/// </summary>
public double GMJE
{
get
{
return m_GMJE;
}
set
{
m_GMJE = value;
}
}
/// <summary>
/// 屬性 YZJL
/// </summary>
public double YZJL
{
get
{
return m_YZJL;
}
set
{
m_YZJL = value;
}
}
/// <summary>
/// 屬性 BGR
/// </summary>
public string BGR
{
get
{
return m_BGR;
}
set
{
m_BGR = value;
}
}
/// <summary>
/// 屬性 ZTBJ
/// </summary>
public string ZTBJ
{
get
{
return m_ZTBJ;
}
set
{
m_ZTBJ = value;
}
}
/// <summary>
/// 屬性 BZ
/// </summary>
public string BZ
{
get
{
return m_BZ;
}
set
{
m_BZ = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實(shí)現(xiàn)對 CW_GDZC對象的管理
/// </summary>
public class CW_GDZCMgr
{
/// <summary>
/// 添加新的CW_GDZC對象
/// </summary>
/// <param name="theCW_GDZC">要添加的CW_GDZC對象</param>
public bool AddCW_GDZC(System.Data.SqlClient.SqlConnection cn ,CW_GDZC theCW_GDZC)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_GDZC (ZCBH, JGDM, ZCMC, GGXH, GMRQ, GMJE, YZJL, BGR, ZTBJ, BZ) values (@ZCBH, @JGDM, @ZCMC, @GGXH, @GMRQ, @GMJE, @YZJL, @BGR, @ZTBJ, @BZ)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@ZCBH", theCW_GDZC.ZCBH);
cmd.Parameters.Add ("@JGDM", theCW_GDZC.JGDM);
cmd.Parameters.Add ("@ZCMC", theCW_GDZC.ZCMC);
cmd.Parameters.Add ("@GGXH", theCW_GDZC.GGXH);
cmd.Parameters.Add ("@GMRQ", theCW_GDZC.GMRQ);
cmd.Parameters.Add ("@GMJE", theCW_GDZC.GMJE);
cmd.Parameters.Add ("@YZJL", theCW_GDZC.YZJL);
cmd.Parameters.Add ("@BGR", theCW_GDZC.BGR);
cmd.Parameters.Add ("@ZTBJ", theCW_GDZC.ZTBJ);
cmd.Parameters.Add ("@BZ", theCW_GDZC.BZ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_GDZC(CW_GDZC theCW_GDZC)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_GDZC對象
/// </summary>
/// <param name="theCW_GDZC">要更新的CW_GDZC對象</param>
public bool UpdateCW_GDZC(System.Data.SqlClient.SqlConnection cn ,CW_GDZC theCW_GDZC)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_GDZC set ZCMC=@ZCMC, GGXH=@GGXH, GMRQ=@GMRQ, GMJE=@GMJE, YZJL=@YZJL, BGR=@BGR, ZTBJ=@ZTBJ, BZ=@BZ where ZCBH=@ZCBH and JGDM=@JGDM";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@ZCBH", theCW_GDZC.ZCBH);
cmd.Parameters.Add ("@JGDM", theCW_GDZC.JGDM);
cmd.Parameters.Add ("@ZCMC", theCW_GDZC.ZCMC);
cmd.Parameters.Add ("@GGXH", theCW_GDZC.GGXH);
cmd.Parameters.Add ("@GMRQ", theCW_GDZC.GMRQ);
cmd.Parameters.Add ("@GMJE", theCW_GDZC.GMJE);
cmd.Parameters.Add ("@YZJL", theCW_GDZC.YZJL);
cmd.Parameters.Add ("@BGR", theCW_GDZC.BGR);
cmd.Parameters.Add ("@ZTBJ", theCW_GDZC.ZTBJ);
cmd.Parameters.Add ("@BZ", theCW_GDZC.BZ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_GDZC(CW_GDZC theCW_GDZC)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_GDZC對象
/// </summary>
/// <param name="ZCBH">主鍵</param>
/// <param name="JGDM">主鍵</param>
public bool DelCW_GDZC(System.Data.SqlClient.SqlConnection cn ,int ZCBH, string JGDM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_GDZC where ZCBH=@ZCBH and JGDM=@JGDM";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@ZCBH", ZCBH);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_GDZC(int ZCBH, string JGDM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據(jù)主鍵標(biāo)識獲得CW_GDZC對象
/// </summary>
/// <param name="ZCBH">主鍵</param>
/// <param name="JGDM">主鍵</param>
public CW_GDZC GetCW_GDZC(int ZCBH, string JGDM)
{
try
{
CW_GDZC result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_GDZC where ZCBH=@ZCBH and JGDM=@JGDM";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@ZCBH", ZCBH);
cmd.Parameters.Add ("@JGDM", JGDM);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_GDZC();
if (dr["ZCBH"] != null)
if (!System.DBNull.Equals(dr["ZCBH"], System.DBNull.Value))
result.ZCBH = (int)dr["ZCBH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["ZCMC"] != null)
if (!System.DBNull.Equals(dr["ZCMC"], System.DBNull.Value))
result.ZCMC = (string)dr["ZCMC"];
if (dr["GGXH"] != null)
if (!System.DBNull.Equals(dr["GGXH"], System.DBNull.Value))
result.GGXH = (string)dr["GGXH"];
if (dr["GMRQ"] != null)
if (!System.DBNull.Equals(dr["GMRQ"], System.DBNull.Value))
result.GMRQ = (DateTime)dr["GMRQ"];
if (dr["GMJE"] != null)
if (!System.DBNull.Equals(dr["GMJE"], System.DBNull.Value))
result.GMJE = (double)dr["GMJE"];
if (dr["YZJL"] != null)
if (!System.DBNull.Equals(dr["YZJL"], System.DBNull.Value))
result.YZJL = (double)dr["YZJL"];
if (dr["BGR"] != null)
if (!System.DBNull.Equals(dr["BGR"], System.DBNull.Value))
result.BGR = (string)dr["BGR"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
result.ZTBJ = (string)dr["ZTBJ"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
result.BZ = (string)dr["BZ"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_GDZC(int ZCBH, string JGDM)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_GDZC對象
/// </summary>
public ArrayList FindCW_GDZC()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_GDZC";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_GDZC obj = new CW_GDZC();
if (dr["ZCBH"] != null)
if (!System.DBNull.Equals(dr["ZCBH"], System.DBNull.Value))
obj.ZCBH = (int)dr["ZCBH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["ZCMC"] != null)
if (!System.DBNull.Equals(dr["ZCMC"], System.DBNull.Value))
obj.ZCMC = (string)dr["ZCMC"];
if (dr["GGXH"] != null)
if (!System.DBNull.Equals(dr["GGXH"], System.DBNull.Value))
obj.GGXH = (string)dr["GGXH"];
if (dr["GMRQ"] != null)
if (!System.DBNull.Equals(dr["GMRQ"], System.DBNull.Value))
obj.GMRQ = (DateTime)dr["GMRQ"];
if (dr["GMJE"] != null)
if (!System.DBNull.Equals(dr["GMJE"], System.DBNull.Value))
obj.GMJE = (double)dr["GMJE"];
if (dr["YZJL"] != null)
if (!System.DBNull.Equals(dr["YZJL"], System.DBNull.Value))
obj.YZJL = (double)dr["YZJL"];
if (dr["BGR"] != null)
if (!System.DBNull.Equals(dr["BGR"], System.DBNull.Value))
obj.BGR = (string)dr["BGR"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
obj.ZTBJ = (string)dr["ZTBJ"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
obj.BZ = (string)dr["BZ"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_GDZC()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -