?? cw_kmye.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 對象CW_KMYE的定義
/// 根據表 CW_KMYE
/// </summary>
public class CW_KMYE
{
/// <summary>
/// 對象CW_KMYE的構造函數
/// </summary>
public CW_KMYE()
{
m_KJND = "";
m_KJQJ = "";
m_JGDM = "";
m_KJKM = "";
m_QCYE = 0;
m_JFFSE = 0;
m_DFFSE = 0;
}
private string m_KJND;
private string m_KJQJ;
private string m_JGDM;
private string m_KJKM;
private decimal m_QCYE;
private decimal m_JFFSE;
private decimal m_DFFSE;
/// <summary>
/// 屬性 KJND
/// </summary>
public string KJND
{
get
{
return m_KJND;
}
set
{
m_KJND = value;
}
}
/// <summary>
/// 屬性 KJQJ
/// </summary>
public string KJQJ
{
get
{
return m_KJQJ;
}
set
{
m_KJQJ = value;
}
}
/// <summary>
/// 屬性 JGDM
/// </summary>
public string JGDM
{
get
{
return m_JGDM;
}
set
{
m_JGDM = value;
}
}
/// <summary>
/// 屬性 KJKM
/// </summary>
public string KJKM
{
get
{
return m_KJKM;
}
set
{
m_KJKM = value;
}
}
/// <summary>
/// 屬性 QCYE
/// </summary>
public decimal QCYE
{
get
{
return m_QCYE;
}
set
{
m_QCYE = value;
}
}
/// <summary>
/// 屬性 JFFSE
/// </summary>
public decimal JFFSE
{
get
{
return m_JFFSE;
}
set
{
m_JFFSE = value;
}
}
/// <summary>
/// 屬性 DFFSE
/// </summary>
public decimal DFFSE
{
get
{
return m_DFFSE;
}
set
{
m_DFFSE = value;
}
}
}
}
namespace Com.Ascs.Plp.CW
{
/// <summary>
/// 實現對 CW_KMYE對象的管理
/// </summary>
public class CW_KMYEMgr
{/// <summary>
/// 添加新的CW_KMYE對象
/// </summary>
/// <param name="theCW_KMYE">要添加的CW_KMYE對象</param>
public bool AddCW_KMYE(SqlCommand cmd ,CW_KMYE theCW_KMYE)
{
try
{
string sql;
sql = "insert into CW_KMYE (KJND, KJQJ, JGDM, KJKM, QCYE, JFFSE, DFFSE) values (@KJND, @KJQJ, @JGDM, @KJKM, @QCYE, @JFFSE, @DFFSE)";
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@KJND", theCW_KMYE.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_KMYE.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_KMYE.JGDM);
cmd.Parameters.Add ("@KJKM", theCW_KMYE.KJKM);
cmd.Parameters.Add ("@QCYE", theCW_KMYE.QCYE);
cmd.Parameters.Add ("@JFFSE", theCW_KMYE.JFFSE);
cmd.Parameters.Add ("@DFFSE", theCW_KMYE.DFFSE);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write ("AddCW_KMYE(CW_KMYE theCW_KMYE)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 更新CW_KMYE對象
/// </summary>
/// <param name="theCW_KMYE">要更新的CW_KMYE對象</param>
public bool UpdateCW_KMYE(SqlCommand cmd ,CW_KMYE theCW_KMYE)
{
try
{
string sql;
sql = "update CW_KMYE set QCYE=@QCYE, JFFSE=@JFFSE, DFFSE=@DFFSE where KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM and KJKM=@KJKM";
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@KJND", theCW_KMYE.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_KMYE.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_KMYE.JGDM);
cmd.Parameters.Add ("@KJKM", theCW_KMYE.KJKM);
cmd.Parameters.Add ("@QCYE", theCW_KMYE.QCYE);
cmd.Parameters.Add ("@JFFSE", theCW_KMYE.JFFSE);
cmd.Parameters.Add ("@DFFSE", theCW_KMYE.DFFSE);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_KMYE(CW_KMYE theCW_KMYE)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_KMYE對象
/// </summary>
/// <param name="KJND">主鍵</param>
/// <param name="KJQJ">主鍵</param>
/// <param name="JGDM">主鍵</param>
/// <param name="KJKM">主鍵</param>
public bool DelCW_KMYE(SqlCommand cmd,string KJND, string KJQJ, string JGDM, string KJKM)
{
try
{
// SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// cn.Open();
string sql;
sql = "delete from CW_KMYE where KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM and KJKM=@KJKM";
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.Parameters.Add ("@KJKM", KJKM);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_KMYE(string KJND, string KJQJ, string JGDM, string KJKM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_KMYE對象
/// </summary>
/// <param name="KJND">主鍵</param>
/// <param name="KJQJ">主鍵</param>
/// <param name="JGDM">主鍵</param>
/// <param name="KJKM">主鍵</param>
public CW_KMYE GetCW_KMYE(string KJND, string KJQJ, string JGDM, string KJKM)
{
try
{
CW_KMYE result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_KMYE where KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM and KJKM=@KJKM";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.Parameters.Add ("@KJKM", KJKM);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_KMYE();
if (dr["KJND"] != null)
if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
result.KJND = (string)dr["KJND"];
if (dr["KJQJ"] != null)
if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
result.KJQJ = (string)dr["KJQJ"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["KJKM"] != null)
if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
result.KJKM = (string)dr["KJKM"];
if (dr["QCYE"] != null)
if (!System.DBNull.Equals(dr["QCYE"], System.DBNull.Value))
result.QCYE = (decimal)dr["QCYE"];
if (dr["JFFSE"] != null)
if (!System.DBNull.Equals(dr["JFFSE"], System.DBNull.Value))
result.JFFSE = (decimal)dr["JFFSE"];
if (dr["DFFSE"] != null)
if (!System.DBNull.Equals(dr["DFFSE"], System.DBNull.Value))
result.DFFSE = (decimal)dr["DFFSE"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_KMYE(string KJND, string KJQJ, string JGDM, string KJKM)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_KMYE對象
/// </summary>
/// <param name="KJND">主鍵</param>
/// <param name="KJQJ">主鍵</param>
/// <param name="JGDM">主鍵</param>
/// <param name="KJKM">主鍵</param>
public CW_KMYE GetCW_KMYE(SqlCommand cmd, string KJND, string KJQJ, string JGDM, string KJKM)
{
try
{
CW_KMYE result = null;
string sql;
sql = "select * from CW_KMYE where KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM and KJKM=@KJKM";
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.Parameters.Add ("@KJKM", KJKM);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_KMYE();
if (dr["KJND"] != null)
if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
result.KJND = (string)dr["KJND"];
if (dr["KJQJ"] != null)
if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
result.KJQJ = (string)dr["KJQJ"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["KJKM"] != null)
if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
result.KJKM = (string)dr["KJKM"];
if (dr["QCYE"] != null)
if (!System.DBNull.Equals(dr["QCYE"], System.DBNull.Value))
result.QCYE = (decimal)dr["QCYE"];
if (dr["JFFSE"] != null)
if (!System.DBNull.Equals(dr["JFFSE"], System.DBNull.Value))
result.JFFSE = (decimal)dr["JFFSE"];
if (dr["DFFSE"] != null)
if (!System.DBNull.Equals(dr["DFFSE"], System.DBNull.Value))
result.DFFSE = (decimal)dr["DFFSE"];
}
dr.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_KMYE(SqlCommand cmd, string KJND, string KJQJ, string JGDM, string KJKM)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_KMYE對象
/// </summary>
public ArrayList FindCW_KMYE()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_KMYE";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_KMYE obj = new CW_KMYE();
if (dr["KJND"] != null)
if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
obj.KJND = (string)dr["KJND"];
if (dr["KJQJ"] != null)
if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
obj.KJQJ = (string)dr["KJQJ"];
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
obj.JGDM = (string)dr["JGDM"];
if (dr["KJKM"] != null)
if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
obj.KJKM = (string)dr["KJKM"];
if (dr["QCYE"] != null)
if (!System.DBNull.Equals(dr["QCYE"], System.DBNull.Value))
obj.QCYE = (decimal)dr["QCYE"];
if (dr["JFFSE"] != null)
if (!System.DBNull.Equals(dr["JFFSE"], System.DBNull.Value))
obj.JFFSE = (decimal)dr["JFFSE"];
if (dr["DFFSE"] != null)
if (!System.DBNull.Equals(dr["DFFSE"], System.DBNull.Value))
obj.DFFSE = (decimal)dr["DFFSE"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_KMYE()");
LogService.Write (e.Message);
return null;
}
}
public DataTable CreateDataTableFromSql(string strSql)
{
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
SqlDataAdapter SqlAD;
DataTable dt = new DataTable();
try
{
SqlAD = new SqlDataAdapter(strSql,cn);
SqlAD.Fill(dt);
}
catch(SqlException e)
{
string str_Err = e.Message.ToString();
}
return dt;
}
public void FillKJKM(string JGDM,string KJND,string QYKJQJ)
{
string sql=string.Format("exec FillKJKM '{0}','{1}','{2}'",KJND,QYKJQJ,JGDM);
DataTable dt=this.CreateDataTableFromSql(sql);
}
public bool HandleKMYE (SqlCommand cmd, CW_KMYE theCW_KMYE)
{
try
{
string sql="exec HandleKMYE @KJND,@KJQJ,@JGDM,@KJKM,@QCYE,@JFFSE,@DFFSE";
cmd.CommandText=sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@KJND", theCW_KMYE.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_KMYE.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_KMYE.JGDM);
cmd.Parameters.Add ("@KJKM", theCW_KMYE.KJKM);
cmd.Parameters.Add ("@QCYE", theCW_KMYE.QCYE);
cmd.Parameters.Add ("@JFFSE", theCW_KMYE.JFFSE);
cmd.Parameters.Add ("@DFFSE", theCW_KMYE.DFFSE);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write (" HandleKMYE (SqlCommand cmd, CW_KMYE theCW_KMYE)");
LogService.Write (e.Message);
return false;
}
}
public bool DelKMYEHZ(SqlCommand cmd, CW_KMYE theCW_KMYE)
{
try
{
cmd.CommandText="DelKMYE";
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@KJND", theCW_KMYE.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_KMYE.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_KMYE.JGDM);
cmd.Parameters.Add ("@KJKM", theCW_KMYE.KJKM);
cmd.Parameters.Add ("@QCYE", theCW_KMYE.QCYE);
cmd.Parameters.Add ("@KJKM2", theCW_KMYE.KJKM);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write (" DelKMYE (SqlCommand cmd, CW_KMYE theCW_KMYE)");
LogService.Write (e.Message);
return false;
}
}
public string[] SSPH(string KJND,string KJQJBH,string JGDM)
{
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
string[] sReturns=new String[4];
decimal JFQCYE=2.55m;
decimal DFQCYE=2.55m;
string sReturn=string.Empty;
cn.Open();
try
{
SqlCommand cmd=new SqlCommand("SSPH",cn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@KJND",KJND);
cmd.Parameters.Add("@KJQJBH",KJQJBH);
cmd.Parameters.Add("@JGDM",JGDM);
cmd.Parameters.Add("@JFQCYE",JFQCYE);
cmd.Parameters.Add("@DFQCYE",DFQCYE);
cmd.Parameters.Add("@sReturn",sReturn);
cmd.Parameters["@JFQCYE"].Direction=ParameterDirection.InputOutput;
cmd.Parameters["@DFQCYE"].Direction=ParameterDirection.InputOutput;
cmd.Parameters["@sReturn"].Direction=ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
JFQCYE=Convert.ToDecimal(cmd.Parameters["@JFQCYE"].Value);
DFQCYE=Convert.ToDecimal(cmd.Parameters["@DFQCYE"].Value);
sReturn=cmd.Parameters["@sReturn"].Value.ToString();
cn.Close();
sReturns[0]=JFQCYE.ToString();
sReturns[1]=DFQCYE.ToString();
sReturns[2]=sReturn;
decimal ce=JFQCYE-DFQCYE;
sReturns[3]=ce.ToString();
}
catch
{}
return sReturns;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -