?? cw_fkd.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對象CW_FKD的定義
/// 根據表 CW_FKD
/// </summary>
public class CW_FKD
{
/// <summary>
/// 對象CW_FKD的構造函數
/// </summary>
public CW_FKD()
{
m_FKDH = "";
m_JGDM = "";
m_WLHBH = "";
m_WLHLX = "";
m_YSDJH = "";
m_DJLX = 0;
m_HBLX = "";
m_YFJE = 0;
m_FKRQ = DateTime.Now;
m_HXYE = 0;
m_ZDR = "";
m_ZTBJ = "";
m_BZ = "";
m_GZBJ = "";
}
private string m_FKDH;
private string m_JGDM;
private string m_WLHBH;
private string m_WLHLX;
private string m_YSDJH;
private int m_DJLX;
private string m_HBLX;
private double m_YFJE;
private DateTime m_FKRQ;
private double m_HXYE;
private string m_ZDR;
private string m_ZTBJ;
private string m_BZ;
private string m_GZBJ;
/// <summary>
/// 屬性 FKDH
/// </summary>
public string FKDH
{
get
{
return m_FKDH;
}
set
{
m_FKDH = value;
}
}
/// <summary>
/// 屬性 JGDM
/// </summary>
public string JGDM
{
get
{
return m_JGDM;
}
set
{
m_JGDM = value;
}
}
/// <summary>
/// 屬性 WLHBH
/// </summary>
public string WLHBH
{
get
{
return m_WLHBH;
}
set
{
m_WLHBH = value;
}
}
/// <summary>
/// 屬性 WLHLX
/// </summary>
public string WLHLX
{
get
{
return m_WLHLX;
}
set
{
m_WLHLX = value;
}
}
/// <summary>
/// 屬性 YSDJH
/// </summary>
public string YSDJH
{
get
{
return m_YSDJH;
}
set
{
m_YSDJH = value;
}
}
/// <summary>
/// 屬性 DJLX
/// </summary>
public int DJLX
{
get
{
return m_DJLX;
}
set
{
m_DJLX = value;
}
}
/// <summary>
/// 屬性 HBLX
/// </summary>
public string HBLX
{
get
{
return m_HBLX;
}
set
{
m_HBLX = value;
}
}
/// <summary>
/// 屬性 YFJE
/// </summary>
public double YFJE
{
get
{
return m_YFJE;
}
set
{
m_YFJE = value;
}
}
/// <summary>
/// 屬性 FKRQ
/// </summary>
public DateTime FKRQ
{
get
{
return m_FKRQ;
}
set
{
m_FKRQ = value;
}
}
/// <summary>
/// 屬性 HXYE
/// </summary>
public double HXYE
{
get
{
return m_HXYE;
}
set
{
m_HXYE = value;
}
}
/// <summary>
/// 屬性 ZDR
/// </summary>
public string ZDR
{
get
{
return m_ZDR;
}
set
{
m_ZDR = value;
}
}
/// <summary>
/// 屬性 ZTBJ
/// </summary>
public string ZTBJ
{
get
{
return m_ZTBJ;
}
set
{
m_ZTBJ = value;
}
}
/// <summary>
/// 屬性 BZ
/// </summary>
public string BZ
{
get
{
return m_BZ;
}
set
{
m_BZ = value;
}
}
/// <summary>
/// 屬性 GZBJ
/// </summary>
public string GZBJ
{
get
{
return m_GZBJ;
}
set
{
m_GZBJ = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實現對 CW_FKD對象的管理
/// </summary>
public class CW_FKDMgr
{
/// <summary>
/// 添加新的CW_FKD對象
/// </summary>
/// <param name="theCW_FKD">要添加的CW_FKD對象</param>
public bool AddCW_FKD(System.Data.SqlClient.SqlConnection cn ,CW_FKD theCW_FKD)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_FKD (FKDH, JGDM, WLHBH, WLHLX, YSDJH, DJLX, HBLX, YFJE, FKRQ, HXYE, ZDR, ZTBJ, BZ, GZBJ) values (@FKDH, @JGDM, @WLHBH, @WLHLX, @YSDJH, @DJLX, @HBLX, @YFJE, @FKRQ, @HXYE, @ZDR, @ZTBJ, @BZ, @GZBJ)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@FKDH", theCW_FKD.FKDH);
cmd.Parameters.Add ("@JGDM", theCW_FKD.JGDM);
cmd.Parameters.Add ("@WLHBH", theCW_FKD.WLHBH);
cmd.Parameters.Add ("@WLHLX", theCW_FKD.WLHLX);
cmd.Parameters.Add ("@YSDJH", theCW_FKD.YSDJH);
cmd.Parameters.Add ("@DJLX", theCW_FKD.DJLX);
cmd.Parameters.Add ("@HBLX", theCW_FKD.HBLX);
cmd.Parameters.Add ("@YFJE", theCW_FKD.YFJE);
cmd.Parameters.Add ("@FKRQ", theCW_FKD.FKRQ);
cmd.Parameters.Add ("@HXYE", theCW_FKD.HXYE);
cmd.Parameters.Add ("@ZDR", theCW_FKD.ZDR);
cmd.Parameters.Add ("@ZTBJ", theCW_FKD.ZTBJ);
cmd.Parameters.Add ("@BZ", theCW_FKD.BZ);
cmd.Parameters.Add ("@GZBJ", theCW_FKD.GZBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_FKD(CW_FKD theCW_FKD)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_FKD對象
/// </summary>
/// <param name="theCW_FKD">要更新的CW_FKD對象</param>
public bool UpdateCW_FKD(System.Data.SqlClient.SqlConnection cn ,CW_FKD theCW_FKD)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_FKD set JGDM=@JGDM, WLHBH=@WLHBH, WLHLX=@WLHLX, YSDJH=@YSDJH, DJLX=@DJLX, HBLX=@HBLX, YFJE=@YFJE, FKRQ=@FKRQ, HXYE=@HXYE, ZDR=@ZDR, ZTBJ=@ZTBJ, BZ=@BZ, GZBJ=@GZBJ where FKDH=@FKDH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@FKDH", theCW_FKD.FKDH);
cmd.Parameters.Add ("@JGDM", theCW_FKD.JGDM);
cmd.Parameters.Add ("@WLHBH", theCW_FKD.WLHBH);
cmd.Parameters.Add ("@WLHLX", theCW_FKD.WLHLX);
cmd.Parameters.Add ("@YSDJH", theCW_FKD.YSDJH);
cmd.Parameters.Add ("@DJLX", theCW_FKD.DJLX);
cmd.Parameters.Add ("@HBLX", theCW_FKD.HBLX);
cmd.Parameters.Add ("@YFJE", theCW_FKD.YFJE);
cmd.Parameters.Add ("@FKRQ", theCW_FKD.FKRQ);
cmd.Parameters.Add ("@HXYE", theCW_FKD.HXYE);
cmd.Parameters.Add ("@ZDR", theCW_FKD.ZDR);
cmd.Parameters.Add ("@ZTBJ", theCW_FKD.ZTBJ);
cmd.Parameters.Add ("@BZ", theCW_FKD.BZ);
cmd.Parameters.Add ("@GZBJ", theCW_FKD.GZBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_FKD(CW_FKD theCW_FKD)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_FKD對象
/// </summary>
/// <param name="FKDH">主鍵</param>
public bool DelCW_FKD(System.Data.SqlClient.SqlConnection cn ,string FKDH)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_FKD where FKDH=@FKDH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@FKDH", FKDH);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_FKD(string FKDH)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_FKD對象
/// </summary>
/// <param name="FKDH">主鍵</param>
public CW_FKD GetCW_FKD(string FKDH)
{
try
{
CW_FKD result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_FKD where FKDH=@FKDH";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@FKDH", FKDH);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_FKD();
if (dr["FKDH"] != null)
if (!System.DBNull.Equals(dr["FKDH"], System.DBNull.Value))
result.FKDH = (string)dr["FKDH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["WLHBH"] != null)
if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
result.WLHBH = (string)dr["WLHBH"];
if (dr["WLHLX"] != null)
if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
result.WLHLX = (string)dr["WLHLX"];
if (dr["YSDJH"] != null)
if (!System.DBNull.Equals(dr["YSDJH"], System.DBNull.Value))
result.YSDJH = (string)dr["YSDJH"];
if (dr["DJLX"] != null)
if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
result.DJLX = (int)dr["DJLX"];
if (dr["HBLX"] != null)
if (!System.DBNull.Equals(dr["HBLX"], System.DBNull.Value))
result.HBLX = (string)dr["HBLX"];
if (dr["YFJE"] != null)
if (!System.DBNull.Equals(dr["YFJE"], System.DBNull.Value))
result.YFJE = (double)dr["YFJE"];
if (dr["FKRQ"] != null)
if (!System.DBNull.Equals(dr["FKRQ"], System.DBNull.Value))
result.FKRQ = (DateTime)dr["FKRQ"];
if (dr["HXYE"] != null)
if (!System.DBNull.Equals(dr["HXYE"], System.DBNull.Value))
result.HXYE = (double)dr["HXYE"];
if (dr["ZDR"] != null)
if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
result.ZDR = (string)dr["ZDR"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
result.ZTBJ = (string)dr["ZTBJ"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
result.BZ = (string)dr["BZ"];
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_FKD(string FKDH)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_FKD對象
/// </summary>
public ArrayList FindCW_FKD()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_FKD";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_FKD obj = new CW_FKD();
if (dr["FKDH"] != null)
if (!System.DBNull.Equals(dr["FKDH"], System.DBNull.Value))
obj.FKDH = (string)dr["FKDH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["WLHBH"] != null)
if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
obj.WLHBH = (string)dr["WLHBH"];
if (dr["WLHLX"] != null)
if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
obj.WLHLX = (string)dr["WLHLX"];
if (dr["YSDJH"] != null)
if (!System.DBNull.Equals(dr["YSDJH"], System.DBNull.Value))
obj.YSDJH = (string)dr["YSDJH"];
if (dr["DJLX"] != null)
if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
obj.DJLX = (int)dr["DJLX"];
if (dr["HBLX"] != null)
if (!System.DBNull.Equals(dr["HBLX"], System.DBNull.Value))
obj.HBLX = (string)dr["HBLX"];
if (dr["YFJE"] != null)
if (!System.DBNull.Equals(dr["YFJE"], System.DBNull.Value))
obj.YFJE = (double)dr["YFJE"];
if (dr["FKRQ"] != null)
if (!System.DBNull.Equals(dr["FKRQ"], System.DBNull.Value))
obj.FKRQ = (DateTime)dr["FKRQ"];
if (dr["HXYE"] != null)
if (!System.DBNull.Equals(dr["HXYE"], System.DBNull.Value))
obj.HXYE = (double)dr["HXYE"];
if (dr["ZDR"] != null)
if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
obj.ZDR = (string)dr["ZDR"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
obj.ZTBJ = (string)dr["ZTBJ"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
obj.BZ = (string)dr["BZ"];
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_FKD()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -