?? cw_pz.cs
字號:
/// <param name="KJQJBH"></param>
/// <returns></returns>
public string Create_PZBH(System.Data.SqlClient.SqlCommand cmd,string JGDM,string KJND,string KJQJBH)
{
string sql= "select PZBH from CW_PZ where JGDM=@JGDM and KJND=@KJND and KJQJ=@KJQJ order by PZBH DESC ";
cmd.Parameters.Clear();
cmd.Parameters.Add("@JGDM",JGDM);
cmd.Parameters.Add("@KJND",KJND);
cmd.Parameters.Add("@KJQJ",KJQJBH);
cmd.CommandText=sql;
System.Data.SqlClient.SqlDataReader dr=cmd.ExecuteReader();
string PZBH=string.Empty;
while (dr.Read())
{
PZBH=dr["PZBH"].ToString();
int nBH=Convert.ToInt32(PZBH) +1;
PZBH=nBH.ToString();
PZBH=PZBH.PadLeft(4,'0');
dr.Close();
return PZBH;
}
dr.Close();
PZBH="0001";
return PZBH;
}
/// 更新CW_PZ對象
/// </summary>
/// <param name="theCW_PZ">要更新的CW_PZ對象</param>
public bool UpdateCW_PZ(SqlCommand cmd,CW_PZ theCW_PZ)
{
try
{
string sql;
sql = "update CW_PZ set PZLX=@PZLX, FDS=@FDS, YSPJLX=@YSPJLX, YSPJBH=@YSPJBH, ZDR=@ZDR, ZDRQ=@ZDRQ, SHR=@SHR, SHRQ=@SHRQ, CNR=@CNR, CNRQ=@CNRQ, GZR=@GZR, GZRQ=@GZRQ, GZBJ=@GZBJ, KGLBJ=@KGLBJ, DCBJ=@DCBJ, DCBH=@DCBH, BZ=@BZ where PZBH=@PZBH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
cmd.CommandText=sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@PZBH", theCW_PZ.PZBH);
cmd.Parameters.Add ("@KJND", theCW_PZ.KJND);
cmd.Parameters.Add ("@KJQJ", theCW_PZ.KJQJ);
cmd.Parameters.Add ("@JGDM", theCW_PZ.JGDM);
cmd.Parameters.Add ("@PZLX", theCW_PZ.PZLX);
cmd.Parameters.Add ("@FDS", theCW_PZ.FDS);
cmd.Parameters.Add ("@YSPJLX", theCW_PZ.YSPJLX);
cmd.Parameters.Add ("@YSPJBH", theCW_PZ.YSPJBH);
cmd.Parameters.Add ("@ZDR", theCW_PZ.ZDR);
cmd.Parameters.Add ("@ZDRQ", theCW_PZ.ZDRQ);
cmd.Parameters.Add ("@SHR", theCW_PZ.SHR);
if(theCW_PZ.SHRQ==Convert.ToDateTime("1900-01-01"))
{
cmd.Parameters.Add ("@SHRQ",SqlDbType.DateTime);
cmd.Parameters["@SHRQ"].Value=DBNull.Value;
}
else
{
cmd.Parameters.Add ("@SHRQ", theCW_PZ.SHRQ);
}
if(theCW_PZ.GZRQ==Convert.ToDateTime("1900-01-01"))
{
cmd.Parameters.Add ("@GZRQ",SqlDbType.DateTime);
cmd.Parameters["@GZRQ"].Value=DBNull.Value;
}
else
{
cmd.Parameters.Add ("@GZRQ", theCW_PZ.GZRQ);
}
if(theCW_PZ.CNRQ==Convert.ToDateTime("1900-01-01"))
{
cmd.Parameters.Add ("@CNRQ",SqlDbType.DateTime);
cmd.Parameters["@CNRQ"].Value=DBNull.Value;
}
else
{
cmd.Parameters.Add ("@CNRQ", theCW_PZ.CNRQ);
}
cmd.Parameters.Add ("@CNR", theCW_PZ.CNR);
cmd.Parameters.Add ("@GZR", theCW_PZ.GZR);
cmd.Parameters.Add ("@GZBJ", theCW_PZ.GZBJ);
cmd.Parameters.Add ("@KGLBJ", theCW_PZ.KGLBJ);
cmd.Parameters.Add ("@DCBJ", theCW_PZ.DCBJ);
cmd.Parameters.Add ("@DCBH", theCW_PZ.DCBH);
cmd.Parameters.Add ("@BZ", theCW_PZ.BZ);
cmd.ExecuteNonQuery();
// cn.Close();
return true;
}
catch(Exception e)
{
LogService.Write ("UpdateCW_PZ(CW_PZ theCW_PZ)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 刪除CW_PZ對象
/// </summary>
/// <param name="PZBH">主鍵</param>
/// <param name="KJND">主鍵</param>
/// <param name="KJQJ">主鍵</param>
/// <param name="JGDM">主鍵</param>
public bool DelCW_PZ(SqlCommand cmd,string PZBH, string KJND, string KJQJ,string JGDM)
{
try
{
string sql;
sql = "delete from CW_PZ where PZBH=@PZBH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
cmd.CommandText =sql;
cmd.Parameters.Clear();
cmd.Parameters.Add ("@PZBH", PZBH);
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
LogService.Write ("DelCW_PZ(string PZBH, string KJND, string KJQJ, string JGDM)");
LogService.Write (e.Message);
return false;
}
}
/// <summary>
/// 根據主鍵標識獲得CW_PZ對象
/// </summary>
/// <param name="PZBH">主鍵</param>
/// <param name="KJND">主鍵</param>
/// <param name="KJQJ">主鍵</param>
/// <param name="JGDM">主鍵</param>
public CW_PZ GetCW_PZ(string PZBH, string KJND, string KJQJ, string JGDM)
{
try
{
CW_PZ result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_PZ where PZBH=@PZBH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@PZBH", PZBH);
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CW_PZ();
if (dr["PZBH"] != null)
if (!System.DBNull.Equals(dr["PZBH"], System.DBNull.Value))
result.PZBH = (string)dr["PZBH"];
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["PZLX"] != null)
if (!System.DBNull.Equals(dr["PZLX"], System.DBNull.Value))
result.PZLX = (string)dr["PZLX"];
if (dr["FDS"] != null)
if (!System.DBNull.Equals(dr["FDS"], System.DBNull.Value))
result.FDS = (int)dr["FDS"];
if (dr["YSPJLX"] != null)
if (!System.DBNull.Equals(dr["YSPJLX"], System.DBNull.Value))
result.YSPJLX = (int)dr["YSPJLX"];
if (dr["YSPJBH"] != null)
if (!System.DBNull.Equals(dr["YSPJBH"], System.DBNull.Value))
result.YSPJBH = (string)dr["YSPJBH"];
if (dr["ZDR"] != null)
if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
result.ZDR = (string)dr["ZDR"];
if (dr["ZDRQ"] != null)
if (!System.DBNull.Equals(dr["ZDRQ"], System.DBNull.Value))
result.ZDRQ = (DateTime)dr["ZDRQ"];
if (dr["SHR"] != null)
if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
result.SHR = (string)dr["SHR"];
if (dr["SHRQ"] != null)
if (!System.DBNull.Equals(dr["SHRQ"], System.DBNull.Value))
result.SHRQ = (DateTime)dr["SHRQ"];
if (dr["CNR"] != null)
if (!System.DBNull.Equals(dr["CNR"], System.DBNull.Value))
result.CNR = (string)dr["CNR"];
if (dr["CNRQ"] != null)
if (!System.DBNull.Equals(dr["CNRQ"], System.DBNull.Value))
result.CNRQ = (DateTime)dr["CNRQ"];
if (dr["GZR"] != null)
if (!System.DBNull.Equals(dr["GZR"], System.DBNull.Value))
result.GZR = (string)dr["GZR"];
if (dr["GZRQ"] != null)
if (!System.DBNull.Equals(dr["GZRQ"], System.DBNull.Value))
result.GZRQ = (DateTime)dr["GZRQ"];
if (dr["GZBJ"] != null)
if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
result.GZBJ = (string)dr["GZBJ"];
if (dr["KGLBJ"] != null)
if (!System.DBNull.Equals(dr["KGLBJ"], System.DBNull.Value))
result.KGLBJ = (string)dr["KGLBJ"];
if (dr["DCBJ"] != null)
if (!System.DBNull.Equals(dr["DCBJ"], System.DBNull.Value))
result.DCBJ = (string)dr["DCBJ"];
if (dr["DCBH"] != null)
if (!System.DBNull.Equals(dr["DCBH"], System.DBNull.Value))
result.DCBH = (string)dr["DCBH"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
result.BZ = (string)dr["BZ"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetCW_PZ(string PZBH, string KJND, string KJQJ, string JGDM)");
LogService.Write (e.Message);
return null;
}
}
/// <summary>
/// 查找CW_PZ對象
/// </summary>
public ArrayList FindCW_PZ()
{
try
{
ArrayList result = new ArrayList();
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
string sql;
sql = "select * from CW_PZ";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CW_PZ obj = new CW_PZ();
if (dr["PZBH"] != null)
if (!System.DBNull.Equals(dr["PZBH"], System.DBNull.Value))
obj.PZBH = (string)dr["PZBH"];
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["PZLX"] != null)
if (!System.DBNull.Equals(dr["PZLX"], System.DBNull.Value))
obj.PZLX = (string)dr["PZLX"];
if (dr["FDS"] != null)
if (!System.DBNull.Equals(dr["FDS"], System.DBNull.Value))
obj.FDS = (int)dr["FDS"];
if (dr["YSPJLX"] != null)
if (!System.DBNull.Equals(dr["YSPJLX"], System.DBNull.Value))
obj.YSPJLX = (int)dr["YSPJLX"];
if (dr["YSPJBH"] != null)
if (!System.DBNull.Equals(dr["YSPJBH"], System.DBNull.Value))
obj.YSPJBH = (string)dr["YSPJBH"];
if (dr["ZDR"] != null)
if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
obj.ZDR = (string)dr["ZDR"];
if (dr["ZDRQ"] != null)
if (!System.DBNull.Equals(dr["ZDRQ"], System.DBNull.Value))
obj.ZDRQ = (DateTime)dr["ZDRQ"];
if (dr["SHR"] != null)
if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
obj.SHR = (string)dr["SHR"];
if (dr["SHRQ"] != null)
if (!System.DBNull.Equals(dr["SHRQ"], System.DBNull.Value))
obj.SHRQ = (DateTime)dr["SHRQ"];
if (dr["CNR"] != null)
if (!System.DBNull.Equals(dr["CNR"], System.DBNull.Value))
obj.CNR = (string)dr["CNR"];
if (dr["CNRQ"] != null)
if (!System.DBNull.Equals(dr["CNRQ"], System.DBNull.Value))
obj.CNRQ = (DateTime)dr["CNRQ"];
if (dr["GZR"] != null)
if (!System.DBNull.Equals(dr["GZR"], System.DBNull.Value))
obj.GZR = (string)dr["GZR"];
if (dr["GZRQ"] != null)
if (!System.DBNull.Equals(dr["GZRQ"], System.DBNull.Value))
obj.GZRQ = (DateTime)dr["GZRQ"];
if (dr["GZBJ"] != null)
if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
obj.GZBJ = (string)dr["GZBJ"];
if (dr["KGLBJ"] != null)
if (!System.DBNull.Equals(dr["KGLBJ"], System.DBNull.Value))
obj.KGLBJ = (string)dr["KGLBJ"];
if (dr["DCBJ"] != null)
if (!System.DBNull.Equals(dr["DCBJ"], System.DBNull.Value))
obj.DCBJ = (string)dr["DCBJ"];
if (dr["DCBH"] != null)
if (!System.DBNull.Equals(dr["DCBH"], System.DBNull.Value))
obj.DCBH = (string)dr["DCBH"];
if (dr["BZ"] != null)
if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
obj.BZ = (string)dr["BZ"];
result.Add(obj);
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("FindCW_PZ()");
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 string[] PZJDPH(string KJND,string KJQJ,string JGDM,string PZBH)
{
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
string sReturn=string.Empty;
decimal CE=0.01m;
decimal JFJE=-100000000000.01m;
decimal DFJE=-100000000000.01m;
string[] sReturns=new string[4];
cn.Open();
try
{
SqlCommand cmd=new SqlCommand("PZJDPH",cn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add ("@PZBH", PZBH);
cmd.Parameters.Add ("@KJND", KJND);
cmd.Parameters.Add ("@KJQJ", KJQJ);
cmd.Parameters.Add ("@JGDM", JGDM);
cmd.Parameters.Add("@CE",CE);
cmd.Parameters.Add("@JFJE",JFJE);
cmd.Parameters.Add("@DFJE",DFJE);
cmd.Parameters.Add("@sReturn",sReturn);
cmd.Parameters["@CE"].Direction=ParameterDirection.InputOutput;
cmd.Parameters["@JFJE"].Direction=ParameterDirection.InputOutput;
cmd.Parameters["@DFJE"].Direction=ParameterDirection.InputOutput;
cmd.Parameters["@sReturn"].Direction=ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
CE=Convert.ToDecimal(cmd.Parameters["@CE"].Value);
if(cmd.Parameters["@JFJE"].Value!=DBNull.Value)
{
JFJE=Convert.ToDecimal(cmd.Parameters["@JFJE"].Value);
if(JFJE!=-100000000000.01m)
{
sReturns[2]=JFJE.ToString();
}
else
{
sReturns[2]="NULL";
}
}
else
{
sReturns[2]="NULL";
}
if(cmd.Parameters["@DFJE"].Value!=DBNull.Value)
{
DFJE=Convert.ToDecimal(cmd.Parameters["@DFJE"].Value);
if(DFJE!=-100000000000.01m)
{
sReturns[3]=DFJE.ToString();
}
else
{
sReturns[3]="NULL";
}
}
else
{
sReturns[3]="NULL";
}
sReturn=cmd.Parameters["@sReturn"].Value.ToString();
cn.Close();
sReturns[0]=sReturn;
sReturns[1]=CE.ToString();
}
catch(Exception e)
{
string str=e.Message;
sReturns[0]="NULL";
sReturns[1]="NULL";
sReturns[2]="NULL";
sReturns[3]="NULL";
}
if(sReturns[0]!="NULL")
{
switch(sReturns[0])
{
case "0":
sReturns[1]="該憑證還未填寫細目，請?zhí)顚懺搼{證細目。";
break;
case "1":
sReturns[1]="該憑證還未填寫借方金額，請?zhí)顚懺搼{證借方金額。";
break;
case "2":
sReturns[1]="該憑證還未填寫貸方金額，請?zhí)顚懺搼{證貸方金額。";
break;
case "3":
sReturns[1]="該憑證借方貸方金額不平衡，借方金額比貸方金額多"+sReturns[1]+"元。";
break;
case "4":
sReturns[1]="該憑證借方貸方金額平衡。";
break;
case "5":
sReturns[1]="該憑證借方貸方金額不平衡，借方金額比貸方金額少"+sReturns[1]+"元。";
break;
}
}
return sReturns;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -