?? cw_zjzy.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對象CW_ZJZY的定義
/// 根據表 CW_ZJZY
/// </summary>
public class CW_ZJZY
{
/// <summary>
/// 對象CW_ZJZY的構造函數
/// </summary>
public CW_ZJZY()
{
m_JGDM = "";
m_ND = "";
m_ZYJE = 0;
m_BL = 0;
m_CZBL = 0;
}
private string m_JGDM;
private string m_ND;
private double m_ZYJE;
private double m_BL;
private double m_CZBL;
/// <summary>
/// 屬性 JGDM
/// </summary>
public string JGDM
{
get
{
return m_JGDM;
}
set
{
m_JGDM = value;
}
}
/// <summary>
/// 屬性 ND
/// </summary>
public string ND
{
get
{
return m_ND;
}
set
{
m_ND = value;
}
}
/// <summary>
/// 屬性 ZYJE
/// </summary>
public double ZYJE
{
get
{
return m_ZYJE;
}
set
{
m_ZYJE = value;
}
}
/// <summary>
/// 屬性 BL
/// </summary>
public double BL
{
get
{
return m_BL;
}
set
{
m_BL = value;
}
}
/// <summary>
/// 屬性 CZBL
/// </summary>
public double CZBL
{
get
{
return m_CZBL;
}
set
{
m_CZBL = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實現對 CW_ZJZY對象的管理
/// </summary>
public class CW_ZJZYMgr
{
/// <summary>
/// 添加新的CW_ZJZY對象
/// </summary>
/// <param name="theCW_ZJZY">要添加的CW_ZJZY對象</param>
public bool AddCW_ZJZY(System.Data.SqlClient.SqlConnection cn ,CW_ZJZY theCW_ZJZY)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_ZJZY (JGDM, ND, ZYJE, BL, CZBL) values (@JGDM, @ND, @ZYJE, @BL, @CZBL)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@JGDM", theCW_ZJZY.JGDM);
cmd.Parameters.Add ("@ND", theCW_ZJZY.ND);
cmd.Parameters.Add ("@ZYJE", theCW_ZJZY.ZYJE);
cmd.Parameters.Add ("@BL", theCW_ZJZY.BL);
cmd.Parameters.Add ("@CZBL", theCW_ZJZY.CZBL);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_ZJZY(CW_ZJZY theCW_ZJZY)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_ZJZY對象
/// </summary>
/// <param name="theCW_ZJZY">要更新的CW_ZJZY對象</param>
public bool UpdateCW_ZJZY(System.Data.SqlClient.SqlConnection cn ,CW_ZJZY theCW_ZJZY)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_ZJZY set ZYJE=@ZYJE, BL=@BL, CZBL=@CZBL where JGDM=@JGDM and ND=@ND";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@JGDM", theCW_ZJZY.JGDM);
cmd.Parameters.Add ("@ND", theCW_ZJZY.ND);
cmd.Parameters.Add ("@ZYJE", theCW_ZJZY.ZYJE);
cmd.Parameters.Add ("@BL", theCW_ZJZY.BL);
cmd.Parameters.Add ("@CZBL", theCW_ZJZY.CZBL);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_ZJZY(CW_ZJZY theCW_ZJZY)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_ZJZY對象
/// </summary>
/// <param name="JGDM">主鍵</param>
/// <param name="ND">主鍵</param>
public bool DelCW_ZJZY(System.Data.SqlClient.SqlConnection cn ,string JGDM, string ND)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_ZJZY where JGDM=@JGDM and ND=@ND";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.Parameters.Add ("@ND", ND);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_ZJZY(string JGDM, string ND)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_ZJZY對象
/// </summary>
/// <param name="JGDM">主鍵</param>
/// <param name="ND">主鍵</param>
public CW_ZJZY GetCW_ZJZY(string JGDM, string ND)
{
try
{
CW_ZJZY result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_ZJZY where JGDM=@JGDM and ND=@ND";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.Parameters.Add ("@ND", ND);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_ZJZY();
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["ND"] != null)
if (!System.DBNull.Equals(dr["ND"], System.DBNull.Value))
result.ND = (string)dr["ND"];
if (dr["ZYJE"] != null)
if (!System.DBNull.Equals(dr["ZYJE"], System.DBNull.Value))
result.ZYJE = (double)dr["ZYJE"];
if (dr["BL"] != null)
if (!System.DBNull.Equals(dr["BL"], System.DBNull.Value))
result.BL = (double)dr["BL"];
if (dr["CZBL"] != null)
if (!System.DBNull.Equals(dr["CZBL"], System.DBNull.Value))
result.CZBL = (double)dr["CZBL"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_ZJZY(string JGDM, string ND)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_ZJZY對象
/// </summary>
public ArrayList FindCW_ZJZY()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_ZJZY";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_ZJZY obj = new CW_ZJZY();
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["ND"] != null)
if (!System.DBNull.Equals(dr["ND"], System.DBNull.Value))
obj.ND = (string)dr["ND"];
if (dr["ZYJE"] != null)
if (!System.DBNull.Equals(dr["ZYJE"], System.DBNull.Value))
obj.ZYJE = (double)dr["ZYJE"];
if (dr["BL"] != null)
if (!System.DBNull.Equals(dr["BL"], System.DBNull.Value))
obj.BL = (double)dr["BL"];
if (dr["CZBL"] != null)
if (!System.DBNull.Equals(dr["CZBL"], System.DBNull.Value))
obj.CZBL = (double)dr["CZBL"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_ZJZY()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -