📄 cw_yfdxm.cs
字号:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 对象CW_YFDXM的定义
/// 根据表 CW_YFDXM
/// </summary>
public class CW_YFDXM
{
/// <summary>
/// 对象CW_YFDXM的构造函数
/// </summary>
public CW_YFDXM()
{
m_YFDH = "";
m_XH = 0;
m_CPDM = "";
m_ZLZK = "";
m_DJ = 0;
m_SL = 0;
m_JE = 0;
m_YE = 0;
m_ZTBJ = "";
}
private string m_YFDH;
private int m_XH;
private string m_CPDM;
private string m_ZLZK;
private double m_DJ;
private double m_SL;
private double m_JE;
private double m_YE;
private string m_ZTBJ;
/// <summary>
/// 属性 YFDH
/// </summary>
public string YFDH
{
get
{
return m_YFDH;
}
set
{
m_YFDH = 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>
/// 属性 JE
/// </summary>
public double JE
{
get
{
return m_JE;
}
set
{
m_JE = value;
}
}
/// <summary>
/// 属性 YE
/// </summary>
public double YE
{
get
{
return m_YE;
}
set
{
m_YE = value;
}
}
/// <summary>
/// 属性 ZTBJ
/// </summary>
public string ZTBJ
{
get
{
return m_ZTBJ;
}
set
{
m_ZTBJ = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 实现对 CW_YFDXM对象的管理
/// </summary>
public class CW_YFDXMMgr
{
/// <summary>
/// 添加新的CW_YFDXM对象
/// </summary>
/// <param name="theCW_YFDXM">要添加的CW_YFDXM对象</param>
public bool AddCW_YFDXM(System.Data.SqlClient.SqlConnection cn ,CW_YFDXM theCW_YFDXM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
//
string sql;
sql = "insert into CW_YFDXM (YFDH, XH, CPDM, ZLZK, DJ, SL, JE, YE, ZTBJ) values (@YFDH, @XH, @CPDM, @ZLZK, @DJ, @SL, @JE, @YE, @ZTBJ)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YFDH", theCW_YFDXM.YFDH);
cmd.Parameters.Add ("@XH", theCW_YFDXM.XH);
cmd.Parameters.Add ("@CPDM", theCW_YFDXM.CPDM);
cmd.Parameters.Add ("@ZLZK", theCW_YFDXM.ZLZK);
cmd.Parameters.Add ("@DJ", theCW_YFDXM.DJ);
cmd.Parameters.Add ("@SL", theCW_YFDXM.SL);
cmd.Parameters.Add ("@JE", theCW_YFDXM.JE);
cmd.Parameters.Add ("@YE", theCW_YFDXM.YE);
cmd.Parameters.Add ("@ZTBJ", theCW_YFDXM.ZTBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_YFDXM(CW_YFDXM theCW_YFDXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_YFDXM对象
/// </summary>
/// <param name="theCW_YFDXM">要更新的CW_YFDXM对象</param>
public bool UpdateCW_YFDXM(System.Data.SqlClient.SqlConnection cn ,CW_YFDXM theCW_YFDXM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_YFDXM set CPDM=@CPDM, ZLZK=@ZLZK, DJ=@DJ, SL=@SL, JE=@JE, YE=@YE, ZTBJ=@ZTBJ where YFDH=@YFDH and XH=@XH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YFDH", theCW_YFDXM.YFDH);
cmd.Parameters.Add ("@XH", theCW_YFDXM.XH);
cmd.Parameters.Add ("@CPDM", theCW_YFDXM.CPDM);
cmd.Parameters.Add ("@ZLZK", theCW_YFDXM.ZLZK);
cmd.Parameters.Add ("@DJ", theCW_YFDXM.DJ);
cmd.Parameters.Add ("@SL", theCW_YFDXM.SL);
cmd.Parameters.Add ("@JE", theCW_YFDXM.JE);
cmd.Parameters.Add ("@YE", theCW_YFDXM.YE);
cmd.Parameters.Add ("@ZTBJ", theCW_YFDXM.ZTBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_YFDXM(CW_YFDXM theCW_YFDXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 删除CW_YFDXM对象
/// </summary>
/// <param name="YFDH">主键</param>
/// <param name="XH">主键</param>
public bool DelCW_YFDXM(System.Data.SqlClient.SqlConnection cn ,string YFDH, int XH)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_YFDXM where YFDH=@YFDH and XH=@XH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YFDH", YFDH);
cmd.Parameters.Add ("@XH", XH);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_YFDXM(string YFDH, int XH)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根据主键标识获得CW_YFDXM对象
/// </summary>
/// <param name="YFDH">主键</param>
/// <param name="XH">主键</param>
public CW_YFDXM GetCW_YFDXM(string YFDH, int XH)
{
try
{
CW_YFDXM result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_YFDXM where YFDH=@YFDH and XH=@XH";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@YFDH", YFDH);
cmd.Parameters.Add ("@XH", XH);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_YFDXM();
if (dr["YFDH"] != null)
if (!System.DBNull.Equals(dr["YFDH"], System.DBNull.Value))
result.YFDH = (string)dr["YFDH"];
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["JE"] != null)
if (!System.DBNull.Equals(dr["JE"], System.DBNull.Value))
result.JE = (double)dr["JE"];
if (dr["YE"] != null)
if (!System.DBNull.Equals(dr["YE"], System.DBNull.Value))
result.YE = (double)dr["YE"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
result.ZTBJ = (string)dr["ZTBJ"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_YFDXM(string YFDH, int XH)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_YFDXM对象
/// </summary>
public ArrayList FindCW_YFDXM()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_YFDXM";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_YFDXM obj = new CW_YFDXM();
if (dr["YFDH"] != null)
if (!System.DBNull.Equals(dr["YFDH"], System.DBNull.Value))
obj.YFDH = (string)dr["YFDH"];
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["JE"] != null)
if (!System.DBNull.Equals(dr["JE"], System.DBNull.Value))
obj.JE = (double)dr["JE"];
if (dr["YE"] != null)
if (!System.DBNull.Equals(dr["YE"], System.DBNull.Value))
obj.YE = (double)dr["YE"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
obj.ZTBJ = (string)dr["ZTBJ"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_YFDXM()");
LogService.Write (e.Message);
return null;
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -