?? cw_yfd.cs
字號:
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實現對 CW_YFD對象的管理
/// </summary>
public class CW_YFDMgr
{
/// <summary>
/// 添加新的CW_YFD對象
/// </summary>
/// <param name="theCW_YFD">要添加的CW_YFD對象</param>
public bool AddCW_YFD(SqlConnection cn,CW_YFD theCW_YFD)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "insert into CW_YFD (YFDH, JGDM, WLHLX, WLHBH, YSDJH, DJLX, HBLX, YFJE, SJYF, YFYE, FZR, ZDR, CJR, CJRQ, XGR, XGRQ, ZTBJ, QCBJ, BZ, GZBJ) values (@YFDH, @JGDM, @WLHLX, @WLHBH, @YSDJH, @DJLX, @HBLX, @YFJE, @SJYF, @YFYE, @FZR, @ZDR, @CJR, @CJRQ, @XGR, @XGRQ, @ZTBJ, @QCBJ, @BZ, @GZBJ)";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YFDH", theCW_YFD.YFDH);
cmd.Parameters.Add ("@JGDM", theCW_YFD.JGDM);
cmd.Parameters.Add ("@WLHLX", theCW_YFD.WLHLX);
cmd.Parameters.Add ("@WLHBH", theCW_YFD.WLHBH);
cmd.Parameters.Add ("@YSDJH", theCW_YFD.YSDJH);
cmd.Parameters.Add ("@DJLX", theCW_YFD.DJLX);
cmd.Parameters.Add ("@HBLX", theCW_YFD.HBLX);
cmd.Parameters.Add ("@YFJE", theCW_YFD.YFJE);
cmd.Parameters.Add ("@SJYF", theCW_YFD.SJYF);
cmd.Parameters.Add ("@YFYE", theCW_YFD.YFYE);
if(theCW_YFD.FZR==null)
cmd.Parameters.Add ("@FZR", DBNull.Value);
else
cmd.Parameters.Add ("@FZR", theCW_YFD.FZR);
cmd.Parameters.Add ("@ZDR", theCW_YFD.ZDR);
cmd.Parameters.Add ("@CJR", theCW_YFD.CJR);
cmd.Parameters.Add ("@CJRQ", theCW_YFD.CJRQ);
if(theCW_YFD.XGR==null)
cmd.Parameters.Add ("@XGR", DBNull.Value);
else
cmd.Parameters.Add ("@XGR", theCW_YFD.XGR);
cmd.Parameters.Add ("@XGRQ", theCW_YFD.XGRQ);
cmd.Parameters.Add ("@ZTBJ", theCW_YFD.ZTBJ);
cmd.Parameters.Add ("@QCBJ", theCW_YFD.QCBJ);
cmd.Parameters.Add ("@BZ", theCW_YFD.BZ);
cmd.Parameters.Add ("@GZBJ", theCW_YFD.GZBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_YFD(CW_YFD theCW_YFD)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_YFD對象
/// </summary>
/// <param name="theCW_YFD">要更新的CW_YFD對象</param>
public bool UpdateCW_YFD(SqlConnection cn,CW_YFD theCW_YFD)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "update CW_YFD set JGDM=@JGDM, WLHLX=@WLHLX, WLHBH=@WLHBH, YSDJH=@YSDJH, DJLX=@DJLX, HBLX=@HBLX, YFJE=@YFJE, SJYF=@SJYF, YFYE=@YFYE, FZR=@FZR, ZDR=@ZDR, CJR=@CJR, CJRQ=@CJRQ, XGR=@XGR, XGRQ=@XGRQ, ZTBJ=@ZTBJ, QCBJ=@QCBJ, BZ=@BZ, GZBJ=@GZBJ where YFDH=@YFDH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YFDH", theCW_YFD.YFDH);
cmd.Parameters.Add ("@JGDM", theCW_YFD.JGDM);
cmd.Parameters.Add ("@WLHLX", theCW_YFD.WLHLX);
cmd.Parameters.Add ("@WLHBH", theCW_YFD.WLHBH);
cmd.Parameters.Add ("@YSDJH", theCW_YFD.YSDJH);
cmd.Parameters.Add ("@DJLX", theCW_YFD.DJLX);
cmd.Parameters.Add ("@HBLX", theCW_YFD.HBLX);
cmd.Parameters.Add ("@YFJE", theCW_YFD.YFJE);
cmd.Parameters.Add ("@SJYF", theCW_YFD.SJYF);
cmd.Parameters.Add ("@YFYE", theCW_YFD.YFYE);
if(theCW_YFD.FZR==null)
cmd.Parameters.Add ("@FZR", DBNull.Value);
else
cmd.Parameters.Add ("@FZR", theCW_YFD.FZR);
cmd.Parameters.Add ("@ZDR", theCW_YFD.ZDR);
cmd.Parameters.Add ("@CJR", theCW_YFD.CJR);
cmd.Parameters.Add ("@CJRQ", theCW_YFD.CJRQ);
if(theCW_YFD.XGR==null)
cmd.Parameters.Add ("@XGR", DBNull.Value);
else
cmd.Parameters.Add ("@XGR", theCW_YFD.XGR);
cmd.Parameters.Add ("@XGRQ", theCW_YFD.XGRQ);
cmd.Parameters.Add ("@ZTBJ", theCW_YFD.ZTBJ);
cmd.Parameters.Add ("@QCBJ", theCW_YFD.QCBJ);
cmd.Parameters.Add ("@BZ", theCW_YFD.BZ);
cmd.Parameters.Add ("@GZBJ", theCW_YFD.GZBJ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_YFD(CW_YFD theCW_YFD)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_YFD對象
/// </summary>
/// <param name="YFDH">主鍵</param>
public bool DelCW_YFD(SqlConnection cn,string YFDH)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_YFD where YFDH=@YFDH";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add ("@YFDH", YFDH);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_YFD(string YFDH)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_YFD對象
/// </summary>
/// <param name="YFDH">主鍵</param>
public CW_YFD GetCW_YFD(string YFDH)
{
try
{
CW_YFD result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_YFD where YFDH=@YFDH";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@YFDH", YFDH);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_YFD();
if (dr["YFDH"] != null)
if (!System.DBNull.Equals(dr["YFDH"], System.DBNull.Value))
result.YFDH = (string)dr["YFDH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["WLHLX"] != null)
if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
result.WLHLX = (string)dr["WLHLX"];
if (dr["WLHBH"] != null)
if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
result.WLHBH = (string)dr["WLHBH"];
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["SJYF"] != null)
if (!System.DBNull.Equals(dr["SJYF"], System.DBNull.Value))
result.SJYF = (double)dr["SJYF"];
if (dr["YFYE"] != null)
if (!System.DBNull.Equals(dr["YFYE"], System.DBNull.Value))
result.YFYE = (double)dr["YFYE"];
if (dr["FZR"] != null)
if (!System.DBNull.Equals(dr["FZR"], System.DBNull.Value))
result.FZR = (string)dr["FZR"];
if (dr["ZDR"] != null)
if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
result.ZDR = (string)dr["ZDR"];
if (dr["CJR"] != null)
if (!System.DBNull.Equals(dr["CJR"], System.DBNull.Value))
result.CJR = (string)dr["CJR"];
if (dr["CJRQ"] != null)
if (!System.DBNull.Equals(dr["CJRQ"], System.DBNull.Value))
result.CJRQ = (DateTime)dr["CJRQ"];
if (dr["XGR"] != null)
if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
result.XGR = (string)dr["XGR"];
if (dr["XGRQ"] != null)
if (!System.DBNull.Equals(dr["XGRQ"], System.DBNull.Value))
result.XGRQ = (DateTime)dr["XGRQ"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
result.ZTBJ = (string)dr["ZTBJ"];
if (dr["QCBJ"] != null)
if (!System.DBNull.Equals(dr["QCBJ"], System.DBNull.Value))
result.QCBJ = (string)dr["QCBJ"];
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_YFD(string YFDH)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_YFD對象
/// </summary>
public ArrayList FindCW_YFD()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_YFD";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_YFD obj = new CW_YFD();
if (dr["YFDH"] != null)
if (!System.DBNull.Equals(dr["YFDH"], System.DBNull.Value))
obj.YFDH = (string)dr["YFDH"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["WLHLX"] != null)
if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
obj.WLHLX = (string)dr["WLHLX"];
if (dr["WLHBH"] != null)
if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
obj.WLHBH = (string)dr["WLHBH"];
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["SJYF"] != null)
if (!System.DBNull.Equals(dr["SJYF"], System.DBNull.Value))
obj.SJYF = (double)dr["SJYF"];
if (dr["YFYE"] != null)
if (!System.DBNull.Equals(dr["YFYE"], System.DBNull.Value))
obj.YFYE = (double)dr["YFYE"];
if (dr["FZR"] != null)
if (!System.DBNull.Equals(dr["FZR"], System.DBNull.Value))
obj.FZR = (string)dr["FZR"];
if (dr["ZDR"] != null)
if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
obj.ZDR = (string)dr["ZDR"];
if (dr["CJR"] != null)
if (!System.DBNull.Equals(dr["CJR"], System.DBNull.Value))
obj.CJR = (string)dr["CJR"];
if (dr["CJRQ"] != null)
if (!System.DBNull.Equals(dr["CJRQ"], System.DBNull.Value))
obj.CJRQ = (DateTime)dr["CJRQ"];
if (dr["XGR"] != null)
if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
obj.XGR = (string)dr["XGR"];
if (dr["XGRQ"] != null)
if (!System.DBNull.Equals(dr["XGRQ"], System.DBNull.Value))
obj.XGRQ = (DateTime)dr["XGRQ"];
if (dr["ZTBJ"] != null)
if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
obj.ZTBJ = (string)dr["ZTBJ"];
if (dr["QCBJ"] != null)
if (!System.DBNull.Equals(dr["QCBJ"], System.DBNull.Value))
obj.QCBJ = (string)dr["QCBJ"];
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_YFD()");
LogService.Write (e.Message);
return null;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -