?? cw_tjdxm.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對象CW_TJDXM的定義
/// 根據表 CW_TJDXM
/// </summary>
public class CW_TJDXM
{
/// <summary>
/// 對象CW_TJDXM的構造函數
/// </summary>
public CW_TJDXM()
{
m_TJDH = "";
m_CKDM = "";
m_KWDM = "";
m_CPDM = "";
m_ZLZK = "";
m_PC = "";
m_TZSL = 0;
m_TZQJG = 0;
m_TZHJG = 0;
m_TZYY = "";
m_SHYJ = "";
}
private string m_TJDH;
private string m_CKDM;
private string m_KWDM;
private string m_CPDM;
private string m_ZLZK;
private string m_PC;
private double m_TZSL;
private double m_TZQJG;
private double m_TZHJG;
private string m_TZYY;
private string m_SHYJ;
/// <summary>
/// 屬性 TJDH
/// </summary>
public string TJDH
{
get
{
return m_TJDH;
}
set
{
m_TJDH = value;
}
}
/// <summary>
/// 屬性 CKDM
/// </summary>
public string CKDM
{
get
{
return m_CKDM;
}
set
{
m_CKDM = value;
}
}
/// <summary>
/// 屬性 KWDM
/// </summary>
public string KWDM
{
get
{
return m_KWDM;
}
set
{
m_KWDM = 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>
/// 屬性 PC
/// </summary>
public string PC
{
get
{
return m_PC;
}
set
{
m_PC = value;
}
}
/// <summary>
/// 屬性 TZSL
/// </summary>
public double TZSL
{
get
{
return m_TZSL;
}
set
{
m_TZSL = value;
}
}
/// <summary>
/// 屬性 TZQJG
/// </summary>
public double TZQJG
{
get
{
return m_TZQJG;
}
set
{
m_TZQJG = value;
}
}
/// <summary>
/// 屬性 TZHJG
/// </summary>
public double TZHJG
{
get
{
return m_TZHJG;
}
set
{
m_TZHJG = value;
}
}
/// <summary>
/// 屬性 TZYY
/// </summary>
public string TZYY
{
get
{
return m_TZYY;
}
set
{
m_TZYY = value;
}
}
/// <summary>
/// 屬性 SHYJ
/// </summary>
public string SHYJ
{
get
{
return m_SHYJ;
}
set
{
m_SHYJ = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實現對 CW_TJDXM對象的管理
/// </summary>
public class CW_TJDXMMgr
{
/// <summary>
/// 添加新的CW_TJDXM對象
/// </summary>
/// <param name="theCW_TJDXM">要添加的CW_TJDXM對象</param>
public bool AddCW_TJDXM(SqlConnection cn,CW_TJDXM theCW_TJDXM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_TJDXM (TJDH, CKDM, KWDM, CPDM, ZLZK, PC, TZSL, TZQJG, TZHJG, TZYY, SHYJ) values (@TJDH, @CKDM, @KWDM, @CPDM, @ZLZK, @PC, @TZSL, @TZQJG, @TZHJG, @TZYY, @SHYJ)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@TJDH", theCW_TJDXM.TJDH);
cmd.Parameters.Add ("@CKDM", theCW_TJDXM.CKDM);
cmd.Parameters.Add ("@KWDM", theCW_TJDXM.KWDM);
cmd.Parameters.Add ("@CPDM", theCW_TJDXM.CPDM);
cmd.Parameters.Add ("@ZLZK", theCW_TJDXM.ZLZK);
cmd.Parameters.Add ("@PC", theCW_TJDXM.PC);
cmd.Parameters.Add ("@TZSL", theCW_TJDXM.TZSL);
cmd.Parameters.Add ("@TZQJG", theCW_TJDXM.TZQJG);
cmd.Parameters.Add ("@TZHJG", theCW_TJDXM.TZHJG);
cmd.Parameters.Add ("@TZYY", theCW_TJDXM.TZYY);
cmd.Parameters.Add ("@SHYJ", theCW_TJDXM.SHYJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_TJDXM(CW_TJDXM theCW_TJDXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_TJDXM對象
/// </summary>
/// <param name="theCW_TJDXM">要更新的CW_TJDXM對象</param>
public bool UpdateCW_TJDXM(SqlConnection cn,CW_TJDXM theCW_TJDXM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_TJDXM set TZSL=@TZSL, TZQJG=@TZQJG, TZHJG=@TZHJG, TZYY=@TZYY, SHYJ=@SHYJ where TJDH=@TJDH and CKDM=@CKDM and KWDM=@KWDM and CPDM=@CPDM and ZLZK=@ZLZK and PC=@PC";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@TJDH", theCW_TJDXM.TJDH);
cmd.Parameters.Add ("@CKDM", theCW_TJDXM.CKDM);
cmd.Parameters.Add ("@KWDM", theCW_TJDXM.KWDM);
cmd.Parameters.Add ("@CPDM", theCW_TJDXM.CPDM);
cmd.Parameters.Add ("@ZLZK", theCW_TJDXM.ZLZK);
cmd.Parameters.Add ("@PC", theCW_TJDXM.PC);
cmd.Parameters.Add ("@TZSL", theCW_TJDXM.TZSL);
cmd.Parameters.Add ("@TZQJG", theCW_TJDXM.TZQJG);
cmd.Parameters.Add ("@TZHJG", theCW_TJDXM.TZHJG);
cmd.Parameters.Add ("@TZYY", theCW_TJDXM.TZYY);
cmd.Parameters.Add ("@SHYJ", theCW_TJDXM.SHYJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_TJDXM(CW_TJDXM theCW_TJDXM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_TJDXM對象
/// </summary>
/// <param name="TJDH">主鍵</param>
/// <param name="CKDM">主鍵</param>
/// <param name="KWDM">主鍵</param>
/// <param name="CPDM">主鍵</param>
/// <param name="ZLZK">主鍵</param>
/// <param name="PC">主鍵</param>
public bool DelCW_TJDXM(SqlConnection cn,string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_TJDXM where TJDH=@TJDH and CKDM=@CKDM and KWDM=@KWDM and CPDM=@CPDM and ZLZK=@ZLZK and PC=@PC";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@TJDH", TJDH);
cmd.Parameters.Add ("@CKDM", CKDM);
cmd.Parameters.Add ("@KWDM", KWDM);
cmd.Parameters.Add ("@CPDM", CPDM);
cmd.Parameters.Add ("@ZLZK", ZLZK);
cmd.Parameters.Add ("@PC", PC);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_TJDXM(string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_TJDXM對象
/// </summary>
/// <param name="TJDH">主鍵</param>
/// <param name="CKDM">主鍵</param>
/// <param name="KWDM">主鍵</param>
/// <param name="CPDM">主鍵</param>
/// <param name="ZLZK">主鍵</param>
/// <param name="PC">主鍵</param>
public CW_TJDXM GetCW_TJDXM(string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)
{
try
{
CW_TJDXM result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_TJDXM where TJDH=@TJDH and CKDM=@CKDM and KWDM=@KWDM and CPDM=@CPDM and ZLZK=@ZLZK and PC=@PC";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@TJDH", TJDH);
cmd.Parameters.Add ("@CKDM", CKDM);
cmd.Parameters.Add ("@KWDM", KWDM);
cmd.Parameters.Add ("@CPDM", CPDM);
cmd.Parameters.Add ("@ZLZK", ZLZK);
cmd.Parameters.Add ("@PC", PC);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_TJDXM();
if (dr["TJDH"] != null)
if (!System.DBNull.Equals(dr["TJDH"], System.DBNull.Value))
result.TJDH = (string)dr["TJDH"];
if (dr["CKDM"] != null)
if (!System.DBNull.Equals(dr["CKDM"], System.DBNull.Value))
result.CKDM = (string)dr["CKDM"];
if (dr["KWDM"] != null)
if (!System.DBNull.Equals(dr["KWDM"], System.DBNull.Value))
result.KWDM = (string)dr["KWDM"];
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["PC"] != null)
if (!System.DBNull.Equals(dr["PC"], System.DBNull.Value))
result.PC = (string)dr["PC"];
if (dr["TZSL"] != null)
if (!System.DBNull.Equals(dr["TZSL"], System.DBNull.Value))
result.TZSL = (double)dr["TZSL"];
if (dr["TZQJG"] != null)
if (!System.DBNull.Equals(dr["TZQJG"], System.DBNull.Value))
result.TZQJG = (double)dr["TZQJG"];
if (dr["TZHJG"] != null)
if (!System.DBNull.Equals(dr["TZHJG"], System.DBNull.Value))
result.TZHJG = (double)dr["TZHJG"];
if (dr["TZYY"] != null)
if (!System.DBNull.Equals(dr["TZYY"], System.DBNull.Value))
result.TZYY = (string)dr["TZYY"];
if (dr["SHYJ"] != null)
if (!System.DBNull.Equals(dr["SHYJ"], System.DBNull.Value))
result.SHYJ = (string)dr["SHYJ"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_TJDXM(string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_TJDXM對象
/// </summary>
public ArrayList FindCW_TJDXM()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_TJDXM";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_TJDXM obj = new CW_TJDXM();
if (dr["TJDH"] != null)
if (!System.DBNull.Equals(dr["TJDH"], System.DBNull.Value))
obj.TJDH = (string)dr["TJDH"];
if (dr["CKDM"] != null)
if (!System.DBNull.Equals(dr["CKDM"], System.DBNull.Value))
obj.CKDM = (string)dr["CKDM"];
if (dr["KWDM"] != null)
if (!System.DBNull.Equals(dr["KWDM"], System.DBNull.Value))
obj.KWDM = (string)dr["KWDM"];
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["PC"] != null)
if (!System.DBNull.Equals(dr["PC"], System.DBNull.Value))
obj.PC = (string)dr["PC"];
if (dr["TZSL"] != null)
if (!System.DBNull.Equals(dr["TZSL"], System.DBNull.Value))
obj.TZSL = (double)dr["TZSL"];
if (dr["TZQJG"] != null)
if (!System.DBNull.Equals(dr["TZQJG"], System.DBNull.Value))
obj.TZQJG = (double)dr["TZQJG"];
if (dr["TZHJG"] != null)
if (!System.DBNull.Equals(dr["TZHJG"], System.DBNull.Value))
obj.TZHJG = (double)dr["TZHJG"];
if (dr["TZYY"] != null)
if (!System.DBNull.Equals(dr["TZYY"], System.DBNull.Value))
obj.TZYY = (string)dr["TZYY"];
if (dr["SHYJ"] != null)
if (!System.DBNull.Equals(dr["SHYJ"], System.DBNull.Value))
obj.SHYJ = (string)dr["SHYJ"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_TJDXM()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -