?? cw_hxgx.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對象CW_HXGX的定義
/// 根據表 CW_HXGX
/// </summary>
public class CW_HXGX
{
/// <summary>
/// 對象CW_HXGX的構造函數
/// </summary>
public CW_HXGX()
{
m_HXDH = "";
m_BHXDH = "";
m_HXDLX = 0;
m_BHXDLX = 0;
m_HXJE = 0;
m_GZBJ = "";
}
private string m_HXDH;
private string m_BHXDH;
private int m_HXDLX;
private int m_BHXDLX;
private double m_HXJE;
private string m_GZBJ;
/// <summary>
/// 屬性 HXDH
/// </summary>
public string HXDH
{
get
{
return m_HXDH;
}
set
{
m_HXDH = value;
}
}
/// <summary>
/// 屬性 BHXDH
/// </summary>
public string BHXDH
{
get
{
return m_BHXDH;
}
set
{
m_BHXDH = value;
}
}
/// <summary>
/// 屬性 HXDLX
/// </summary>
public int HXDLX
{
get
{
return m_HXDLX;
}
set
{
m_HXDLX = value;
}
}
/// <summary>
/// 屬性 BHXDLX
/// </summary>
public int BHXDLX
{
get
{
return m_BHXDLX;
}
set
{
m_BHXDLX = value;
}
}
/// <summary>
/// 屬性 HXJE
/// </summary>
public double HXJE
{
get
{
return m_HXJE;
}
set
{
m_HXJE = value;
}
}
/// <summary>
/// 屬性 GZBJ
/// </summary>
public string GZBJ
{
get
{
return m_GZBJ;
}
set
{
m_GZBJ = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實現對 CW_HXGX對象的管理
/// </summary>
public class CW_HXGXMgr
{
/// <summary>
/// 添加新的CW_HXGX對象
/// </summary>
/// <param name="theCW_HXGX">要添加的CW_HXGX對象</param>
public bool AddCW_HXGX(System.Data.SqlClient.SqlConnection cn ,CW_HXGX theCW_HXGX)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_HXGX (HXDH, BHXDH, HXDLX, BHXDLX, HXJE, GZBJ) values (@HXDH, @BHXDH, @HXDLX, @BHXDLX, @HXJE, @GZBJ)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@HXDH", theCW_HXGX.HXDH);
cmd.Parameters.Add ("@BHXDH", theCW_HXGX.BHXDH);
cmd.Parameters.Add ("@HXDLX", theCW_HXGX.HXDLX);
cmd.Parameters.Add ("@BHXDLX", theCW_HXGX.BHXDLX);
cmd.Parameters.Add ("@HXJE", theCW_HXGX.HXJE);
cmd.Parameters.Add ("@GZBJ", theCW_HXGX.GZBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_HXGX(CW_HXGX theCW_HXGX)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_HXGX對象
/// </summary>
/// <param name="theCW_HXGX">要更新的CW_HXGX對象</param>
public bool UpdateCW_HXGX(System.Data.SqlClient.SqlConnection cn ,CW_HXGX theCW_HXGX)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_HXGX set HXDLX=@HXDLX, BHXDLX=@BHXDLX, HXJE=@HXJE, GZBJ=@GZBJ where HXDH=@HXDH and BHXDH=@BHXDH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@HXDH", theCW_HXGX.HXDH);
cmd.Parameters.Add ("@BHXDH", theCW_HXGX.BHXDH);
cmd.Parameters.Add ("@HXDLX", theCW_HXGX.HXDLX);
cmd.Parameters.Add ("@BHXDLX", theCW_HXGX.BHXDLX);
cmd.Parameters.Add ("@HXJE", theCW_HXGX.HXJE);
cmd.Parameters.Add ("@GZBJ", theCW_HXGX.GZBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_HXGX(CW_HXGX theCW_HXGX)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_HXGX對象
/// </summary>
/// <param name="HXDH">主鍵</param>
/// <param name="BHXDH">主鍵</param>
public bool DelCW_HXGX(System.Data.SqlClient.SqlConnection cn ,string HXDH, string BHXDH)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_HXGX where HXDH=@HXDH and BHXDH=@BHXDH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@HXDH", HXDH);
cmd.Parameters.Add ("@BHXDH", BHXDH);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_HXGX(string HXDH, string BHXDH)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_HXGX對象
/// </summary>
/// <param name="HXDH">主鍵</param>
/// <param name="BHXDH">主鍵</param>
public CW_HXGX GetCW_HXGX(string HXDH, string BHXDH)
{
try
{
CW_HXGX result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_HXGX where HXDH=@HXDH and BHXDH=@BHXDH";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@HXDH", HXDH);
cmd.Parameters.Add ("@BHXDH", BHXDH);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_HXGX();
if (dr["HXDH"] != null)
if (!System.DBNull.Equals(dr["HXDH"], System.DBNull.Value))
result.HXDH = (string)dr["HXDH"];
if (dr["BHXDH"] != null)
if (!System.DBNull.Equals(dr["BHXDH"], System.DBNull.Value))
result.BHXDH = (string)dr["BHXDH"];
if (dr["HXDLX"] != null)
if (!System.DBNull.Equals(dr["HXDLX"], System.DBNull.Value))
result.HXDLX = (int)dr["HXDLX"];
if (dr["BHXDLX"] != null)
if (!System.DBNull.Equals(dr["BHXDLX"], System.DBNull.Value))
result.BHXDLX = (int)dr["BHXDLX"];
if (dr["HXJE"] != null)
if (!System.DBNull.Equals(dr["HXJE"], System.DBNull.Value))
result.HXJE = (double)dr["HXJE"];
if (dr["GZBJ"] != null)
if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
result.GZBJ = (string)dr["GZBJ"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_HXGX(string HXDH, string BHXDH)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_HXGX對象
/// </summary>
public ArrayList FindCW_HXGX()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_HXGX";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_HXGX obj = new CW_HXGX();
if (dr["HXDH"] != null)
if (!System.DBNull.Equals(dr["HXDH"], System.DBNull.Value))
obj.HXDH = (string)dr["HXDH"];
if (dr["BHXDH"] != null)
if (!System.DBNull.Equals(dr["BHXDH"], System.DBNull.Value))
obj.BHXDH = (string)dr["BHXDH"];
if (dr["HXDLX"] != null)
if (!System.DBNull.Equals(dr["HXDLX"], System.DBNull.Value))
obj.HXDLX = (int)dr["HXDLX"];
if (dr["BHXDLX"] != null)
if (!System.DBNull.Equals(dr["BHXDLX"], System.DBNull.Value))
obj.BHXDLX = (int)dr["BHXDLX"];
if (dr["HXJE"] != null)
if (!System.DBNull.Equals(dr["HXJE"], System.DBNull.Value))
obj.HXJE = (double)dr["HXJE"];
if (dr["GZBJ"] != null)
if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
obj.GZBJ = (string)dr["GZBJ"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_HXGX()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -