📄 cw_pzxm.cs
字号:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 对象CW_PZXM的定义
/// 根据表 CW_PZXM
/// </summary>
public class CW_PZXM
{
/// <summary>
/// 对象CW_PZXM的构造函数
/// </summary>
public CW_PZXM()
{
m_PZBH = "";
m_XH = 0;
m_KJND = "";
m_KJQJ = "";
m_JGDM = "";
m_ZY = "";
m_KJKM = "";
m_JFJE = 0;
m_DFJE = 0;
m_BMBH = "";
m_YGBH = "";
m_WLHLX = "";
m_WLHBM = "";
m_BZ = "";
}
private string m_PZBH;
private int m_XH;
private string m_KJND;
private string m_KJQJ;
private string m_JGDM;
private string m_ZY;
private string m_KJKM;
private decimal m_JFJE;
private decimal m_DFJE;
private string m_BMBH;
private string m_YGBH;
private string m_WLHLX;
private string m_WLHBM;
private string m_BZ;
/// <summary>
/// 属性 PZBH
/// </summary>
public string PZBH
{
get
{
return m_PZBH;
}
set
{
m_PZBH = value;
}
}
/// <summary>
/// 属性 XH
/// </summary>
public int XH
{
get
{
return m_XH;
}
set
{
m_XH = value;
}
}
/// <summary>
/// 属性 KJND
/// </summary>
public string KJND
{
get
{
return m_KJND;
}
set
{
m_KJND = value;
}
}
/// <summary>
/// 属性 KJQJ
/// </summary>
public string KJQJ
{
get
{
return m_KJQJ;
}
set
{
m_KJQJ = value;
}
}
/// <summary>
/// 属性 JGDM
/// </summary>
public string JGDM
{
get
{
return m_JGDM;
}
set
{
m_JGDM = value;
}
}
/// <summary>
/// 属性 ZY
/// </summary>
public string ZY
{
get
{
return m_ZY;
}
set
{
m_ZY = value;
}
}
/// <summary>
/// 属性 KJKM
/// </summary>
public string KJKM
{
get
{
return m_KJKM;
}
set
{
m_KJKM = value;
}
}
/// <summary>
/// 属性 JFJE
/// </summary>
public decimal JFJE
{
get
{
return m_JFJE;
}
set
{
m_JFJE = value;
}
}
/// <summary>
/// 属性 DFJE
/// </summary>
public decimal DFJE
{
get
{
return m_DFJE;
}
set
{
m_DFJE = value;
}
}
/// <summary>
/// 属性 BMBH
/// </summary>
public string BMBH
{
get
{
return m_BMBH;
}
set
{
m_BMBH = value;
}
}
/// <summary>
/// 属性 YGBH
/// </summary>
public string YGBH
{
get
{
return m_YGBH;
}
set
{
m_YGBH = value;
}
}
/// <summary>
/// 属性 WLHLX
/// </summary>
public string WLHLX
{
get
{
return m_WLHLX;
}
set
{
m_WLHLX = value;
}
}
/// <summary>
/// 属性 WLHBM
/// </summary>
public string WLHBM
{
get
{
return m_WLHBM;
}
set
{
m_WLHBM = value;
}
}
/// <summary>
/// 属性 BZ
/// </summary>
public string BZ
{
get
{
return m_BZ;
}
set
{
m_BZ = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 实现对 CW_PZXM对象的管理
/// </summary>
public class CW_PZXMMgr
{
/// <summary>
/// 添加新的CW_PZXM对象
/// </summary>
/// <param name="theCW_PZXM">要添加的CW_PZXM对象</param>
public bool AddCW_PZXM(SqlCommand cmd,CW_PZXM theCW_PZXM)
{
try
{
string sql;
sql = "insert into CW_PZXM (PZBH, KJND, KJQJ, JGDM, ZY, KJKM, JFJE, DFJE, BMBH, YGBH, WLHLX, WLHBM, BZ) values (@PZBH, @KJND, @KJQJ, @JGDM, @ZY, @KJKM, @JFJE, @DFJE, @BMBH, @YGBH, @WLHLX, @WLHBM, @BZ)";
cmd.CommandText=sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@PZBH", theCW_PZXM.PZBH);
cmd.Parameters.Add ("@KJND", theCW_PZXM.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_PZXM.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_PZXM.JGDM);
cmd.Parameters.Add ("@ZY", theCW_PZXM.ZY);
cmd.Parameters.Add ("@KJKM", theCW_PZXM.KJKM);
if(theCW_PZXM.JFJE!=0)
{
cmd.Parameters.Add ("@JFJE", theCW_PZXM.JFJE);
}
else
{
cmd.Parameters.Add("@JFJE",SqlDbType.Decimal);
cmd.Parameters["@JFJE"].Value=DBNull.Value;
}
if(theCW_PZXM.DFJE!=0)
{
cmd.Parameters.Add ("@DFJE", theCW_PZXM.DFJE);
}
else
{
cmd.Parameters.Add("@DFJE",SqlDbType.Decimal);
cmd.Parameters["@DFJE"].Value=DBNull.Value;
}
if(theCW_PZXM.BMBH ==null || theCW_PZXM.BMBH =="")
cmd.Parameters.Add ("@BMBH", DBNull.Value);
else
cmd.Parameters.Add ("@BMBH", theCW_PZXM.BMBH);
if(theCW_PZXM.YGBH ==null || theCW_PZXM.YGBH =="")
cmd.Parameters.Add ("@YGBH", DBNull.Value);
else
cmd.Parameters.Add ("@YGBH", theCW_PZXM.YGBH);
cmd.Parameters.Add ("@WLHLX", theCW_PZXM.WLHLX);
cmd.Parameters.Add ("@WLHBM", theCW_PZXM.WLHBM);
cmd.Parameters.Add ("@BZ", theCW_PZXM.BZ);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_PZXM(CW_PZXM theCW_PZXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_PZXM对象
/// </summary>
/// <param name="theCW_PZXM">要更新的CW_PZXM对象</param>
public bool UpdateCW_PZXM(SqlCommand cmd,CW_PZXM theCW_PZXM)
{
try
{
string sql;
sql = "update CW_PZXM set ZY=@ZY, KJKM=@KJKM, JFJE=@JFJE, DFJE=@DFJE, BMBH=@BMBH, YGBH=@YGBH, WLHLX=@WLHLX, WLHBM=@WLHBM, BZ=@BZ where PZBH=@PZBH and XH=@XH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
cmd.CommandText =sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@PZBH", theCW_PZXM.PZBH);
cmd.Parameters.Add ("@XH", theCW_PZXM.XH);
cmd.Parameters.Add ("@KJND", theCW_PZXM.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_PZXM.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_PZXM.JGDM);
cmd.Parameters.Add ("@ZY", theCW_PZXM.ZY);
cmd.Parameters.Add ("@KJKM", theCW_PZXM.KJKM);
if(theCW_PZXM.JFJE!=0)
{
cmd.Parameters.Add ("@JFJE", theCW_PZXM.JFJE);
}
else
{
cmd.Parameters.Add("@JFJE",SqlDbType.Decimal);
cmd.Parameters["@JFJE"].Value=DBNull.Value;
}
if(theCW_PZXM.DFJE!=0)
{
cmd.Parameters.Add ("@DFJE", theCW_PZXM.DFJE);
}
else
{
cmd.Parameters.Add("@DFJE",SqlDbType.Decimal);
cmd.Parameters["@DFJE"].Value=DBNull.Value;
}
if(theCW_PZXM.BMBH ==null || theCW_PZXM.BMBH =="")
cmd.Parameters.Add ("@BMBH", DBNull.Value);
else
cmd.Parameters.Add ("@BMBH", theCW_PZXM.BMBH);
if(theCW_PZXM.YGBH ==null || theCW_PZXM.YGBH =="")
cmd.Parameters.Add ("@YGBH", DBNull.Value);
else
cmd.Parameters.Add ("@YGBH", theCW_PZXM.YGBH);
cmd.Parameters.Add ("@WLHLX", theCW_PZXM.WLHLX);
cmd.Parameters.Add ("@WLHBM", theCW_PZXM.WLHBM);
cmd.Parameters.Add ("@BZ", theCW_PZXM.BZ);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_PZXM(CW_PZXM theCW_PZXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 删除CW_PZXM对象
/// </summary>
/// <param name="PZBH">主键</param>
/// <param name="XH">主键</param>
/// <param name="KJND">主键</param>
/// <param name="KJQJ">主键</param>
/// <param name="JGDM">主键</param>
public bool DelCW_PZXM(SqlCommand cmd,string PZBH, string KJND, string KJQJ, string JGDM,int XH)
{
try
{
string sql;
sql = "delete from CW_PZXM where PZBH=@PZBH and XH=@XH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@PZBH", PZBH);
cmd.Parameters.Add ("@XH", XH);
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_PZXM(string PZBH, int XH, string KJND, string KJQJ, string JGDM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根据主键标识获得CW_PZXM对象
/// </summary>
/// <param name="PZBH">主键</param>
/// <param name="XH">主键</param>
/// <param name="KJND">主键</param>
/// <param name="KJQJ">主键</param>
/// <param name="JGDM">主键</param>
public CW_PZXM GetCW_PZXM(string PZBH, int XH, string KJND, string KJQJ, string JGDM)
{
try
{
CW_PZXM result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_PZXM where PZBH=@PZBH and XH=@XH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@PZBH", PZBH);
cmd.Parameters.Add ("@XH", XH);
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_PZXM();
if (dr["PZBH"] != null)
if (!System.DBNull.Equals(dr["PZBH"], System.DBNull.Value))
result.PZBH = (string)dr["PZBH"];
if (dr["XH"] != null)
if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
result.XH = (int)dr["XH"];
if (dr["KJND"] != null)
if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
result.KJND = (string)dr["KJND"];
if (dr["KJQJ"] != null)
if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
result.KJQJ = (string)dr["KJQJ"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["ZY"] != null)
if (!System.DBNull.Equals(dr["ZY"], System.DBNull.Value))
result.ZY = (string)dr["ZY"];
if (dr["KJKM"] != null)
if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
result.KJKM = (string)dr["KJKM"];
if (dr["JFJE"] != null)
if (!System.DBNull.Equals(dr["JFJE"], System.DBNull.Value))
result.JFJE = (decimal)dr["JFJE"];
if (dr["DFJE"] != null)
if (!System.DBNull.Equals(dr["DFJE"], System.DBNull.Value))
result.DFJE = (decimal)dr["DFJE"];
if (dr["BMBH"] != null)
if (!System.DBNull.Equals(dr["BMBH"], System.DBNull.Value))
result.BMBH = (string)dr["BMBH"];
if (dr["YGBH"] != null)
if (!System.DBNull.Equals(dr["YGBH"], System.DBNull.Value))
result.YGBH = (string)dr["YGBH"];
if (dr["WLHLX"] != null)
if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
result.WLHLX = (string)dr["WLHLX"];
if (dr["WLHBM"] != null)
if (!System.DBNull.Equals(dr["WLHBM"], System.DBNull.Value))
result.WLHBM = (string)dr["WLHBM"];
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_PZXM(string PZBH, int XH, string KJND, string KJQJ, string JGDM)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_PZXM对象
/// </summary>
public ArrayList FindCW_PZXM()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_PZXM";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_PZXM obj = new CW_PZXM();
if (dr["PZBH"] != null)
if (!System.DBNull.Equals(dr["PZBH"], System.DBNull.Value))
obj.PZBH = (string)dr["PZBH"];
if (dr["XH"] != null)
if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
obj.XH = (int)dr["XH"];
if (dr["KJND"] != null)
if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
obj.KJND = (string)dr["KJND"];
if (dr["KJQJ"] != null)
if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
obj.KJQJ = (string)dr["KJQJ"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["ZY"] != null)
if (!System.DBNull.Equals(dr["ZY"], System.DBNull.Value))
obj.ZY = (string)dr["ZY"];
if (dr["KJKM"] != null)
if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
obj.KJKM = (string)dr["KJKM"];
if (dr["JFJE"] != null)
if (!System.DBNull.Equals(dr["JFJE"], System.DBNull.Value))
obj.JFJE = (decimal)dr["JFJE"];
if (dr["DFJE"] != null)
if (!System.DBNull.Equals(dr["DFJE"], System.DBNull.Value))
obj.DFJE = (decimal)dr["DFJE"];
if (dr["BMBH"] != null)
if (!System.DBNull.Equals(dr["BMBH"], System.DBNull.Value))
obj.BMBH = (string)dr["BMBH"];
if (dr["YGBH"] != null)
if (!System.DBNull.Equals(dr["YGBH"], System.DBNull.Value))
obj.YGBH = (string)dr["YGBH"];
if (dr["WLHLX"] != null)
if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
obj.WLHLX = (string)dr["WLHLX"];
if (dr["WLHBM"] != null)
if (!System.DBNull.Equals(dr["WLHBM"], System.DBNull.Value))
obj.WLHBM = (string)dr["WLHBM"];
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_PZXM()");
LogService.Write (e.Message);
return null;
}
}
public string GetYJKMCD()
{
string YJKMCD="NULL";
string sql=string.Format("select CD from CW_KJKMJB where KMJB='1'");
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
SqlCommand cmd=new SqlCommand(sql,cn);
cn.Open();
SqlDataReader dr=cmd.ExecuteReader();
if(dr.Read())
{
YJKMCD=dr["CD"].ToString();
}
cn.Close();
return YJKMCD;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -