📄 cw_chsy.cs
字号:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 对象CW_CHSY的定义
/// 根据表 CW_CHSY
/// </summary>
public class CW_CHSY
{
/// <summary>
/// 对象CW_CHSY的构造函数
/// </summary>
public CW_CHSY()
{
m_CHSYBH = "";
m_JGDM = "";
m_CLR = "";
m_CLSJ = DateTime.Now;
m_BZ = "";
m_GZBJ = "";
m_JE = "";
m_YSDJH = "";
m_LX = "";
}
private string m_CHSYBH;
private string m_JGDM;
private string m_CLR;
private DateTime m_CLSJ;
private string m_BZ;
private string m_GZBJ;
private string m_JE;
private string m_YSDJH;
private string m_LX;
/// <summary>
/// 属性 CHSYBH
/// </summary>
public string CHSYBH
{
get
{
return m_CHSYBH;
}
set
{
m_CHSYBH = value;
}
}
/// <summary>
/// 属性 JGDM
/// </summary>
public string JGDM
{
get
{
return m_JGDM;
}
set
{
m_JGDM = value;
}
}
/// <summary>
/// 属性 CLR
/// </summary>
public string CLR
{
get
{
return m_CLR;
}
set
{
m_CLR = value;
}
}
/// <summary>
/// 属性 CLSJ
/// </summary>
public DateTime CLSJ
{
get
{
return m_CLSJ;
}
set
{
m_CLSJ = value;
}
}
/// <summary>
/// 属性 BZ
/// </summary>
public string BZ
{
get
{
return m_BZ;
}
set
{
m_BZ = value;
}
}
/// <summary>
/// 属性 GZBJ
/// </summary>
public string GZBJ
{
get
{
return m_GZBJ;
}
set
{
m_GZBJ = value;
}
}
/// <summary>
/// 属性 JE
/// </summary>
public string JE
{
get
{
return m_JE;
}
set
{
m_JE = value;
}
}
/// <summary>
/// 属性 YSDJH
/// </summary>
public string YSDJH
{
get
{
return m_YSDJH;
}
set
{
m_YSDJH = value;
}
}
/// <summary>
/// 属性 LX
/// </summary>
public string LX
{
get
{
return m_LX;
}
set
{
m_LX = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 实现对 CW_CHSY对象的管理
/// </summary>
public class CW_CHSYMgr
{
/// <summary>
/// 添加新的CW_CHSY对象
/// </summary>
/// <param name="theCW_CHSY">要添加的CW_CHSY对象</param>
public bool AddCW_CHSY(SqlConnection cn,CW_CHSY theCW_CHSY)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_CHSY (CHSYBH, JGDM, CLR, CLSJ, BZ, GZBJ, JE, YSDJH, LX) values (@CHSYBH, @JGDM, @CLR, @CLSJ, @BZ, @GZBJ, @JE, @YSDJH, @LX)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@CHSYBH", theCW_CHSY.CHSYBH);
cmd.Parameters.Add ("@JGDM", theCW_CHSY.JGDM);
cmd.Parameters.Add ("@CLR", theCW_CHSY.CLR);
cmd.Parameters.Add ("@CLSJ", theCW_CHSY.CLSJ);
cmd.Parameters.Add ("@BZ", theCW_CHSY.BZ);
cmd.Parameters.Add ("@GZBJ", theCW_CHSY.GZBJ);
cmd.Parameters.Add ("@JE", theCW_CHSY.JE);
cmd.Parameters.Add ("@YSDJH", theCW_CHSY.YSDJH);
cmd.Parameters.Add ("@LX", theCW_CHSY.LX);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_CHSY(CW_CHSY theCW_CHSY)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_CHSY对象
/// </summary>
/// <param name="theCW_CHSY">要更新的CW_CHSY对象</param>
public bool UpdateCW_CHSY(SqlConnection cn,CW_CHSY theCW_CHSY)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_CHSY set JGDM=@JGDM, CLR=@CLR, CLSJ=@CLSJ, BZ=@BZ, GZBJ=@GZBJ, JE=@JE, YSDJH=@YSDJH, LX=@LX where CHSYBH=@CHSYBH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@CHSYBH", theCW_CHSY.CHSYBH);
cmd.Parameters.Add ("@JGDM", theCW_CHSY.JGDM);
cmd.Parameters.Add ("@CLR", theCW_CHSY.CLR);
cmd.Parameters.Add ("@CLSJ", theCW_CHSY.CLSJ);
cmd.Parameters.Add ("@BZ", theCW_CHSY.BZ);
cmd.Parameters.Add ("@GZBJ", theCW_CHSY.GZBJ);
cmd.Parameters.Add ("@JE", theCW_CHSY.JE);
cmd.Parameters.Add ("@YSDJH", theCW_CHSY.YSDJH);
cmd.Parameters.Add ("@LX", theCW_CHSY.LX);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_CHSY(CW_CHSY theCW_CHSY)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 删除CW_CHSY对象
/// </summary>
/// <param name="CHSYBH">主键</param>
public bool DelCW_CHSY(SqlConnection cn,string CHSYBH)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_CHSY where CHSYBH=@CHSYBH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@CHSYBH", CHSYBH);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_CHSY(string CHSYBH)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根据主键标识获得CW_CHSY对象
/// </summary>
/// <param name="CHSYBH">主键</param>
public CW_CHSY GetCW_CHSY(string CHSYBH)
{
try
{
CW_CHSY result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_CHSY where CHSYBH=@CHSYBH";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@CHSYBH", CHSYBH);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_CHSY();
if (dr["CHSYBH"] != null)
if (!System.DBNull.Equals(dr["CHSYBH"], System.DBNull.Value))
result.CHSYBH = (string)dr["CHSYBH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["CLR"] != null)
if (!System.DBNull.Equals(dr["CLR"], System.DBNull.Value))
result.CLR = (string)dr["CLR"];
if (dr["CLSJ"] != null)
if (!System.DBNull.Equals(dr["CLSJ"], System.DBNull.Value))
result.CLSJ = (DateTime)dr["CLSJ"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
result.BZ = (string)dr["BZ"];
if (dr["GZBJ"] != null)
if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
result.GZBJ = (string)dr["GZBJ"];
if (dr["JE"] != null)
if (!System.DBNull.Equals(dr["JE"], System.DBNull.Value))
result.JE = (string)dr["JE"];
if (dr["YSDJH"] != null)
if (!System.DBNull.Equals(dr["YSDJH"], System.DBNull.Value))
result.YSDJH = (string)dr["YSDJH"];
if (dr["LX"] != null)
if (!System.DBNull.Equals(dr["LX"], System.DBNull.Value))
result.LX = (string)dr["LX"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_CHSY(string CHSYBH)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_CHSY对象
/// </summary>
public ArrayList FindCW_CHSY()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_CHSY";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_CHSY obj = new CW_CHSY();
if (dr["CHSYBH"] != null)
if (!System.DBNull.Equals(dr["CHSYBH"], System.DBNull.Value))
obj.CHSYBH = (string)dr["CHSYBH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["CLR"] != null)
if (!System.DBNull.Equals(dr["CLR"], System.DBNull.Value))
obj.CLR = (string)dr["CLR"];
if (dr["CLSJ"] != null)
if (!System.DBNull.Equals(dr["CLSJ"], System.DBNull.Value))
obj.CLSJ = (DateTime)dr["CLSJ"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
obj.BZ = (string)dr["BZ"];
if (dr["GZBJ"] != null)
if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
obj.GZBJ = (string)dr["GZBJ"];
if (dr["JE"] != null)
if (!System.DBNull.Equals(dr["JE"], System.DBNull.Value))
obj.JE = (string)dr["JE"];
if (dr["YSDJH"] != null)
if (!System.DBNull.Equals(dr["YSDJH"], System.DBNull.Value))
obj.YSDJH = (string)dr["YSDJH"];
if (dr["LX"] != null)
if (!System.DBNull.Equals(dr["LX"], System.DBNull.Value))
obj.LX = (string)dr["LX"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_CHSY()");
LogService.Write (e.Message);
return null;
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -