/// <summary>
/// 添加TC_Equ对象(即:一条记录)
/// </summary>
public object AddWithReturn(TC_Equ tC_Equ)
{
string sql = "INSERT INTO TC_Equ (TCE_Code,TCE_ECode,TCE_Spec,TCE_Date,TCE_Checker,TCE_CheckDate,TCE_Operator,TCE_OpDate,TCE_Company,TCE_Dept,TCE_Description,TCE_Remark,TCE_UDef1,TCE_UDef2,TCE_UDef3,TCE_UDef4,TCE_UDef5,TCE_UDef6,TCE_TCode,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@TCE_Code,@TCE_ECode,@TCE_Spec,@TCE_Date,@TCE_Checker,@TCE_CheckDate,@TCE_Operator,@TCE_OpDate,@TCE_Company,@TCE_Dept,@TCE_Description,@TCE_Remark,@TCE_UDef1,@TCE_UDef2,@TCE_UDef3,@TCE_UDef4,@TCE_UDef5,@TCE_UDef6,@TCE_TCode,@Stat,@CreateDate,@UpdateDate,@DeleteDate);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(tC_Equ.TCE_Code))
{
idb.AddParameter("@TCE_Code", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Code", tC_Equ.TCE_Code);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_ECode))
{
idb.AddParameter("@TCE_ECode", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_ECode", tC_Equ.TCE_ECode);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Spec))
{
idb.AddParameter("@TCE_Spec", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Spec", tC_Equ.TCE_Spec);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Date))
{
idb.AddParameter("@TCE_Date", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Date", tC_Equ.TCE_Date);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Checker))
{
idb.AddParameter("@TCE_Checker", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Checker", tC_Equ.TCE_Checker);
}
if (tC_Equ.TCE_CheckDate == DateTime.MinValue)
{
idb.AddParameter("@TCE_CheckDate", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_CheckDate", tC_Equ.TCE_CheckDate);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Operator))
{
idb.AddParameter("@TCE_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Operator", tC_Equ.TCE_Operator);
}
if (tC_Equ.TCE_OpDate == DateTime.MinValue)
{
idb.AddParameter("@TCE_OpDate", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_OpDate", tC_Equ.TCE_OpDate);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Company))
{
idb.AddParameter("@TCE_Company", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Company", tC_Equ.TCE_Company);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Dept))
{
idb.AddParameter("@TCE_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Dept", tC_Equ.TCE_Dept);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Description))
{
idb.AddParameter("@TCE_Description", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Description", tC_Equ.TCE_Description);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_Remark))
{
idb.AddParameter("@TCE_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Remark", tC_Equ.TCE_Remark);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef1))
{
idb.AddParameter("@TCE_UDef1", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef1", tC_Equ.TCE_UDef1);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef2))
{
idb.AddParameter("@TCE_UDef2", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef2", tC_Equ.TCE_UDef2);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef3))
{
idb.AddParameter("@TCE_UDef3", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef3", tC_Equ.TCE_UDef3);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef4))
{
idb.AddParameter("@TCE_UDef4", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef4", tC_Equ.TCE_UDef4);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef5))
{
idb.AddParameter("@TCE_UDef5", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef5", tC_Equ.TCE_UDef5);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef6))
{
idb.AddParameter("@TCE_UDef6", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef6", tC_Equ.TCE_UDef6);
}
if (string.IsNullOrEmpty(tC_Equ.TCE_TCode))
{
idb.AddParameter("@TCE_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_TCode", tC_Equ.TCE_TCode);
}
if (tC_Equ.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", tC_Equ.Stat);
}
if (tC_Equ.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", tC_Equ.CreateDate);
}
if (tC_Equ.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", tC_Equ.UpdateDate);
}
if (tC_Equ.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", tC_Equ.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加食堂物资记录 CanteenItem_Record对象(即:一条记录)
/// </summary>
public int Add(CanteenItem_Record canteenItem_Record)
{
string sql = "INSERT INTO CanteenItem_Record (CIR_Code,CIR_Name,CIR_Model,CIR_CanteenItemCode,CIR_Date,CIR_Money,CIR_Remark,CIR_Company,CIR_Dept,CIR_Num,CIR_Price,CIR_Unit,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@CIR_Code,@CIR_Name,@CIR_Model,@CIR_CanteenItemCode,@CIR_Date,@CIR_Money,@CIR_Remark,@CIR_Company,@CIR_Dept,@CIR_Num,@CIR_Price,@CIR_Unit,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Code))
{
idb.AddParameter("@CIR_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Code", canteenItem_Record.CIR_Code);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Name))
{
idb.AddParameter("@CIR_Name", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Name", canteenItem_Record.CIR_Name);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Model))
{
idb.AddParameter("@CIR_Model", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Model", canteenItem_Record.CIR_Model);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_CanteenItemCode))
{
idb.AddParameter("@CIR_CanteenItemCode", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_CanteenItemCode", canteenItem_Record.CIR_CanteenItemCode);
}
if (canteenItem_Record.CIR_Date == DateTime.MinValue)
{
idb.AddParameter("@CIR_Date", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Date", canteenItem_Record.CIR_Date);
}
if (canteenItem_Record.CIR_Money == 0)
{
idb.AddParameter("@CIR_Money", 0);
}
else
{
idb.AddParameter("@CIR_Money", canteenItem_Record.CIR_Money);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Remark))
{
idb.AddParameter("@CIR_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Remark", canteenItem_Record.CIR_Remark);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Company))
{
idb.AddParameter("@CIR_Company", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Company", canteenItem_Record.CIR_Company);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Dept))
{
idb.AddParameter("@CIR_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Dept", canteenItem_Record.CIR_Dept);
}
if (canteenItem_Record.CIR_Num == 0)
{
idb.AddParameter("@CIR_Num", 0);
}
else
{
idb.AddParameter("@CIR_Num", canteenItem_Record.CIR_Num);
}
if (canteenItem_Record.CIR_Price == 0)
{
idb.AddParameter("@CIR_Price", 0);
}
else
{
idb.AddParameter("@CIR_Price", canteenItem_Record.CIR_Price);
}
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Unit))
{
idb.AddParameter("@CIR_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Unit", canteenItem_Record.CIR_Unit);
}
if (canteenItem_Record.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", canteenItem_Record.Stat);
}
if (canteenItem_Record.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", canteenItem_Record.CreateDate);
}
if (canteenItem_Record.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", canteenItem_Record.UpdateDate);
}
if (canteenItem_Record.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", canteenItem_Record.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加物料盘存表 WH_CheckList对象(即:一条记录)
/// </summary>
public object AddWithReturn(WH_CheckList wH_CheckList)
{
string sql = "INSERT INTO WH_CheckList (CL_MCode,CL_MName,CL_MSpec,CL_Month,CL_Last,CL_In,CL_Out,CL_Current,CL_CIn,CL_Mid,CL_LOut,CL_Date,CL_Stuff1,CL_Stuff2,CL_Bak,Creator,CreateTime,VerifyStuff,VerifyDate,VerifyStep,VerifyStat,Stat) VALUES (@CL_MCode,@CL_MName,@CL_MSpec,@CL_Month,@CL_Last,@CL_In,@CL_Out,@CL_Current,@CL_CIn,@CL_Mid,@CL_LOut,@CL_Date,@CL_Stuff1,@CL_Stuff2,@CL_Bak,@Creator,@CreateTime,@VerifyStuff,@VerifyDate,@VerifyStep,@VerifyStat,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(wH_CheckList.CL_MCode))
{
idb.AddParameter("@CL_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@CL_MCode", wH_CheckList.CL_MCode);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_MName))
{
idb.AddParameter("@CL_MName", DBNull.Value);
}
else
{
idb.AddParameter("@CL_MName", wH_CheckList.CL_MName);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_MSpec))
{
idb.AddParameter("@CL_MSpec", DBNull.Value);
}
else
{
idb.AddParameter("@CL_MSpec", wH_CheckList.CL_MSpec);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Month))
{
idb.AddParameter("@CL_Month", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Month", wH_CheckList.CL_Month);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Last))
{
idb.AddParameter("@CL_Last", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Last", wH_CheckList.CL_Last);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_In))
{
idb.AddParameter("@CL_In", DBNull.Value);
}
else
{
idb.AddParameter("@CL_In", wH_CheckList.CL_In);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Out))
{
idb.AddParameter("@CL_Out", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Out", wH_CheckList.CL_Out);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Current))
{
idb.AddParameter("@CL_Current", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Current", wH_CheckList.CL_Current);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_CIn))
{
idb.AddParameter("@CL_CIn", DBNull.Value);
}
else
{
idb.AddParameter("@CL_CIn", wH_CheckList.CL_CIn);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Mid))
{
idb.AddParameter("@CL_Mid", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Mid", wH_CheckList.CL_Mid);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_LOut))
{
idb.AddParameter("@CL_LOut", DBNull.Value);
}
else
{
idb.AddParameter("@CL_LOut", wH_CheckList.CL_LOut);
}
if (wH_CheckList.CL_Date == DateTime.MinValue)
{
idb.AddParameter("@CL_Date", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Date", wH_CheckList.CL_Date);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Stuff1))
{
idb.AddParameter("@CL_Stuff1", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Stuff1", wH_CheckList.CL_Stuff1);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Stuff2))
{
idb.AddParameter("@CL_Stuff2", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Stuff2", wH_CheckList.CL_Stuff2);
}
if (string.IsNullOrEmpty(wH_CheckList.CL_Bak))
{
idb.AddParameter("@CL_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Bak", wH_CheckList.CL_Bak);
}
if (string.IsNullOrEmpty(wH_CheckList.Creator))
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", wH_CheckList.Creator);
}
if (wH_CheckList.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", wH_CheckList.CreateTime);
}
if (string.IsNullOrEmpty(wH_CheckList.VerifyStuff))
{
idb.AddParameter("@VerifyStuff", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStuff", wH_CheckList.VerifyStuff);
}
if (wH_CheckList.VerifyDate == DateTime.MinValue)
{
idb.AddParameter("@VerifyDate", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyDate", wH_CheckList.VerifyDate);
}
if (string.IsNullOrEmpty(wH_CheckList.VerifyStep))
{
idb.AddParameter("@VerifyStep", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStep", wH_CheckList.VerifyStep);
}
if (string.IsNullOrEmpty(wH_CheckList.VerifyStat))
{
idb.AddParameter("@VerifyStat", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStat", wH_CheckList.VerifyStat);
}
if (wH_CheckList.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_CheckList.Stat);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加TC_RTemplate对象(即:一条记录)
/// </summary>
public int Add(TC_RTemplate tC_RTemplate)
{
string sql = "INSERT INTO TC_RTemplate (TCRT_Code,TCRT_Name,TCRT_Type,TCRT_Stat,TCRT_iType,TCRT_Operator,TCRT_OpDate,TCRT_Remark,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@TCRT_Code,@TCRT_Name,@TCRT_Type,@TCRT_Stat,@TCRT_iType,@TCRT_Operator,@TCRT_OpDate,@TCRT_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Code))
{
idb.AddParameter("@TCRT_Code", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Code", tC_RTemplate.TCRT_Code);
}
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Name))
{
idb.AddParameter("@TCRT_Name", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Name", tC_RTemplate.TCRT_Name);
}
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Type))
{
idb.AddParameter("@TCRT_Type", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Type", tC_RTemplate.TCRT_Type);
}
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Stat))
{
idb.AddParameter("@TCRT_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Stat", tC_RTemplate.TCRT_Stat);
}
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_iType))
{
idb.AddParameter("@TCRT_iType", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_iType", tC_RTemplate.TCRT_iType);
}
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Operator))
{
idb.AddParameter("@TCRT_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Operator", tC_RTemplate.TCRT_Operator);
}
if (tC_RTemplate.TCRT_OpDate == DateTime.MinValue)
{
idb.AddParameter("@TCRT_OpDate", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_OpDate", tC_RTemplate.TCRT_OpDate);
}
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Remark))
{
idb.AddParameter("@TCRT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Remark", tC_RTemplate.TCRT_Remark);
}
if (tC_RTemplate.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", tC_RTemplate.Stat);
}
if (tC_RTemplate.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", tC_RTemplate.CreateDate);
}
if (tC_RTemplate.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", tC_RTemplate.UpdateDate);
}
if (tC_RTemplate.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", tC_RTemplate.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加应付单 WH_Payable对象(即:一条记录)
/// </summary>
public int Add(WH_Payable wH_Payable)
{
string sql = "INSERT INTO WH_Payable (WHP_Code,WHP_SCode,WHP_SName,WHP_Period,WHP_LSum,WHP_CSum,WHP_CLeft,WHP_IsDone,Stat,WHP_IsDate,CreateDate,UpdateDate,DeleteDate,WHP_UCompany,WHP_UCompanyCode,WHP_broom) VALUES (@WHP_Code,@WHP_SCode,@WHP_SName,@WHP_Period,@WHP_LSum,@WHP_CSum,@WHP_CLeft,@WHP_IsDone,@Stat,@WHP_IsDate,@CreateDate,@UpdateDate,@DeleteDate,@WHP_UCompany,@WHP_UCompanyCode,@WHP_broom)";
if (string.IsNullOrEmpty(wH_Payable.WHP_Code))
{
idb.AddParameter("@WHP_Code", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_Code", wH_Payable.WHP_Code);
}
if (string.IsNullOrEmpty(wH_Payable.WHP_SCode))
{
idb.AddParameter("@WHP_SCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_SCode", wH_Payable.WHP_SCode);
}
if (string.IsNullOrEmpty(wH_Payable.WHP_SName))
{
idb.AddParameter("@WHP_SName", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_SName", wH_Payable.WHP_SName);
}
if (string.IsNullOrEmpty(wH_Payable.WHP_Period))
{
idb.AddParameter("@WHP_Period", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_Period", wH_Payable.WHP_Period);
}
if (wH_Payable.WHP_LSum == 0)
{
idb.AddParameter("@WHP_LSum", 0);
}
else
{
idb.AddParameter("@WHP_LSum", wH_Payable.WHP_LSum);
}
if (wH_Payable.WHP_CSum == 0)
{
idb.AddParameter("@WHP_CSum", 0);
}
else
{
idb.AddParameter("@WHP_CSum", wH_Payable.WHP_CSum);
}
if (wH_Payable.WHP_CLeft == 0)
{
idb.AddParameter("@WHP_CLeft", 0);
}
else
{
idb.AddParameter("@WHP_CLeft", wH_Payable.WHP_CLeft);
}
if (wH_Payable.WHP_IsDone == 0)
{
idb.AddParameter("@WHP_IsDone", 0);
}
else
{
idb.AddParameter("@WHP_IsDone", wH_Payable.WHP_IsDone);
}
if (wH_Payable.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_Payable.Stat);
}
if (wH_Payable.WHP_IsDate == DateTime.MinValue)
{
idb.AddParameter("@WHP_IsDate", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_IsDate", wH_Payable.WHP_IsDate);
}
if (wH_Payable.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_Payable.CreateDate);
}
if (wH_Payable.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_Payable.UpdateDate);
}
if (wH_Payable.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_Payable.DeleteDate);
}
if (string.IsNullOrEmpty(wH_Payable.WHP_UCompany))
{
idb.AddParameter("@WHP_UCompany", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_UCompany", wH_Payable.WHP_UCompany);
}
if (string.IsNullOrEmpty(wH_Payable.WHP_UCompanyCode))
{
idb.AddParameter("@WHP_UCompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_UCompanyCode", wH_Payable.WHP_UCompanyCode);
}
if (wH_Payable.WHP_broom == 0)
{
idb.AddParameter("@WHP_broom", 0);
}
else
{
idb.AddParameter("@WHP_broom", wH_Payable.WHP_broom);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加后勤车辆维修记录 Vehicles_Repair对象(即:一条记录)
/// </summary>
public int Add(Vehicles_Repair vehicles_Repair)
{
string sql = "INSERT INTO Vehicles_Repair (VRepair_Code,VRepair_VehiclesNo,VRepair_VehiclesCode,VRepair_Date,VRepair_Object,VRepair_Material,VRepair_TimeCost,VRepair_Cost,VRepair_Position,VRepair_Operator,VRepair_Company,VRepair_Dept,VRepair_Remark,Stat,CreateDate,UpdateDate,DeleteDate,VRepair_itype) VALUES (@VRepair_Code,@VRepair_VehiclesNo,@VRepair_VehiclesCode,@VRepair_Date,@VRepair_Object,@VRepair_Material,@VRepair_TimeCost,@VRepair_Cost,@VRepair_Position,@VRepair_Operator,@VRepair_Company,@VRepair_Dept,@VRepair_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@VRepair_itype)";
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Code))
{
idb.AddParameter("@VRepair_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Code", vehicles_Repair.VRepair_Code);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_VehiclesNo))
{
idb.AddParameter("@VRepair_VehiclesNo", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_VehiclesNo", vehicles_Repair.VRepair_VehiclesNo);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_VehiclesCode))
{
idb.AddParameter("@VRepair_VehiclesCode", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_VehiclesCode", vehicles_Repair.VRepair_VehiclesCode);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Date))
{
idb.AddParameter("@VRepair_Date", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Date", vehicles_Repair.VRepair_Date);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Object))
{
idb.AddParameter("@VRepair_Object", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Object", vehicles_Repair.VRepair_Object);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Material))
{
idb.AddParameter("@VRepair_Material", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Material", vehicles_Repair.VRepair_Material);
}
if (vehicles_Repair.VRepair_TimeCost == 0)
{
idb.AddParameter("@VRepair_TimeCost", 0);
}
else
{
idb.AddParameter("@VRepair_TimeCost", vehicles_Repair.VRepair_TimeCost);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Cost))
{
idb.AddParameter("@VRepair_Cost", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Cost", vehicles_Repair.VRepair_Cost);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Position))
{
idb.AddParameter("@VRepair_Position", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Position", vehicles_Repair.VRepair_Position);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Operator))
{
idb.AddParameter("@VRepair_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Operator", vehicles_Repair.VRepair_Operator);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Company))
{
idb.AddParameter("@VRepair_Company", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Company", vehicles_Repair.VRepair_Company);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Dept))
{
idb.AddParameter("@VRepair_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Dept", vehicles_Repair.VRepair_Dept);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Remark))
{
idb.AddParameter("@VRepair_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Remark", vehicles_Repair.VRepair_Remark);
}
if (vehicles_Repair.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", vehicles_Repair.Stat);
}
if (vehicles_Repair.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", vehicles_Repair.CreateDate);
}
if (vehicles_Repair.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", vehicles_Repair.UpdateDate);
}
if (vehicles_Repair.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", vehicles_Repair.DeleteDate);
}
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_itype))
{
idb.AddParameter("@VRepair_itype", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_itype", vehicles_Repair.VRepair_itype);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加设备信息 Equ_Information对象(即:一条记录)
/// </summary>
public int Add(Equ_Information equ_Information)
{
string sql = "INSERT INTO Equ_Information (EquInfo_SupCode,EquInfo_Code,EquInfo_Name,EquInfo_ICode,EquInfo_TCode,EquInfo_Spec,EquInfo_Manu,EquInfo_DeptCode,EquInfo_DeptName,EquInfo_PartInfo,EquInfo_TechInfo,EquInfo_TechVar,EquInfo_Addr,EquInfo_Type,EquInfo_CCode,EquInfo_Cost,EquInfo_IsFix,Stat) VALUES (@EquInfo_SupCode,@EquInfo_Code,@EquInfo_Name,@EquInfo_ICode,@EquInfo_TCode,@EquInfo_Spec,@EquInfo_Manu,@EquInfo_DeptCode,@EquInfo_DeptName,@EquInfo_PartInfo,@EquInfo_TechInfo,@EquInfo_TechVar,@EquInfo_Addr,@EquInfo_Type,@EquInfo_CCode,@EquInfo_Cost,@EquInfo_IsFix,@Stat)";
if (string.IsNullOrEmpty(equ_Information.EquInfo_SupCode))
{
idb.AddParameter("@EquInfo_SupCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_SupCode", equ_Information.EquInfo_SupCode);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_Code))
{
idb.AddParameter("@EquInfo_Code", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Code", equ_Information.EquInfo_Code);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_Name))
{
idb.AddParameter("@EquInfo_Name", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Name", equ_Information.EquInfo_Name);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_ICode))
{
idb.AddParameter("@EquInfo_ICode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_ICode", equ_Information.EquInfo_ICode);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_TCode))
{
idb.AddParameter("@EquInfo_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_TCode", equ_Information.EquInfo_TCode);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_Spec))
{
idb.AddParameter("@EquInfo_Spec", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Spec", equ_Information.EquInfo_Spec);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_Manu))
{
idb.AddParameter("@EquInfo_Manu", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Manu", equ_Information.EquInfo_Manu);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_DeptCode))
{
idb.AddParameter("@EquInfo_DeptCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_DeptCode", equ_Information.EquInfo_DeptCode);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_DeptName))
{
idb.AddParameter("@EquInfo_DeptName", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_DeptName", equ_Information.EquInfo_DeptName);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_PartInfo))
{
idb.AddParameter("@EquInfo_PartInfo", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_PartInfo", equ_Information.EquInfo_PartInfo);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_TechInfo))
{
idb.AddParameter("@EquInfo_TechInfo", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_TechInfo", equ_Information.EquInfo_TechInfo);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_TechVar))
{
idb.AddParameter("@EquInfo_TechVar", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_TechVar", equ_Information.EquInfo_TechVar);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_Addr))
{
idb.AddParameter("@EquInfo_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Addr", equ_Information.EquInfo_Addr);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_Type))
{
idb.AddParameter("@EquInfo_Type", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Type", equ_Information.EquInfo_Type);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_CCode))
{
idb.AddParameter("@EquInfo_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_CCode", equ_Information.EquInfo_CCode);
}
if (equ_Information.EquInfo_Cost == 0)
{
idb.AddParameter("@EquInfo_Cost", 0);
}
else
{
idb.AddParameter("@EquInfo_Cost", equ_Information.EquInfo_Cost);
}
if (string.IsNullOrEmpty(equ_Information.EquInfo_IsFix))
{
idb.AddParameter("@EquInfo_IsFix", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_IsFix", equ_Information.EquInfo_IsFix);
}
if (equ_Information.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", equ_Information.Stat);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加原料仓库 PC_Warehouse对象(即:一条记录)
/// </summary>
public object AddWithReturn(PC_Warehouse pC_Warehouse)
{
string sql = "INSERT INTO PC_Warehouse (PCW_Code,PCW_No,PCW_Name,PCW_Unit,PCW_MCode,PCW_MName,PCW_MGroup,PCW_MNum,PCW_MPrice,PCW_iType,PCW_Station,PCW_Remark,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@PCW_Code,@PCW_No,@PCW_Name,@PCW_Unit,@PCW_MCode,@PCW_MName,@PCW_MGroup,@PCW_MNum,@PCW_MPrice,@PCW_iType,@PCW_Station,@PCW_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(pC_Warehouse.PCW_Code))
{
idb.AddParameter("@PCW_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_Code", pC_Warehouse.PCW_Code);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_No))
{
idb.AddParameter("@PCW_No", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_No", pC_Warehouse.PCW_No);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_Name))
{
idb.AddParameter("@PCW_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_Name", pC_Warehouse.PCW_Name);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_Unit))
{
idb.AddParameter("@PCW_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_Unit", pC_Warehouse.PCW_Unit);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_MCode))
{
idb.AddParameter("@PCW_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_MCode", pC_Warehouse.PCW_MCode);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_MName))
{
idb.AddParameter("@PCW_MName", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_MName", pC_Warehouse.PCW_MName);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_MGroup))
{
idb.AddParameter("@PCW_MGroup", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_MGroup", pC_Warehouse.PCW_MGroup);
}
if (pC_Warehouse.PCW_MNum == 0)
{
idb.AddParameter("@PCW_MNum", 0);
}
else
{
idb.AddParameter("@PCW_MNum", pC_Warehouse.PCW_MNum);
}
if (pC_Warehouse.PCW_MPrice == 0)
{
idb.AddParameter("@PCW_MPrice", 0);
}
else
{
idb.AddParameter("@PCW_MPrice", pC_Warehouse.PCW_MPrice);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_iType))
{
idb.AddParameter("@PCW_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_iType", pC_Warehouse.PCW_iType);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_Station))
{
idb.AddParameter("@PCW_Station", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_Station", pC_Warehouse.PCW_Station);
}
if (string.IsNullOrEmpty(pC_Warehouse.PCW_Remark))
{
idb.AddParameter("@PCW_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@PCW_Remark", pC_Warehouse.PCW_Remark);
}
if (pC_Warehouse.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_Warehouse.Stat);
}
if (pC_Warehouse.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_Warehouse.CreateDate);
}
if (pC_Warehouse.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_Warehouse.UpdateDate);
}
if (pC_Warehouse.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_Warehouse.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加客户回访 Customer_Visit对象(即:一条记录)
/// </summary>
public int Add(Customer_Visit customer_Visit)
{
string sql = "INSERT INTO Customer_Visit (CV_Code,CV_PJCode,CV_PJName,CV_PJType,CV_CCode,CV_CName,CV_Place,CV_Level,CV_Count,CV_SupDate,CV_CustAdvice,CV_Remark,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@CV_Code,@CV_PJCode,@CV_PJName,@CV_PJType,@CV_CCode,@CV_CName,@CV_Place,@CV_Level,@CV_Count,@CV_SupDate,@CV_CustAdvice,@CV_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(customer_Visit.CV_Code))
{
idb.AddParameter("@CV_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Code", customer_Visit.CV_Code);
}
if (string.IsNullOrEmpty(customer_Visit.CV_PJCode))
{
idb.AddParameter("@CV_PJCode", DBNull.Value);
}
else
{
idb.AddParameter("@CV_PJCode", customer_Visit.CV_PJCode);
}
if (string.IsNullOrEmpty(customer_Visit.CV_PJName))
{
idb.AddParameter("@CV_PJName", DBNull.Value);
}
else
{
idb.AddParameter("@CV_PJName", customer_Visit.CV_PJName);
}
if (string.IsNullOrEmpty(customer_Visit.CV_PJType))
{
idb.AddParameter("@CV_PJType", DBNull.Value);
}
else
{
idb.AddParameter("@CV_PJType", customer_Visit.CV_PJType);
}
if (string.IsNullOrEmpty(customer_Visit.CV_CCode))
{
idb.AddParameter("@CV_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@CV_CCode", customer_Visit.CV_CCode);
}
if (string.IsNullOrEmpty(customer_Visit.CV_CName))
{
idb.AddParameter("@CV_CName", DBNull.Value);
}
else
{
idb.AddParameter("@CV_CName", customer_Visit.CV_CName);
}
if (string.IsNullOrEmpty(customer_Visit.CV_Place))
{
idb.AddParameter("@CV_Place", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Place", customer_Visit.CV_Place);
}
if (string.IsNullOrEmpty(customer_Visit.CV_Level))
{
idb.AddParameter("@CV_Level", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Level", customer_Visit.CV_Level);
}
if (string.IsNullOrEmpty(customer_Visit.CV_Count))
{
idb.AddParameter("@CV_Count", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Count", customer_Visit.CV_Count);
}
if (customer_Visit.CV_SupDate == DateTime.MinValue)
{
idb.AddParameter("@CV_SupDate", DBNull.Value);
}
else
{
idb.AddParameter("@CV_SupDate", customer_Visit.CV_SupDate);
}
if (string.IsNullOrEmpty(customer_Visit.CV_CustAdvice))
{
idb.AddParameter("@CV_CustAdvice", DBNull.Value);
}
else
{
idb.AddParameter("@CV_CustAdvice", customer_Visit.CV_CustAdvice);
}
if (string.IsNullOrEmpty(customer_Visit.CV_Remark))
{
idb.AddParameter("@CV_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Remark", customer_Visit.CV_Remark);
}
if (customer_Visit.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", customer_Visit.Stat);
}
if (customer_Visit.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", customer_Visit.CreateDate);
}
if (customer_Visit.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", customer_Visit.UpdateDate);
}
if (customer_Visit.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", customer_Visit.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加银行信息 Bse_Bank对象(即:一条记录)
/// </summary>
public int Add(Bse_Bank bse_Bank)
{
string sql = "INSERT INTO Bse_Bank (Module_Code,Record_ID,Bank_Code,Bank_Name,Bank_Branch,Bank_Card,Bank_User,Stat,CreateDate,UpdateDate,DeleteDate,Bank_BranchName) VALUES (@Module_Code,@Record_ID,@Bank_Code,@Bank_Name,@Bank_Branch,@Bank_Card,@Bank_User,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@Bank_BranchName)";
if (string.IsNullOrEmpty(bse_Bank.Module_Code))
{
idb.AddParameter("@Module_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Module_Code", bse_Bank.Module_Code);
}
if (string.IsNullOrEmpty(bse_Bank.Record_ID))
{
idb.AddParameter("@Record_ID", DBNull.Value);
}
else
{
idb.AddParameter("@Record_ID", bse_Bank.Record_ID);
}
if (string.IsNullOrEmpty(bse_Bank.Bank_Code))
{
idb.AddParameter("@Bank_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Code", bse_Bank.Bank_Code);
}
if (string.IsNullOrEmpty(bse_Bank.Bank_Name))
{
idb.AddParameter("@Bank_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Name", bse_Bank.Bank_Name);
}
if (string.IsNullOrEmpty(bse_Bank.Bank_Branch))
{
idb.AddParameter("@Bank_Branch", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Branch", bse_Bank.Bank_Branch);
}
if (string.IsNullOrEmpty(bse_Bank.Bank_Card))
{
idb.AddParameter("@Bank_Card", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Card", bse_Bank.Bank_Card);
}
if (string.IsNullOrEmpty(bse_Bank.Bank_User))
{
idb.AddParameter("@Bank_User", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_User", bse_Bank.Bank_User);
}
if (bse_Bank.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Bank.Stat);
}
if (bse_Bank.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_Bank.CreateDate);
}
if (bse_Bank.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_Bank.UpdateDate);
}
if (bse_Bank.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_Bank.DeleteDate);
}
if (string.IsNullOrEmpty(bse_Bank.Bank_BranchName))
{
idb.AddParameter("@Bank_BranchName", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_BranchName", bse_Bank.Bank_BranchName);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新银行信息 Bse_Bank对象(即:一条记录
/// </summary>
public int Update(Bse_Bank bse_Bank)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_Bank SET ");
if (bse_Bank.Module_Code_IsChanged)
{
sbParameter.Append("Module_Code=@Module_Code, ");
}
if (bse_Bank.Record_ID_IsChanged)
{
sbParameter.Append("Record_ID=@Record_ID, ");
}
if (bse_Bank.Bank_Code_IsChanged)
{
sbParameter.Append("Bank_Code=@Bank_Code, ");
}
if (bse_Bank.Bank_Name_IsChanged)
{
sbParameter.Append("Bank_Name=@Bank_Name, ");
}
if (bse_Bank.Bank_Branch_IsChanged)
{
sbParameter.Append("Bank_Branch=@Bank_Branch, ");
}
if (bse_Bank.Bank_Card_IsChanged)
{
sbParameter.Append("Bank_Card=@Bank_Card, ");
}
if (bse_Bank.Bank_User_IsChanged)
{
sbParameter.Append("Bank_User=@Bank_User, ");
}
if (bse_Bank.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (bse_Bank.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (bse_Bank.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (bse_Bank.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (bse_Bank.Bank_BranchName_IsChanged)
{
sbParameter.Append("Bank_BranchName=@Bank_BranchName ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Bank_ID=@Bank_ID; ");
string sql = sb.ToString();
if (bse_Bank.Module_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Module_Code))
{
idb.AddParameter("@Module_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Module_Code", bse_Bank.Module_Code);
}
}
if (bse_Bank.Record_ID_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Record_ID))
{
idb.AddParameter("@Record_ID", DBNull.Value);
}
else
{
idb.AddParameter("@Record_ID", bse_Bank.Record_ID);
}
}
if (bse_Bank.Bank_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Bank_Code))
{
idb.AddParameter("@Bank_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Code", bse_Bank.Bank_Code);
}
}
if (bse_Bank.Bank_Name_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Bank_Name))
{
idb.AddParameter("@Bank_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Name", bse_Bank.Bank_Name);
}
}
if (bse_Bank.Bank_Branch_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Bank_Branch))
{
idb.AddParameter("@Bank_Branch", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Branch", bse_Bank.Bank_Branch);
}
}
if (bse_Bank.Bank_Card_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Bank_Card))
{
idb.AddParameter("@Bank_Card", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_Card", bse_Bank.Bank_Card);
}
}
if (bse_Bank.Bank_User_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Bank_User))
{
idb.AddParameter("@Bank_User", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_User", bse_Bank.Bank_User);
}
}
if (bse_Bank.Stat_IsChanged)
{
if (bse_Bank.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Bank.Stat);
}
}
if (bse_Bank.CreateDate_IsChanged)
{
if (bse_Bank.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_Bank.CreateDate);
}
}
if (bse_Bank.UpdateDate_IsChanged)
{
if (bse_Bank.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_Bank.UpdateDate);
}
}
if (bse_Bank.DeleteDate_IsChanged)
{
if (bse_Bank.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_Bank.DeleteDate);
}
}
if (bse_Bank.Bank_BranchName_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bank.Bank_BranchName))
{
idb.AddParameter("@Bank_BranchName", DBNull.Value);
}
else
{
idb.AddParameter("@Bank_BranchName", bse_Bank.Bank_BranchName);
}
}
idb.AddParameter("@Bank_ID", bse_Bank.Bank_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新后勤车辆加油记录 Vehicles_OilRecord对象(即:一条记录
/// </summary>
public int Update(Vehicles_OilRecord vehicles_OilRecord)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Vehicles_OilRecord SET ");
if (vehicles_OilRecord.VOR_Code_IsChanged)
{
sbParameter.Append("VOR_Code=@VOR_Code, ");
}
if (vehicles_OilRecord.VOR_VehiclesNo_IsChanged)
{
sbParameter.Append("VOR_VehiclesNo=@VOR_VehiclesNo, ");
}
if (vehicles_OilRecord.VOR_VehiclesCode_IsChanged)
{
sbParameter.Append("VOR_VehiclesCode=@VOR_VehiclesCode, ");
}
if (vehicles_OilRecord.VOR_RealCost_IsChanged)
{
sbParameter.Append("VOR_RealCost=@VOR_RealCost, ");
}
if (vehicles_OilRecord.VOR_Cost_IsChanged)
{
sbParameter.Append("VOR_Cost=@VOR_Cost, ");
}
if (vehicles_OilRecord.VOR_Count_IsChanged)
{
sbParameter.Append("VOR_Count=@VOR_Count, ");
}
if (vehicles_OilRecord.VOR_ReturnMoney_IsChanged)
{
sbParameter.Append("VOR_ReturnMoney=@VOR_ReturnMoney, ");
}
if (vehicles_OilRecord.VOR_Unit_IsChanged)
{
sbParameter.Append("VOR_Unit=@VOR_Unit, ");
}
if (vehicles_OilRecord.VOR_Mile_IsChanged)
{
sbParameter.Append("VOR_Mile=@VOR_Mile, ");
}
if (vehicles_OilRecord.VOR_Date_IsChanged)
{
sbParameter.Append("VOR_Date=@VOR_Date, ");
}
if (vehicles_OilRecord.VOR_Company_IsChanged)
{
sbParameter.Append("VOR_Company=@VOR_Company, ");
}
if (vehicles_OilRecord.VOR_Dept_IsChanged)
{
sbParameter.Append("VOR_Dept=@VOR_Dept, ");
}
if (vehicles_OilRecord.VOR_Remark_IsChanged)
{
sbParameter.Append("VOR_Remark=@VOR_Remark, ");
}
if (vehicles_OilRecord.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (vehicles_OilRecord.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (vehicles_OilRecord.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (vehicles_OilRecord.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (vehicles_OilRecord.VOR_itype_IsChanged)
{
sbParameter.Append("VOR_itype=@VOR_itype, ");
}
if (vehicles_OilRecord.VOR_TCode_IsChanged)
{
sbParameter.Append("VOR_TCode=@VOR_TCode, ");
}
if (vehicles_OilRecord.VOR_CompanyCode_IsChanged)
{
sbParameter.Append("VOR_CompanyCode=@VOR_CompanyCode, ");
}
if (vehicles_OilRecord.VOR_DeptCode_IsChanged)
{
sbParameter.Append("VOR_DeptCode=@VOR_DeptCode ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and VOR_ID=@VOR_ID; ");
string sql = sb.ToString();
if (vehicles_OilRecord.VOR_Code_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Code))
{
idb.AddParameter("@VOR_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Code", vehicles_OilRecord.VOR_Code);
}
}
if (vehicles_OilRecord.VOR_VehiclesNo_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_VehiclesNo))
{
idb.AddParameter("@VOR_VehiclesNo", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_VehiclesNo", vehicles_OilRecord.VOR_VehiclesNo);
}
}
if (vehicles_OilRecord.VOR_VehiclesCode_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_VehiclesCode))
{
idb.AddParameter("@VOR_VehiclesCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_VehiclesCode", vehicles_OilRecord.VOR_VehiclesCode);
}
}
if (vehicles_OilRecord.VOR_RealCost_IsChanged)
{
if (vehicles_OilRecord.VOR_RealCost == 0)
{
idb.AddParameter("@VOR_RealCost", 0);
}
else
{
idb.AddParameter("@VOR_RealCost", vehicles_OilRecord.VOR_RealCost);
}
}
if (vehicles_OilRecord.VOR_Cost_IsChanged)
{
if (vehicles_OilRecord.VOR_Cost == 0)
{
idb.AddParameter("@VOR_Cost", 0);
}
else
{
idb.AddParameter("@VOR_Cost", vehicles_OilRecord.VOR_Cost);
}
}
if (vehicles_OilRecord.VOR_Count_IsChanged)
{
if (vehicles_OilRecord.VOR_Count == 0)
{
idb.AddParameter("@VOR_Count", 0);
}
else
{
idb.AddParameter("@VOR_Count", vehicles_OilRecord.VOR_Count);
}
}
if (vehicles_OilRecord.VOR_ReturnMoney_IsChanged)
{
if (vehicles_OilRecord.VOR_ReturnMoney == 0)
{
idb.AddParameter("@VOR_ReturnMoney", 0);
}
else
{
idb.AddParameter("@VOR_ReturnMoney", vehicles_OilRecord.VOR_ReturnMoney);
}
}
if (vehicles_OilRecord.VOR_Unit_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Unit))
{
idb.AddParameter("@VOR_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Unit", vehicles_OilRecord.VOR_Unit);
}
}
if (vehicles_OilRecord.VOR_Mile_IsChanged)
{
if (vehicles_OilRecord.VOR_Mile == 0)
{
idb.AddParameter("@VOR_Mile", 0);
}
else
{
idb.AddParameter("@VOR_Mile", vehicles_OilRecord.VOR_Mile);
}
}
if (vehicles_OilRecord.VOR_Date_IsChanged)
{
if (vehicles_OilRecord.VOR_Date == DateTime.MinValue)
{
idb.AddParameter("@VOR_Date", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Date", vehicles_OilRecord.VOR_Date);
}
}
if (vehicles_OilRecord.VOR_Company_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Company))
{
idb.AddParameter("@VOR_Company", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Company", vehicles_OilRecord.VOR_Company);
}
}
if (vehicles_OilRecord.VOR_Dept_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Dept))
{
idb.AddParameter("@VOR_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Dept", vehicles_OilRecord.VOR_Dept);
}
}
if (vehicles_OilRecord.VOR_Remark_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Remark))
{
idb.AddParameter("@VOR_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Remark", vehicles_OilRecord.VOR_Remark);
}
}
if (vehicles_OilRecord.Stat_IsChanged)
{
if (vehicles_OilRecord.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", vehicles_OilRecord.Stat);
}
}
if (vehicles_OilRecord.CreateDate_IsChanged)
{
if (vehicles_OilRecord.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", vehicles_OilRecord.CreateDate);
}
}
if (vehicles_OilRecord.UpdateDate_IsChanged)
{
if (vehicles_OilRecord.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", vehicles_OilRecord.UpdateDate);
}
}
if (vehicles_OilRecord.DeleteDate_IsChanged)
{
if (vehicles_OilRecord.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", vehicles_OilRecord.DeleteDate);
}
}
if (vehicles_OilRecord.VOR_itype_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_itype))
{
idb.AddParameter("@VOR_itype", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_itype", vehicles_OilRecord.VOR_itype);
}
}
if (vehicles_OilRecord.VOR_TCode_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_TCode))
{
idb.AddParameter("@VOR_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_TCode", vehicles_OilRecord.VOR_TCode);
}
}
if (vehicles_OilRecord.VOR_CompanyCode_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_CompanyCode))
{
idb.AddParameter("@VOR_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_CompanyCode", vehicles_OilRecord.VOR_CompanyCode);
}
}
if (vehicles_OilRecord.VOR_DeptCode_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_DeptCode))
{
idb.AddParameter("@VOR_DeptCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_DeptCode", vehicles_OilRecord.VOR_DeptCode);
}
}
idb.AddParameter("@VOR_ID", vehicles_OilRecord.VOR_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加后勤车辆加油记录 Vehicles_OilRecord对象(即:一条记录)
/// </summary>
public object AddWithReturn(Vehicles_OilRecord vehicles_OilRecord)
{
string sql = "INSERT INTO Vehicles_OilRecord (VOR_Code,VOR_VehiclesNo,VOR_VehiclesCode,VOR_RealCost,VOR_Cost,VOR_Count,VOR_ReturnMoney,VOR_Unit,VOR_Mile,VOR_Date,VOR_Company,VOR_Dept,VOR_Remark,Stat,CreateDate,UpdateDate,DeleteDate,VOR_itype,VOR_TCode,VOR_CompanyCode,VOR_DeptCode) VALUES (@VOR_Code,@VOR_VehiclesNo,@VOR_VehiclesCode,@VOR_RealCost,@VOR_Cost,@VOR_Count,@VOR_ReturnMoney,@VOR_Unit,@VOR_Mile,@VOR_Date,@VOR_Company,@VOR_Dept,@VOR_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@VOR_itype,@VOR_TCode,@VOR_CompanyCode,@VOR_DeptCode);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Code))
{
idb.AddParameter("@VOR_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Code", vehicles_OilRecord.VOR_Code);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_VehiclesNo))
{
idb.AddParameter("@VOR_VehiclesNo", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_VehiclesNo", vehicles_OilRecord.VOR_VehiclesNo);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_VehiclesCode))
{
idb.AddParameter("@VOR_VehiclesCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_VehiclesCode", vehicles_OilRecord.VOR_VehiclesCode);
}
if (vehicles_OilRecord.VOR_RealCost == 0)
{
idb.AddParameter("@VOR_RealCost", 0);
}
else
{
idb.AddParameter("@VOR_RealCost", vehicles_OilRecord.VOR_RealCost);
}
if (vehicles_OilRecord.VOR_Cost == 0)
{
idb.AddParameter("@VOR_Cost", 0);
}
else
{
idb.AddParameter("@VOR_Cost", vehicles_OilRecord.VOR_Cost);
}
if (vehicles_OilRecord.VOR_Count == 0)
{
idb.AddParameter("@VOR_Count", 0);
}
else
{
idb.AddParameter("@VOR_Count", vehicles_OilRecord.VOR_Count);
}
if (vehicles_OilRecord.VOR_ReturnMoney == 0)
{
idb.AddParameter("@VOR_ReturnMoney", 0);
}
else
{
idb.AddParameter("@VOR_ReturnMoney", vehicles_OilRecord.VOR_ReturnMoney);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Unit))
{
idb.AddParameter("@VOR_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Unit", vehicles_OilRecord.VOR_Unit);
}
if (vehicles_OilRecord.VOR_Mile == 0)
{
idb.AddParameter("@VOR_Mile", 0);
}
else
{
idb.AddParameter("@VOR_Mile", vehicles_OilRecord.VOR_Mile);
}
if (vehicles_OilRecord.VOR_Date == DateTime.MinValue)
{
idb.AddParameter("@VOR_Date", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Date", vehicles_OilRecord.VOR_Date);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Company))
{
idb.AddParameter("@VOR_Company", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Company", vehicles_OilRecord.VOR_Company);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Dept))
{
idb.AddParameter("@VOR_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Dept", vehicles_OilRecord.VOR_Dept);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_Remark))
{
idb.AddParameter("@VOR_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_Remark", vehicles_OilRecord.VOR_Remark);
}
if (vehicles_OilRecord.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", vehicles_OilRecord.Stat);
}
if (vehicles_OilRecord.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", vehicles_OilRecord.CreateDate);
}
if (vehicles_OilRecord.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", vehicles_OilRecord.UpdateDate);
}
if (vehicles_OilRecord.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", vehicles_OilRecord.DeleteDate);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_itype))
{
idb.AddParameter("@VOR_itype", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_itype", vehicles_OilRecord.VOR_itype);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_TCode))
{
idb.AddParameter("@VOR_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_TCode", vehicles_OilRecord.VOR_TCode);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_CompanyCode))
{
idb.AddParameter("@VOR_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_CompanyCode", vehicles_OilRecord.VOR_CompanyCode);
}
if (string.IsNullOrEmpty(vehicles_OilRecord.VOR_DeptCode))
{
idb.AddParameter("@VOR_DeptCode", DBNull.Value);
}
else
{
idb.AddParameter("@VOR_DeptCode", vehicles_OilRecord.VOR_DeptCode);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新TC_Equ对象(即:一条记录
/// </summary>
public int Update(TC_Equ tC_Equ)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE TC_Equ SET ");
if (tC_Equ.TCE_Code_IsChanged)
{
sbParameter.Append("TCE_Code=@TCE_Code, ");
}
if (tC_Equ.TCE_ECode_IsChanged)
{
sbParameter.Append("TCE_ECode=@TCE_ECode, ");
}
if (tC_Equ.TCE_Spec_IsChanged)
{
sbParameter.Append("TCE_Spec=@TCE_Spec, ");
}
if (tC_Equ.TCE_Date_IsChanged)
{
sbParameter.Append("TCE_Date=@TCE_Date, ");
}
if (tC_Equ.TCE_Checker_IsChanged)
{
sbParameter.Append("TCE_Checker=@TCE_Checker, ");
}
if (tC_Equ.TCE_CheckDate_IsChanged)
{
sbParameter.Append("TCE_CheckDate=@TCE_CheckDate, ");
}
if (tC_Equ.TCE_Operator_IsChanged)
{
sbParameter.Append("TCE_Operator=@TCE_Operator, ");
}
if (tC_Equ.TCE_OpDate_IsChanged)
{
sbParameter.Append("TCE_OpDate=@TCE_OpDate, ");
}
if (tC_Equ.TCE_Company_IsChanged)
{
sbParameter.Append("TCE_Company=@TCE_Company, ");
}
if (tC_Equ.TCE_Dept_IsChanged)
{
sbParameter.Append("TCE_Dept=@TCE_Dept, ");
}
if (tC_Equ.TCE_Description_IsChanged)
{
sbParameter.Append("TCE_Description=@TCE_Description, ");
}
if (tC_Equ.TCE_Remark_IsChanged)
{
sbParameter.Append("TCE_Remark=@TCE_Remark, ");
}
if (tC_Equ.TCE_UDef1_IsChanged)
{
sbParameter.Append("TCE_UDef1=@TCE_UDef1, ");
}
if (tC_Equ.TCE_UDef2_IsChanged)
{
sbParameter.Append("TCE_UDef2=@TCE_UDef2, ");
}
if (tC_Equ.TCE_UDef3_IsChanged)
{
sbParameter.Append("TCE_UDef3=@TCE_UDef3, ");
}
if (tC_Equ.TCE_UDef4_IsChanged)
{
sbParameter.Append("TCE_UDef4=@TCE_UDef4, ");
}
if (tC_Equ.TCE_UDef5_IsChanged)
{
sbParameter.Append("TCE_UDef5=@TCE_UDef5, ");
}
if (tC_Equ.TCE_UDef6_IsChanged)
{
sbParameter.Append("TCE_UDef6=@TCE_UDef6, ");
}
if (tC_Equ.TCE_TCode_IsChanged)
{
sbParameter.Append("TCE_TCode=@TCE_TCode, ");
}
if (tC_Equ.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (tC_Equ.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (tC_Equ.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (tC_Equ.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and TCE_ID=@TCE_ID; ");
string sql = sb.ToString();
if (tC_Equ.TCE_Code_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Code))
{
idb.AddParameter("@TCE_Code", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Code", tC_Equ.TCE_Code);
}
}
if (tC_Equ.TCE_ECode_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_ECode))
{
idb.AddParameter("@TCE_ECode", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_ECode", tC_Equ.TCE_ECode);
}
}
if (tC_Equ.TCE_Spec_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Spec))
{
idb.AddParameter("@TCE_Spec", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Spec", tC_Equ.TCE_Spec);
}
}
if (tC_Equ.TCE_Date_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Date))
{
idb.AddParameter("@TCE_Date", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Date", tC_Equ.TCE_Date);
}
}
if (tC_Equ.TCE_Checker_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Checker))
{
idb.AddParameter("@TCE_Checker", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Checker", tC_Equ.TCE_Checker);
}
}
if (tC_Equ.TCE_CheckDate_IsChanged)
{
if (tC_Equ.TCE_CheckDate == DateTime.MinValue)
{
idb.AddParameter("@TCE_CheckDate", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_CheckDate", tC_Equ.TCE_CheckDate);
}
}
if (tC_Equ.TCE_Operator_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Operator))
{
idb.AddParameter("@TCE_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Operator", tC_Equ.TCE_Operator);
}
}
if (tC_Equ.TCE_OpDate_IsChanged)
{
if (tC_Equ.TCE_OpDate == DateTime.MinValue)
{
idb.AddParameter("@TCE_OpDate", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_OpDate", tC_Equ.TCE_OpDate);
}
}
if (tC_Equ.TCE_Company_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Company))
{
idb.AddParameter("@TCE_Company", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Company", tC_Equ.TCE_Company);
}
}
if (tC_Equ.TCE_Dept_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Dept))
{
idb.AddParameter("@TCE_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Dept", tC_Equ.TCE_Dept);
}
}
if (tC_Equ.TCE_Description_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Description))
{
idb.AddParameter("@TCE_Description", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Description", tC_Equ.TCE_Description);
}
}
if (tC_Equ.TCE_Remark_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_Remark))
{
idb.AddParameter("@TCE_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_Remark", tC_Equ.TCE_Remark);
}
}
if (tC_Equ.TCE_UDef1_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef1))
{
idb.AddParameter("@TCE_UDef1", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef1", tC_Equ.TCE_UDef1);
}
}
if (tC_Equ.TCE_UDef2_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef2))
{
idb.AddParameter("@TCE_UDef2", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef2", tC_Equ.TCE_UDef2);
}
}
if (tC_Equ.TCE_UDef3_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef3))
{
idb.AddParameter("@TCE_UDef3", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef3", tC_Equ.TCE_UDef3);
}
}
if (tC_Equ.TCE_UDef4_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef4))
{
idb.AddParameter("@TCE_UDef4", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef4", tC_Equ.TCE_UDef4);
}
}
if (tC_Equ.TCE_UDef5_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef5))
{
idb.AddParameter("@TCE_UDef5", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef5", tC_Equ.TCE_UDef5);
}
}
if (tC_Equ.TCE_UDef6_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_UDef6))
{
idb.AddParameter("@TCE_UDef6", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_UDef6", tC_Equ.TCE_UDef6);
}
}
if (tC_Equ.TCE_TCode_IsChanged)
{
if (string.IsNullOrEmpty(tC_Equ.TCE_TCode))
{
idb.AddParameter("@TCE_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@TCE_TCode", tC_Equ.TCE_TCode);
}
}
if (tC_Equ.Stat_IsChanged)
{
if (tC_Equ.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", tC_Equ.Stat);
}
}
if (tC_Equ.CreateDate_IsChanged)
{
if (tC_Equ.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", tC_Equ.CreateDate);
}
}
if (tC_Equ.UpdateDate_IsChanged)
{
if (tC_Equ.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", tC_Equ.UpdateDate);
}
}
if (tC_Equ.DeleteDate_IsChanged)
{
if (tC_Equ.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", tC_Equ.DeleteDate);
}
}
idb.AddParameter("@TCE_ID", tC_Equ.TCE_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加Bse_CanteenItem对象(即:一条记录)
/// </summary>
public object AddWithReturn(Bse_CanteenItem bse_CanteenItem)
{
string sql = "INSERT INTO Bse_CanteenItem (CanteenItem_Code,CanteenItem_Name,CanteenItem_Type,CanteenItem_Address,CanteenItem_Contractor,CanteenItem_Charger,CanteenItem_ChargerContact,CanteenItem_Remark,Stat,CreateDate,UpdateDate,DeleteDate,CanteenItem_Company,CanteenItem_Department,CanteenItem_Start,CanteenItem_End) VALUES (@CanteenItem_Code,@CanteenItem_Name,@CanteenItem_Type,@CanteenItem_Address,@CanteenItem_Contractor,@CanteenItem_Charger,@CanteenItem_ChargerContact,@CanteenItem_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@CanteenItem_Company,@CanteenItem_Department,@CanteenItem_Start,@CanteenItem_End);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Code))
{
idb.AddParameter("@CanteenItem_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Code", bse_CanteenItem.CanteenItem_Code);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Name))
{
idb.AddParameter("@CanteenItem_Name", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Name", bse_CanteenItem.CanteenItem_Name);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Type))
{
idb.AddParameter("@CanteenItem_Type", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Type", bse_CanteenItem.CanteenItem_Type);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Address))
{
idb.AddParameter("@CanteenItem_Address", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Address", bse_CanteenItem.CanteenItem_Address);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Contractor))
{
idb.AddParameter("@CanteenItem_Contractor", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Contractor", bse_CanteenItem.CanteenItem_Contractor);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Charger))
{
idb.AddParameter("@CanteenItem_Charger", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Charger", bse_CanteenItem.CanteenItem_Charger);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_ChargerContact))
{
idb.AddParameter("@CanteenItem_ChargerContact", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_ChargerContact", bse_CanteenItem.CanteenItem_ChargerContact);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Remark))
{
idb.AddParameter("@CanteenItem_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Remark", bse_CanteenItem.CanteenItem_Remark);
}
if (bse_CanteenItem.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_CanteenItem.Stat);
}
if (bse_CanteenItem.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_CanteenItem.CreateDate);
}
if (bse_CanteenItem.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_CanteenItem.UpdateDate);
}
if (bse_CanteenItem.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_CanteenItem.DeleteDate);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Company))
{
idb.AddParameter("@CanteenItem_Company", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Company", bse_CanteenItem.CanteenItem_Company);
}
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Department))
{
idb.AddParameter("@CanteenItem_Department", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Department", bse_CanteenItem.CanteenItem_Department);
}
if (bse_CanteenItem.CanteenItem_Start == DateTime.MinValue)
{
idb.AddParameter("@CanteenItem_Start", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Start", bse_CanteenItem.CanteenItem_Start);
}
if (bse_CanteenItem.CanteenItem_End == DateTime.MinValue)
{
idb.AddParameter("@CanteenItem_End", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_End", bse_CanteenItem.CanteenItem_End);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新客户回访 Customer_Visit对象(即:一条记录
/// </summary>
public int Update(Customer_Visit customer_Visit)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Customer_Visit SET ");
if (customer_Visit.CV_Code_IsChanged)
{
sbParameter.Append("CV_Code=@CV_Code, ");
}
if (customer_Visit.CV_PJCode_IsChanged)
{
sbParameter.Append("CV_PJCode=@CV_PJCode, ");
}
if (customer_Visit.CV_PJName_IsChanged)
{
sbParameter.Append("CV_PJName=@CV_PJName, ");
}
if (customer_Visit.CV_PJType_IsChanged)
{
sbParameter.Append("CV_PJType=@CV_PJType, ");
}
if (customer_Visit.CV_CCode_IsChanged)
{
sbParameter.Append("CV_CCode=@CV_CCode, ");
}
if (customer_Visit.CV_CName_IsChanged)
{
sbParameter.Append("CV_CName=@CV_CName, ");
}
if (customer_Visit.CV_Place_IsChanged)
{
sbParameter.Append("CV_Place=@CV_Place, ");
}
if (customer_Visit.CV_Level_IsChanged)
{
sbParameter.Append("CV_Level=@CV_Level, ");
}
if (customer_Visit.CV_Count_IsChanged)
{
sbParameter.Append("CV_Count=@CV_Count, ");
}
if (customer_Visit.CV_SupDate_IsChanged)
{
sbParameter.Append("CV_SupDate=@CV_SupDate, ");
}
if (customer_Visit.CV_CustAdvice_IsChanged)
{
sbParameter.Append("CV_CustAdvice=@CV_CustAdvice, ");
}
if (customer_Visit.CV_Remark_IsChanged)
{
sbParameter.Append("CV_Remark=@CV_Remark, ");
}
if (customer_Visit.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (customer_Visit.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (customer_Visit.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (customer_Visit.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CV_ID=@CV_ID; ");
string sql = sb.ToString();
if (customer_Visit.CV_Code_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_Code))
{
idb.AddParameter("@CV_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Code", customer_Visit.CV_Code);
}
}
if (customer_Visit.CV_PJCode_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_PJCode))
{
idb.AddParameter("@CV_PJCode", DBNull.Value);
}
else
{
idb.AddParameter("@CV_PJCode", customer_Visit.CV_PJCode);
}
}
if (customer_Visit.CV_PJName_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_PJName))
{
idb.AddParameter("@CV_PJName", DBNull.Value);
}
else
{
idb.AddParameter("@CV_PJName", customer_Visit.CV_PJName);
}
}
if (customer_Visit.CV_PJType_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_PJType))
{
idb.AddParameter("@CV_PJType", DBNull.Value);
}
else
{
idb.AddParameter("@CV_PJType", customer_Visit.CV_PJType);
}
}
if (customer_Visit.CV_CCode_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_CCode))
{
idb.AddParameter("@CV_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@CV_CCode", customer_Visit.CV_CCode);
}
}
if (customer_Visit.CV_CName_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_CName))
{
idb.AddParameter("@CV_CName", DBNull.Value);
}
else
{
idb.AddParameter("@CV_CName", customer_Visit.CV_CName);
}
}
if (customer_Visit.CV_Place_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_Place))
{
idb.AddParameter("@CV_Place", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Place", customer_Visit.CV_Place);
}
}
if (customer_Visit.CV_Level_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_Level))
{
idb.AddParameter("@CV_Level", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Level", customer_Visit.CV_Level);
}
}
if (customer_Visit.CV_Count_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_Count))
{
idb.AddParameter("@CV_Count", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Count", customer_Visit.CV_Count);
}
}
if (customer_Visit.CV_SupDate_IsChanged)
{
if (customer_Visit.CV_SupDate == DateTime.MinValue)
{
idb.AddParameter("@CV_SupDate", DBNull.Value);
}
else
{
idb.AddParameter("@CV_SupDate", customer_Visit.CV_SupDate);
}
}
if (customer_Visit.CV_CustAdvice_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_CustAdvice))
{
idb.AddParameter("@CV_CustAdvice", DBNull.Value);
}
else
{
idb.AddParameter("@CV_CustAdvice", customer_Visit.CV_CustAdvice);
}
}
if (customer_Visit.CV_Remark_IsChanged)
{
if (string.IsNullOrEmpty(customer_Visit.CV_Remark))
{
idb.AddParameter("@CV_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@CV_Remark", customer_Visit.CV_Remark);
}
}
if (customer_Visit.Stat_IsChanged)
{
if (customer_Visit.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", customer_Visit.Stat);
}
}
if (customer_Visit.CreateDate_IsChanged)
{
if (customer_Visit.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", customer_Visit.CreateDate);
}
}
if (customer_Visit.UpdateDate_IsChanged)
{
if (customer_Visit.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", customer_Visit.UpdateDate);
}
}
if (customer_Visit.DeleteDate_IsChanged)
{
if (customer_Visit.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", customer_Visit.DeleteDate);
}
}
idb.AddParameter("@CV_ID", customer_Visit.CV_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新Bse_CanteenItem对象(即:一条记录
/// </summary>
public int Update(Bse_CanteenItem bse_CanteenItem)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_CanteenItem SET ");
if (bse_CanteenItem.CanteenItem_Code_IsChanged)
{
sbParameter.Append("CanteenItem_Code=@CanteenItem_Code, ");
}
if (bse_CanteenItem.CanteenItem_Name_IsChanged)
{
sbParameter.Append("CanteenItem_Name=@CanteenItem_Name, ");
}
if (bse_CanteenItem.CanteenItem_Type_IsChanged)
{
sbParameter.Append("CanteenItem_Type=@CanteenItem_Type, ");
}
if (bse_CanteenItem.CanteenItem_Address_IsChanged)
{
sbParameter.Append("CanteenItem_Address=@CanteenItem_Address, ");
}
if (bse_CanteenItem.CanteenItem_Contractor_IsChanged)
{
sbParameter.Append("CanteenItem_Contractor=@CanteenItem_Contractor, ");
}
if (bse_CanteenItem.CanteenItem_Charger_IsChanged)
{
sbParameter.Append("CanteenItem_Charger=@CanteenItem_Charger, ");
}
if (bse_CanteenItem.CanteenItem_ChargerContact_IsChanged)
{
sbParameter.Append("CanteenItem_ChargerContact=@CanteenItem_ChargerContact, ");
}
if (bse_CanteenItem.CanteenItem_Remark_IsChanged)
{
sbParameter.Append("CanteenItem_Remark=@CanteenItem_Remark, ");
}
if (bse_CanteenItem.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (bse_CanteenItem.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (bse_CanteenItem.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (bse_CanteenItem.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (bse_CanteenItem.CanteenItem_Company_IsChanged)
{
sbParameter.Append("CanteenItem_Company=@CanteenItem_Company, ");
}
if (bse_CanteenItem.CanteenItem_Department_IsChanged)
{
sbParameter.Append("CanteenItem_Department=@CanteenItem_Department, ");
}
if (bse_CanteenItem.CanteenItem_Start_IsChanged)
{
sbParameter.Append("CanteenItem_Start=@CanteenItem_Start, ");
}
if (bse_CanteenItem.CanteenItem_End_IsChanged)
{
sbParameter.Append("CanteenItem_End=@CanteenItem_End ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CanteenItem_ID=@CanteenItem_ID; ");
string sql = sb.ToString();
if (bse_CanteenItem.CanteenItem_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Code))
{
idb.AddParameter("@CanteenItem_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Code", bse_CanteenItem.CanteenItem_Code);
}
}
if (bse_CanteenItem.CanteenItem_Name_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Name))
{
idb.AddParameter("@CanteenItem_Name", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Name", bse_CanteenItem.CanteenItem_Name);
}
}
if (bse_CanteenItem.CanteenItem_Type_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Type))
{
idb.AddParameter("@CanteenItem_Type", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Type", bse_CanteenItem.CanteenItem_Type);
}
}
if (bse_CanteenItem.CanteenItem_Address_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Address))
{
idb.AddParameter("@CanteenItem_Address", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Address", bse_CanteenItem.CanteenItem_Address);
}
}
if (bse_CanteenItem.CanteenItem_Contractor_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Contractor))
{
idb.AddParameter("@CanteenItem_Contractor", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Contractor", bse_CanteenItem.CanteenItem_Contractor);
}
}
if (bse_CanteenItem.CanteenItem_Charger_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Charger))
{
idb.AddParameter("@CanteenItem_Charger", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Charger", bse_CanteenItem.CanteenItem_Charger);
}
}
if (bse_CanteenItem.CanteenItem_ChargerContact_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_ChargerContact))
{
idb.AddParameter("@CanteenItem_ChargerContact", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_ChargerContact", bse_CanteenItem.CanteenItem_ChargerContact);
}
}
if (bse_CanteenItem.CanteenItem_Remark_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Remark))
{
idb.AddParameter("@CanteenItem_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Remark", bse_CanteenItem.CanteenItem_Remark);
}
}
if (bse_CanteenItem.Stat_IsChanged)
{
if (bse_CanteenItem.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_CanteenItem.Stat);
}
}
if (bse_CanteenItem.CreateDate_IsChanged)
{
if (bse_CanteenItem.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_CanteenItem.CreateDate);
}
}
if (bse_CanteenItem.UpdateDate_IsChanged)
{
if (bse_CanteenItem.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_CanteenItem.UpdateDate);
}
}
if (bse_CanteenItem.DeleteDate_IsChanged)
{
if (bse_CanteenItem.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_CanteenItem.DeleteDate);
}
}
if (bse_CanteenItem.CanteenItem_Company_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Company))
{
idb.AddParameter("@CanteenItem_Company", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Company", bse_CanteenItem.CanteenItem_Company);
}
}
if (bse_CanteenItem.CanteenItem_Department_IsChanged)
{
if (string.IsNullOrEmpty(bse_CanteenItem.CanteenItem_Department))
{
idb.AddParameter("@CanteenItem_Department", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Department", bse_CanteenItem.CanteenItem_Department);
}
}
if (bse_CanteenItem.CanteenItem_Start_IsChanged)
{
if (bse_CanteenItem.CanteenItem_Start == DateTime.MinValue)
{
idb.AddParameter("@CanteenItem_Start", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_Start", bse_CanteenItem.CanteenItem_Start);
}
}
if (bse_CanteenItem.CanteenItem_End_IsChanged)
{
if (bse_CanteenItem.CanteenItem_End == DateTime.MinValue)
{
idb.AddParameter("@CanteenItem_End", DBNull.Value);
}
else
{
idb.AddParameter("@CanteenItem_End", bse_CanteenItem.CanteenItem_End);
}
}
idb.AddParameter("@CanteenItem_ID", bse_CanteenItem.CanteenItem_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加试块信息 TC_Item对象(即:一条记录)
/// </summary>
public int Add(TC_Item tC_Item)
{
string sql = "INSERT INTO TC_Item (TCI_Code,TCI_GroupCode,TCI_No,TCI_VCode,TCI_VName,TCI_Val,TCI_MVal,TCI_Base,TCI_RefValue,TCI_Conclusion,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@TCI_Code,@TCI_GroupCode,@TCI_No,@TCI_VCode,@TCI_VName,@TCI_Val,@TCI_MVal,@TCI_Base,@TCI_RefValue,@TCI_Conclusion,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(tC_Item.TCI_Code))
{
idb.AddParameter("@TCI_Code", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Code", tC_Item.TCI_Code);
}
if (string.IsNullOrEmpty(tC_Item.TCI_GroupCode))
{
idb.AddParameter("@TCI_GroupCode", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_GroupCode", tC_Item.TCI_GroupCode);
}
if (string.IsNullOrEmpty(tC_Item.TCI_No))
{
idb.AddParameter("@TCI_No", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_No", tC_Item.TCI_No);
}
if (string.IsNullOrEmpty(tC_Item.TCI_VCode))
{
idb.AddParameter("@TCI_VCode", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_VCode", tC_Item.TCI_VCode);
}
if (string.IsNullOrEmpty(tC_Item.TCI_VName))
{
idb.AddParameter("@TCI_VName", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_VName", tC_Item.TCI_VName);
}
if (string.IsNullOrEmpty(tC_Item.TCI_Val))
{
idb.AddParameter("@TCI_Val", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Val", tC_Item.TCI_Val);
}
if (string.IsNullOrEmpty(tC_Item.TCI_MVal))
{
idb.AddParameter("@TCI_MVal", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_MVal", tC_Item.TCI_MVal);
}
if (string.IsNullOrEmpty(tC_Item.TCI_Base))
{
idb.AddParameter("@TCI_Base", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Base", tC_Item.TCI_Base);
}
if (string.IsNullOrEmpty(tC_Item.TCI_RefValue))
{
idb.AddParameter("@TCI_RefValue", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_RefValue", tC_Item.TCI_RefValue);
}
if (string.IsNullOrEmpty(tC_Item.TCI_Conclusion))
{
idb.AddParameter("@TCI_Conclusion", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Conclusion", tC_Item.TCI_Conclusion);
}
if (tC_Item.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", tC_Item.Stat);
}
if (tC_Item.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", tC_Item.CreateDate);
}
if (tC_Item.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", tC_Item.UpdateDate);
}
if (tC_Item.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", tC_Item.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新后勤车辆维修记录 Vehicles_Repair对象(即:一条记录
/// </summary>
public int Update(Vehicles_Repair vehicles_Repair)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Vehicles_Repair SET ");
if (vehicles_Repair.VRepair_Code_IsChanged)
{
sbParameter.Append("VRepair_Code=@VRepair_Code, ");
}
if (vehicles_Repair.VRepair_VehiclesNo_IsChanged)
{
sbParameter.Append("VRepair_VehiclesNo=@VRepair_VehiclesNo, ");
}
if (vehicles_Repair.VRepair_VehiclesCode_IsChanged)
{
sbParameter.Append("VRepair_VehiclesCode=@VRepair_VehiclesCode, ");
}
if (vehicles_Repair.VRepair_Date_IsChanged)
{
sbParameter.Append("VRepair_Date=@VRepair_Date, ");
}
if (vehicles_Repair.VRepair_Object_IsChanged)
{
sbParameter.Append("VRepair_Object=@VRepair_Object, ");
}
if (vehicles_Repair.VRepair_Material_IsChanged)
{
sbParameter.Append("VRepair_Material=@VRepair_Material, ");
}
if (vehicles_Repair.VRepair_TimeCost_IsChanged)
{
sbParameter.Append("VRepair_TimeCost=@VRepair_TimeCost, ");
}
if (vehicles_Repair.VRepair_Cost_IsChanged)
{
sbParameter.Append("VRepair_Cost=@VRepair_Cost, ");
}
if (vehicles_Repair.VRepair_Position_IsChanged)
{
sbParameter.Append("VRepair_Position=@VRepair_Position, ");
}
if (vehicles_Repair.VRepair_Operator_IsChanged)
{
sbParameter.Append("VRepair_Operator=@VRepair_Operator, ");
}
if (vehicles_Repair.VRepair_Company_IsChanged)
{
sbParameter.Append("VRepair_Company=@VRepair_Company, ");
}
if (vehicles_Repair.VRepair_Dept_IsChanged)
{
sbParameter.Append("VRepair_Dept=@VRepair_Dept, ");
}
if (vehicles_Repair.VRepair_Remark_IsChanged)
{
sbParameter.Append("VRepair_Remark=@VRepair_Remark, ");
}
if (vehicles_Repair.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (vehicles_Repair.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (vehicles_Repair.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (vehicles_Repair.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (vehicles_Repair.VRepair_itype_IsChanged)
{
sbParameter.Append("VRepair_itype=@VRepair_itype ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and VRepair_ID=@VRepair_ID; ");
string sql = sb.ToString();
if (vehicles_Repair.VRepair_Code_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Code))
{
idb.AddParameter("@VRepair_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Code", vehicles_Repair.VRepair_Code);
}
}
if (vehicles_Repair.VRepair_VehiclesNo_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_VehiclesNo))
{
idb.AddParameter("@VRepair_VehiclesNo", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_VehiclesNo", vehicles_Repair.VRepair_VehiclesNo);
}
}
if (vehicles_Repair.VRepair_VehiclesCode_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_VehiclesCode))
{
idb.AddParameter("@VRepair_VehiclesCode", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_VehiclesCode", vehicles_Repair.VRepair_VehiclesCode);
}
}
if (vehicles_Repair.VRepair_Date_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Date))
{
idb.AddParameter("@VRepair_Date", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Date", vehicles_Repair.VRepair_Date);
}
}
if (vehicles_Repair.VRepair_Object_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Object))
{
idb.AddParameter("@VRepair_Object", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Object", vehicles_Repair.VRepair_Object);
}
}
if (vehicles_Repair.VRepair_Material_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Material))
{
idb.AddParameter("@VRepair_Material", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Material", vehicles_Repair.VRepair_Material);
}
}
if (vehicles_Repair.VRepair_TimeCost_IsChanged)
{
if (vehicles_Repair.VRepair_TimeCost == 0)
{
idb.AddParameter("@VRepair_TimeCost", 0);
}
else
{
idb.AddParameter("@VRepair_TimeCost", vehicles_Repair.VRepair_TimeCost);
}
}
if (vehicles_Repair.VRepair_Cost_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Cost))
{
idb.AddParameter("@VRepair_Cost", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Cost", vehicles_Repair.VRepair_Cost);
}
}
if (vehicles_Repair.VRepair_Position_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Position))
{
idb.AddParameter("@VRepair_Position", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Position", vehicles_Repair.VRepair_Position);
}
}
if (vehicles_Repair.VRepair_Operator_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Operator))
{
idb.AddParameter("@VRepair_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Operator", vehicles_Repair.VRepair_Operator);
}
}
if (vehicles_Repair.VRepair_Company_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Company))
{
idb.AddParameter("@VRepair_Company", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Company", vehicles_Repair.VRepair_Company);
}
}
if (vehicles_Repair.VRepair_Dept_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Dept))
{
idb.AddParameter("@VRepair_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Dept", vehicles_Repair.VRepair_Dept);
}
}
if (vehicles_Repair.VRepair_Remark_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_Remark))
{
idb.AddParameter("@VRepair_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_Remark", vehicles_Repair.VRepair_Remark);
}
}
if (vehicles_Repair.Stat_IsChanged)
{
if (vehicles_Repair.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", vehicles_Repair.Stat);
}
}
if (vehicles_Repair.CreateDate_IsChanged)
{
if (vehicles_Repair.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", vehicles_Repair.CreateDate);
}
}
if (vehicles_Repair.UpdateDate_IsChanged)
{
if (vehicles_Repair.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", vehicles_Repair.UpdateDate);
}
}
if (vehicles_Repair.DeleteDate_IsChanged)
{
if (vehicles_Repair.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", vehicles_Repair.DeleteDate);
}
}
if (vehicles_Repair.VRepair_itype_IsChanged)
{
if (string.IsNullOrEmpty(vehicles_Repair.VRepair_itype))
{
idb.AddParameter("@VRepair_itype", DBNull.Value);
}
else
{
idb.AddParameter("@VRepair_itype", vehicles_Repair.VRepair_itype);
}
}
idb.AddParameter("@VRepair_ID", vehicles_Repair.VRepair_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新试块信息 TC_Item对象(即:一条记录
/// </summary>
public int Update(TC_Item tC_Item)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE TC_Item SET ");
if (tC_Item.TCI_Code_IsChanged)
{
sbParameter.Append("TCI_Code=@TCI_Code, ");
}
if (tC_Item.TCI_GroupCode_IsChanged)
{
sbParameter.Append("TCI_GroupCode=@TCI_GroupCode, ");
}
if (tC_Item.TCI_No_IsChanged)
{
sbParameter.Append("TCI_No=@TCI_No, ");
}
if (tC_Item.TCI_VCode_IsChanged)
{
sbParameter.Append("TCI_VCode=@TCI_VCode, ");
}
if (tC_Item.TCI_VName_IsChanged)
{
sbParameter.Append("TCI_VName=@TCI_VName, ");
}
if (tC_Item.TCI_Val_IsChanged)
{
sbParameter.Append("TCI_Val=@TCI_Val, ");
}
if (tC_Item.TCI_MVal_IsChanged)
{
sbParameter.Append("TCI_MVal=@TCI_MVal, ");
}
if (tC_Item.TCI_Base_IsChanged)
{
sbParameter.Append("TCI_Base=@TCI_Base, ");
}
if (tC_Item.TCI_RefValue_IsChanged)
{
sbParameter.Append("TCI_RefValue=@TCI_RefValue, ");
}
if (tC_Item.TCI_Conclusion_IsChanged)
{
sbParameter.Append("TCI_Conclusion=@TCI_Conclusion, ");
}
if (tC_Item.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (tC_Item.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (tC_Item.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (tC_Item.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and TCI_ID=@TCI_ID; ");
string sql = sb.ToString();
if (tC_Item.TCI_Code_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_Code))
{
idb.AddParameter("@TCI_Code", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Code", tC_Item.TCI_Code);
}
}
if (tC_Item.TCI_GroupCode_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_GroupCode))
{
idb.AddParameter("@TCI_GroupCode", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_GroupCode", tC_Item.TCI_GroupCode);
}
}
if (tC_Item.TCI_No_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_No))
{
idb.AddParameter("@TCI_No", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_No", tC_Item.TCI_No);
}
}
if (tC_Item.TCI_VCode_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_VCode))
{
idb.AddParameter("@TCI_VCode", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_VCode", tC_Item.TCI_VCode);
}
}
if (tC_Item.TCI_VName_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_VName))
{
idb.AddParameter("@TCI_VName", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_VName", tC_Item.TCI_VName);
}
}
if (tC_Item.TCI_Val_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_Val))
{
idb.AddParameter("@TCI_Val", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Val", tC_Item.TCI_Val);
}
}
if (tC_Item.TCI_MVal_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_MVal))
{
idb.AddParameter("@TCI_MVal", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_MVal", tC_Item.TCI_MVal);
}
}
if (tC_Item.TCI_Base_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_Base))
{
idb.AddParameter("@TCI_Base", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Base", tC_Item.TCI_Base);
}
}
if (tC_Item.TCI_RefValue_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_RefValue))
{
idb.AddParameter("@TCI_RefValue", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_RefValue", tC_Item.TCI_RefValue);
}
}
if (tC_Item.TCI_Conclusion_IsChanged)
{
if (string.IsNullOrEmpty(tC_Item.TCI_Conclusion))
{
idb.AddParameter("@TCI_Conclusion", DBNull.Value);
}
else
{
idb.AddParameter("@TCI_Conclusion", tC_Item.TCI_Conclusion);
}
}
if (tC_Item.Stat_IsChanged)
{
if (tC_Item.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", tC_Item.Stat);
}
}
if (tC_Item.CreateDate_IsChanged)
{
if (tC_Item.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", tC_Item.CreateDate);
}
}
if (tC_Item.UpdateDate_IsChanged)
{
if (tC_Item.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", tC_Item.UpdateDate);
}
}
if (tC_Item.DeleteDate_IsChanged)
{
if (tC_Item.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", tC_Item.DeleteDate);
}
}
idb.AddParameter("@TCI_ID", tC_Item.TCI_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新设备信息 Equ_Information对象(即:一条记录
/// </summary>
public int Update(Equ_Information equ_Information)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Equ_Information SET ");
if (equ_Information.EquInfo_SupCode_IsChanged)
{
sbParameter.Append("EquInfo_SupCode=@EquInfo_SupCode, ");
}
if (equ_Information.EquInfo_Code_IsChanged)
{
sbParameter.Append("EquInfo_Code=@EquInfo_Code, ");
}
if (equ_Information.EquInfo_Name_IsChanged)
{
sbParameter.Append("EquInfo_Name=@EquInfo_Name, ");
}
if (equ_Information.EquInfo_ICode_IsChanged)
{
sbParameter.Append("EquInfo_ICode=@EquInfo_ICode, ");
}
if (equ_Information.EquInfo_TCode_IsChanged)
{
sbParameter.Append("EquInfo_TCode=@EquInfo_TCode, ");
}
if (equ_Information.EquInfo_Spec_IsChanged)
{
sbParameter.Append("EquInfo_Spec=@EquInfo_Spec, ");
}
if (equ_Information.EquInfo_Manu_IsChanged)
{
sbParameter.Append("EquInfo_Manu=@EquInfo_Manu, ");
}
if (equ_Information.EquInfo_DeptCode_IsChanged)
{
sbParameter.Append("EquInfo_DeptCode=@EquInfo_DeptCode, ");
}
if (equ_Information.EquInfo_DeptName_IsChanged)
{
sbParameter.Append("EquInfo_DeptName=@EquInfo_DeptName, ");
}
if (equ_Information.EquInfo_PartInfo_IsChanged)
{
sbParameter.Append("EquInfo_PartInfo=@EquInfo_PartInfo, ");
}
if (equ_Information.EquInfo_TechInfo_IsChanged)
{
sbParameter.Append("EquInfo_TechInfo=@EquInfo_TechInfo, ");
}
if (equ_Information.EquInfo_TechVar_IsChanged)
{
sbParameter.Append("EquInfo_TechVar=@EquInfo_TechVar, ");
}
if (equ_Information.EquInfo_Addr_IsChanged)
{
sbParameter.Append("EquInfo_Addr=@EquInfo_Addr, ");
}
if (equ_Information.EquInfo_Type_IsChanged)
{
sbParameter.Append("EquInfo_Type=@EquInfo_Type, ");
}
if (equ_Information.EquInfo_CCode_IsChanged)
{
sbParameter.Append("EquInfo_CCode=@EquInfo_CCode, ");
}
if (equ_Information.EquInfo_Cost_IsChanged)
{
sbParameter.Append("EquInfo_Cost=@EquInfo_Cost, ");
}
if (equ_Information.EquInfo_IsFix_IsChanged)
{
sbParameter.Append("EquInfo_IsFix=@EquInfo_IsFix, ");
}
if (equ_Information.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and EquInfo_ID=@EquInfo_ID; ");
string sql = sb.ToString();
if (equ_Information.EquInfo_SupCode_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_SupCode))
{
idb.AddParameter("@EquInfo_SupCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_SupCode", equ_Information.EquInfo_SupCode);
}
}
if (equ_Information.EquInfo_Code_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_Code))
{
idb.AddParameter("@EquInfo_Code", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Code", equ_Information.EquInfo_Code);
}
}
if (equ_Information.EquInfo_Name_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_Name))
{
idb.AddParameter("@EquInfo_Name", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Name", equ_Information.EquInfo_Name);
}
}
if (equ_Information.EquInfo_ICode_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_ICode))
{
idb.AddParameter("@EquInfo_ICode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_ICode", equ_Information.EquInfo_ICode);
}
}
if (equ_Information.EquInfo_TCode_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_TCode))
{
idb.AddParameter("@EquInfo_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_TCode", equ_Information.EquInfo_TCode);
}
}
if (equ_Information.EquInfo_Spec_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_Spec))
{
idb.AddParameter("@EquInfo_Spec", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Spec", equ_Information.EquInfo_Spec);
}
}
if (equ_Information.EquInfo_Manu_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_Manu))
{
idb.AddParameter("@EquInfo_Manu", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Manu", equ_Information.EquInfo_Manu);
}
}
if (equ_Information.EquInfo_DeptCode_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_DeptCode))
{
idb.AddParameter("@EquInfo_DeptCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_DeptCode", equ_Information.EquInfo_DeptCode);
}
}
if (equ_Information.EquInfo_DeptName_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_DeptName))
{
idb.AddParameter("@EquInfo_DeptName", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_DeptName", equ_Information.EquInfo_DeptName);
}
}
if (equ_Information.EquInfo_PartInfo_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_PartInfo))
{
idb.AddParameter("@EquInfo_PartInfo", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_PartInfo", equ_Information.EquInfo_PartInfo);
}
}
if (equ_Information.EquInfo_TechInfo_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_TechInfo))
{
idb.AddParameter("@EquInfo_TechInfo", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_TechInfo", equ_Information.EquInfo_TechInfo);
}
}
if (equ_Information.EquInfo_TechVar_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_TechVar))
{
idb.AddParameter("@EquInfo_TechVar", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_TechVar", equ_Information.EquInfo_TechVar);
}
}
if (equ_Information.EquInfo_Addr_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_Addr))
{
idb.AddParameter("@EquInfo_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Addr", equ_Information.EquInfo_Addr);
}
}
if (equ_Information.EquInfo_Type_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_Type))
{
idb.AddParameter("@EquInfo_Type", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_Type", equ_Information.EquInfo_Type);
}
}
if (equ_Information.EquInfo_CCode_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_CCode))
{
idb.AddParameter("@EquInfo_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_CCode", equ_Information.EquInfo_CCode);
}
}
if (equ_Information.EquInfo_Cost_IsChanged)
{
if (equ_Information.EquInfo_Cost == 0)
{
idb.AddParameter("@EquInfo_Cost", 0);
}
else
{
idb.AddParameter("@EquInfo_Cost", equ_Information.EquInfo_Cost);
}
}
if (equ_Information.EquInfo_IsFix_IsChanged)
{
if (string.IsNullOrEmpty(equ_Information.EquInfo_IsFix))
{
idb.AddParameter("@EquInfo_IsFix", DBNull.Value);
}
else
{
idb.AddParameter("@EquInfo_IsFix", equ_Information.EquInfo_IsFix);
}
}
if (equ_Information.Stat_IsChanged)
{
if (equ_Information.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", equ_Information.Stat);
}
}
idb.AddParameter("@EquInfo_ID", equ_Information.EquInfo_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加生产线关联仓库 PC_BWarehouse对象(即:一条记录)
/// </summary>
public int Add(PC_BWarehouse pC_BWarehouse)
{
string sql = "INSERT INTO PC_BWarehouse (PCBW_Code,PCBW_LCode,PCBW_RefWCode,PCBW_WNo,PCBW_MCode,PCBW_MName,PCBW_Contain,PCBW_Order,PCBW_Bak,PCBW_TCode,PCBW_TName,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@PCBW_Code,@PCBW_LCode,@PCBW_RefWCode,@PCBW_WNo,@PCBW_MCode,@PCBW_MName,@PCBW_Contain,@PCBW_Order,@PCBW_Bak,@PCBW_TCode,@PCBW_TName,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_Code))
{
idb.AddParameter("@PCBW_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_Code", pC_BWarehouse.PCBW_Code);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_LCode))
{
idb.AddParameter("@PCBW_LCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_LCode", pC_BWarehouse.PCBW_LCode);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_RefWCode))
{
idb.AddParameter("@PCBW_RefWCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_RefWCode", pC_BWarehouse.PCBW_RefWCode);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_WNo))
{
idb.AddParameter("@PCBW_WNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_WNo", pC_BWarehouse.PCBW_WNo);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_MCode))
{
idb.AddParameter("@PCBW_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_MCode", pC_BWarehouse.PCBW_MCode);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_MName))
{
idb.AddParameter("@PCBW_MName", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_MName", pC_BWarehouse.PCBW_MName);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_Contain))
{
idb.AddParameter("@PCBW_Contain", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_Contain", pC_BWarehouse.PCBW_Contain);
}
if (pC_BWarehouse.PCBW_Order == 0)
{
idb.AddParameter("@PCBW_Order", 0);
}
else
{
idb.AddParameter("@PCBW_Order", pC_BWarehouse.PCBW_Order);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_Bak))
{
idb.AddParameter("@PCBW_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_Bak", pC_BWarehouse.PCBW_Bak);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_TCode))
{
idb.AddParameter("@PCBW_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_TCode", pC_BWarehouse.PCBW_TCode);
}
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_TName))
{
idb.AddParameter("@PCBW_TName", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_TName", pC_BWarehouse.PCBW_TName);
}
if (pC_BWarehouse.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_BWarehouse.Stat);
}
if (pC_BWarehouse.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_BWarehouse.CreateDate);
}
if (pC_BWarehouse.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_BWarehouse.UpdateDate);
}
if (pC_BWarehouse.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_BWarehouse.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新TC_RTemplate对象(即:一条记录
/// </summary>
public int Update(TC_RTemplate tC_RTemplate)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE TC_RTemplate SET ");
if (tC_RTemplate.TCRT_Code_IsChanged)
{
sbParameter.Append("TCRT_Code=@TCRT_Code, ");
}
if (tC_RTemplate.TCRT_Name_IsChanged)
{
sbParameter.Append("TCRT_Name=@TCRT_Name, ");
}
if (tC_RTemplate.TCRT_Type_IsChanged)
{
sbParameter.Append("TCRT_Type=@TCRT_Type, ");
}
if (tC_RTemplate.TCRT_Stat_IsChanged)
{
sbParameter.Append("TCRT_Stat=@TCRT_Stat, ");
}
if (tC_RTemplate.TCRT_iType_IsChanged)
{
sbParameter.Append("TCRT_iType=@TCRT_iType, ");
}
if (tC_RTemplate.TCRT_Operator_IsChanged)
{
sbParameter.Append("TCRT_Operator=@TCRT_Operator, ");
}
if (tC_RTemplate.TCRT_OpDate_IsChanged)
{
sbParameter.Append("TCRT_OpDate=@TCRT_OpDate, ");
}
if (tC_RTemplate.TCRT_Remark_IsChanged)
{
sbParameter.Append("TCRT_Remark=@TCRT_Remark, ");
}
if (tC_RTemplate.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (tC_RTemplate.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (tC_RTemplate.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (tC_RTemplate.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and TCRT_ID=@TCRT_ID; ");
string sql = sb.ToString();
if (tC_RTemplate.TCRT_Code_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Code))
{
idb.AddParameter("@TCRT_Code", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Code", tC_RTemplate.TCRT_Code);
}
}
if (tC_RTemplate.TCRT_Name_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Name))
{
idb.AddParameter("@TCRT_Name", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Name", tC_RTemplate.TCRT_Name);
}
}
if (tC_RTemplate.TCRT_Type_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Type))
{
idb.AddParameter("@TCRT_Type", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Type", tC_RTemplate.TCRT_Type);
}
}
if (tC_RTemplate.TCRT_Stat_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Stat))
{
idb.AddParameter("@TCRT_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Stat", tC_RTemplate.TCRT_Stat);
}
}
if (tC_RTemplate.TCRT_iType_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_iType))
{
idb.AddParameter("@TCRT_iType", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_iType", tC_RTemplate.TCRT_iType);
}
}
if (tC_RTemplate.TCRT_Operator_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Operator))
{
idb.AddParameter("@TCRT_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Operator", tC_RTemplate.TCRT_Operator);
}
}
if (tC_RTemplate.TCRT_OpDate_IsChanged)
{
if (tC_RTemplate.TCRT_OpDate == DateTime.MinValue)
{
idb.AddParameter("@TCRT_OpDate", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_OpDate", tC_RTemplate.TCRT_OpDate);
}
}
if (tC_RTemplate.TCRT_Remark_IsChanged)
{
if (string.IsNullOrEmpty(tC_RTemplate.TCRT_Remark))
{
idb.AddParameter("@TCRT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@TCRT_Remark", tC_RTemplate.TCRT_Remark);
}
}
if (tC_RTemplate.Stat_IsChanged)
{
if (tC_RTemplate.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", tC_RTemplate.Stat);
}
}
if (tC_RTemplate.CreateDate_IsChanged)
{
if (tC_RTemplate.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", tC_RTemplate.CreateDate);
}
}
if (tC_RTemplate.UpdateDate_IsChanged)
{
if (tC_RTemplate.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", tC_RTemplate.UpdateDate);
}
}
if (tC_RTemplate.DeleteDate_IsChanged)
{
if (tC_RTemplate.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", tC_RTemplate.DeleteDate);
}
}
idb.AddParameter("@TCRT_ID", tC_RTemplate.TCRT_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新生产线关联仓库 PC_BWarehouse对象(即:一条记录
/// </summary>
public int Update(PC_BWarehouse pC_BWarehouse)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE PC_BWarehouse SET ");
if (pC_BWarehouse.PCBW_Code_IsChanged)
{
sbParameter.Append("PCBW_Code=@PCBW_Code, ");
}
if (pC_BWarehouse.PCBW_LCode_IsChanged)
{
sbParameter.Append("PCBW_LCode=@PCBW_LCode, ");
}
if (pC_BWarehouse.PCBW_RefWCode_IsChanged)
{
sbParameter.Append("PCBW_RefWCode=@PCBW_RefWCode, ");
}
if (pC_BWarehouse.PCBW_WNo_IsChanged)
{
sbParameter.Append("PCBW_WNo=@PCBW_WNo, ");
}
if (pC_BWarehouse.PCBW_MCode_IsChanged)
{
sbParameter.Append("PCBW_MCode=@PCBW_MCode, ");
}
if (pC_BWarehouse.PCBW_MName_IsChanged)
{
sbParameter.Append("PCBW_MName=@PCBW_MName, ");
}
if (pC_BWarehouse.PCBW_Contain_IsChanged)
{
sbParameter.Append("PCBW_Contain=@PCBW_Contain, ");
}
if (pC_BWarehouse.PCBW_Order_IsChanged)
{
sbParameter.Append("PCBW_Order=@PCBW_Order, ");
}
if (pC_BWarehouse.PCBW_Bak_IsChanged)
{
sbParameter.Append("PCBW_Bak=@PCBW_Bak, ");
}
if (pC_BWarehouse.PCBW_TCode_IsChanged)
{
sbParameter.Append("PCBW_TCode=@PCBW_TCode, ");
}
if (pC_BWarehouse.PCBW_TName_IsChanged)
{
sbParameter.Append("PCBW_TName=@PCBW_TName, ");
}
if (pC_BWarehouse.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (pC_BWarehouse.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (pC_BWarehouse.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (pC_BWarehouse.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PCBW_ID=@PCBW_ID; ");
string sql = sb.ToString();
if (pC_BWarehouse.PCBW_Code_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_Code))
{
idb.AddParameter("@PCBW_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_Code", pC_BWarehouse.PCBW_Code);
}
}
if (pC_BWarehouse.PCBW_LCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_LCode))
{
idb.AddParameter("@PCBW_LCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_LCode", pC_BWarehouse.PCBW_LCode);
}
}
if (pC_BWarehouse.PCBW_RefWCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_RefWCode))
{
idb.AddParameter("@PCBW_RefWCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_RefWCode", pC_BWarehouse.PCBW_RefWCode);
}
}
if (pC_BWarehouse.PCBW_WNo_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_WNo))
{
idb.AddParameter("@PCBW_WNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_WNo", pC_BWarehouse.PCBW_WNo);
}
}
if (pC_BWarehouse.PCBW_MCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_MCode))
{
idb.AddParameter("@PCBW_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_MCode", pC_BWarehouse.PCBW_MCode);
}
}
if (pC_BWarehouse.PCBW_MName_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_MName))
{
idb.AddParameter("@PCBW_MName", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_MName", pC_BWarehouse.PCBW_MName);
}
}
if (pC_BWarehouse.PCBW_Contain_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_Contain))
{
idb.AddParameter("@PCBW_Contain", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_Contain", pC_BWarehouse.PCBW_Contain);
}
}
if (pC_BWarehouse.PCBW_Order_IsChanged)
{
if (pC_BWarehouse.PCBW_Order == 0)
{
idb.AddParameter("@PCBW_Order", 0);
}
else
{
idb.AddParameter("@PCBW_Order", pC_BWarehouse.PCBW_Order);
}
}
if (pC_BWarehouse.PCBW_Bak_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_Bak))
{
idb.AddParameter("@PCBW_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_Bak", pC_BWarehouse.PCBW_Bak);
}
}
if (pC_BWarehouse.PCBW_TCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_TCode))
{
idb.AddParameter("@PCBW_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_TCode", pC_BWarehouse.PCBW_TCode);
}
}
if (pC_BWarehouse.PCBW_TName_IsChanged)
{
if (string.IsNullOrEmpty(pC_BWarehouse.PCBW_TName))
{
idb.AddParameter("@PCBW_TName", DBNull.Value);
}
else
{
idb.AddParameter("@PCBW_TName", pC_BWarehouse.PCBW_TName);
}
}
if (pC_BWarehouse.Stat_IsChanged)
{
if (pC_BWarehouse.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_BWarehouse.Stat);
}
}
if (pC_BWarehouse.CreateDate_IsChanged)
{
if (pC_BWarehouse.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_BWarehouse.CreateDate);
}
}
if (pC_BWarehouse.UpdateDate_IsChanged)
{
if (pC_BWarehouse.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_BWarehouse.UpdateDate);
}
}
if (pC_BWarehouse.DeleteDate_IsChanged)
{
if (pC_BWarehouse.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_BWarehouse.DeleteDate);
}
}
idb.AddParameter("@PCBW_ID", pC_BWarehouse.PCBW_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新应付单 WH_Payable对象(即:一条记录
/// </summary>
public int Update(WH_Payable wH_Payable)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE WH_Payable SET ");
if (wH_Payable.WHP_Code_IsChanged)
{
sbParameter.Append("WHP_Code=@WHP_Code, ");
}
if (wH_Payable.WHP_SCode_IsChanged)
{
sbParameter.Append("WHP_SCode=@WHP_SCode, ");
}
if (wH_Payable.WHP_SName_IsChanged)
{
sbParameter.Append("WHP_SName=@WHP_SName, ");
}
if (wH_Payable.WHP_Period_IsChanged)
{
sbParameter.Append("WHP_Period=@WHP_Period, ");
}
if (wH_Payable.WHP_LSum_IsChanged)
{
sbParameter.Append("WHP_LSum=@WHP_LSum, ");
}
if (wH_Payable.WHP_CSum_IsChanged)
{
sbParameter.Append("WHP_CSum=@WHP_CSum, ");
}
if (wH_Payable.WHP_CLeft_IsChanged)
{
sbParameter.Append("WHP_CLeft=@WHP_CLeft, ");
}
if (wH_Payable.WHP_IsDone_IsChanged)
{
sbParameter.Append("WHP_IsDone=@WHP_IsDone, ");
}
if (wH_Payable.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (wH_Payable.WHP_IsDate_IsChanged)
{
sbParameter.Append("WHP_IsDate=@WHP_IsDate, ");
}
if (wH_Payable.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (wH_Payable.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (wH_Payable.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (wH_Payable.WHP_UCompany_IsChanged)
{
sbParameter.Append("WHP_UCompany=@WHP_UCompany, ");
}
if (wH_Payable.WHP_UCompanyCode_IsChanged)
{
sbParameter.Append("WHP_UCompanyCode=@WHP_UCompanyCode, ");
}
if (wH_Payable.WHP_broom_IsChanged)
{
sbParameter.Append("WHP_broom=@WHP_broom ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and WHP_ID=@WHP_ID; ");
string sql = sb.ToString();
if (wH_Payable.WHP_Code_IsChanged)
{
if (string.IsNullOrEmpty(wH_Payable.WHP_Code))
{
idb.AddParameter("@WHP_Code", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_Code", wH_Payable.WHP_Code);
}
}
if (wH_Payable.WHP_SCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_Payable.WHP_SCode))
{
idb.AddParameter("@WHP_SCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_SCode", wH_Payable.WHP_SCode);
}
}
if (wH_Payable.WHP_SName_IsChanged)
{
if (string.IsNullOrEmpty(wH_Payable.WHP_SName))
{
idb.AddParameter("@WHP_SName", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_SName", wH_Payable.WHP_SName);
}
}
if (wH_Payable.WHP_Period_IsChanged)
{
if (string.IsNullOrEmpty(wH_Payable.WHP_Period))
{
idb.AddParameter("@WHP_Period", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_Period", wH_Payable.WHP_Period);
}
}
if (wH_Payable.WHP_LSum_IsChanged)
{
if (wH_Payable.WHP_LSum == 0)
{
idb.AddParameter("@WHP_LSum", 0);
}
else
{
idb.AddParameter("@WHP_LSum", wH_Payable.WHP_LSum);
}
}
if (wH_Payable.WHP_CSum_IsChanged)
{
if (wH_Payable.WHP_CSum == 0)
{
idb.AddParameter("@WHP_CSum", 0);
}
else
{
idb.AddParameter("@WHP_CSum", wH_Payable.WHP_CSum);
}
}
if (wH_Payable.WHP_CLeft_IsChanged)
{
if (wH_Payable.WHP_CLeft == 0)
{
idb.AddParameter("@WHP_CLeft", 0);
}
else
{
idb.AddParameter("@WHP_CLeft", wH_Payable.WHP_CLeft);
}
}
if (wH_Payable.WHP_IsDone_IsChanged)
{
if (wH_Payable.WHP_IsDone == 0)
{
idb.AddParameter("@WHP_IsDone", 0);
}
else
{
idb.AddParameter("@WHP_IsDone", wH_Payable.WHP_IsDone);
}
}
if (wH_Payable.Stat_IsChanged)
{
if (wH_Payable.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_Payable.Stat);
}
}
if (wH_Payable.WHP_IsDate_IsChanged)
{
if (wH_Payable.WHP_IsDate == DateTime.MinValue)
{
idb.AddParameter("@WHP_IsDate", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_IsDate", wH_Payable.WHP_IsDate);
}
}
if (wH_Payable.CreateDate_IsChanged)
{
if (wH_Payable.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_Payable.CreateDate);
}
}
if (wH_Payable.UpdateDate_IsChanged)
{
if (wH_Payable.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_Payable.UpdateDate);
}
}
if (wH_Payable.DeleteDate_IsChanged)
{
if (wH_Payable.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_Payable.DeleteDate);
}
}
if (wH_Payable.WHP_UCompany_IsChanged)
{
if (string.IsNullOrEmpty(wH_Payable.WHP_UCompany))
{
idb.AddParameter("@WHP_UCompany", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_UCompany", wH_Payable.WHP_UCompany);
}
}
if (wH_Payable.WHP_UCompanyCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_Payable.WHP_UCompanyCode))
{
idb.AddParameter("@WHP_UCompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHP_UCompanyCode", wH_Payable.WHP_UCompanyCode);
}
}
if (wH_Payable.WHP_broom_IsChanged)
{
if (wH_Payable.WHP_broom == 0)
{
idb.AddParameter("@WHP_broom", 0);
}
else
{
idb.AddParameter("@WHP_broom", wH_Payable.WHP_broom);
}
}
idb.AddParameter("@WHP_ID", wH_Payable.WHP_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加工作服领用记录 Work_Recipients对象(即:一条记录)
/// </summary>
public int Add(Work_Recipients work_Recipients)
{
string sql = "INSERT INTO Work_Recipients (WRecipients_Code,WRecipients_Date,WRecipients_Duty,WRecipients_Name,WRecipients_Gender,WRecipients_Model,WRecipients_Num,WRecipients_Company,WRecipients_Dept,WRecipients_Operator,WRecipients_Remark,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@WRecipients_Code,@WRecipients_Date,@WRecipients_Duty,@WRecipients_Name,@WRecipients_Gender,@WRecipients_Model,@WRecipients_Num,@WRecipients_Company,@WRecipients_Dept,@WRecipients_Operator,@WRecipients_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Code))
{
idb.AddParameter("@WRecipients_Code", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Code", work_Recipients.WRecipients_Code);
}
if (work_Recipients.WRecipients_Date == DateTime.MinValue)
{
idb.AddParameter("@WRecipients_Date", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Date", work_Recipients.WRecipients_Date);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Duty))
{
idb.AddParameter("@WRecipients_Duty", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Duty", work_Recipients.WRecipients_Duty);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Name))
{
idb.AddParameter("@WRecipients_Name", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Name", work_Recipients.WRecipients_Name);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Gender))
{
idb.AddParameter("@WRecipients_Gender", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Gender", work_Recipients.WRecipients_Gender);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Model))
{
idb.AddParameter("@WRecipients_Model", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Model", work_Recipients.WRecipients_Model);
}
if (work_Recipients.WRecipients_Num == 0)
{
idb.AddParameter("@WRecipients_Num", 0);
}
else
{
idb.AddParameter("@WRecipients_Num", work_Recipients.WRecipients_Num);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Company))
{
idb.AddParameter("@WRecipients_Company", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Company", work_Recipients.WRecipients_Company);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Dept))
{
idb.AddParameter("@WRecipients_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Dept", work_Recipients.WRecipients_Dept);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Operator))
{
idb.AddParameter("@WRecipients_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Operator", work_Recipients.WRecipients_Operator);
}
if (string.IsNullOrEmpty(work_Recipients.WRecipients_Remark))
{
idb.AddParameter("@WRecipients_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@WRecipients_Remark", work_Recipients.WRecipients_Remark);
}
if (work_Recipients.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", work_Recipients.Stat);
}
if (work_Recipients.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", work_Recipients.CreateDate);
}
if (work_Recipients.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", work_Recipients.UpdateDate);
}
if (work_Recipients.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", work_Recipients.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新食堂物资记录 CanteenItem_Record对象(即:一条记录
/// </summary>
public int Update(CanteenItem_Record canteenItem_Record)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE CanteenItem_Record SET ");
if (canteenItem_Record.CIR_Code_IsChanged)
{
sbParameter.Append("CIR_Code=@CIR_Code, ");
}
if (canteenItem_Record.CIR_Name_IsChanged)
{
sbParameter.Append("CIR_Name=@CIR_Name, ");
}
if (canteenItem_Record.CIR_Model_IsChanged)
{
sbParameter.Append("CIR_Model=@CIR_Model, ");
}
if (canteenItem_Record.CIR_CanteenItemCode_IsChanged)
{
sbParameter.Append("CIR_CanteenItemCode=@CIR_CanteenItemCode, ");
}
if (canteenItem_Record.CIR_Date_IsChanged)
{
sbParameter.Append("CIR_Date=@CIR_Date, ");
}
if (canteenItem_Record.CIR_Money_IsChanged)
{
sbParameter.Append("CIR_Money=@CIR_Money, ");
}
if (canteenItem_Record.CIR_Remark_IsChanged)
{
sbParameter.Append("CIR_Remark=@CIR_Remark, ");
}
if (canteenItem_Record.CIR_Company_IsChanged)
{
sbParameter.Append("CIR_Company=@CIR_Company, ");
}
if (canteenItem_Record.CIR_Dept_IsChanged)
{
sbParameter.Append("CIR_Dept=@CIR_Dept, ");
}
if (canteenItem_Record.CIR_Num_IsChanged)
{
sbParameter.Append("CIR_Num=@CIR_Num, ");
}
if (canteenItem_Record.CIR_Price_IsChanged)
{
sbParameter.Append("CIR_Price=@CIR_Price, ");
}
if (canteenItem_Record.CIR_Unit_IsChanged)
{
sbParameter.Append("CIR_Unit=@CIR_Unit, ");
}
if (canteenItem_Record.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (canteenItem_Record.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (canteenItem_Record.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (canteenItem_Record.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CIR_ID=@CIR_ID; ");
string sql = sb.ToString();
if (canteenItem_Record.CIR_Code_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Code))
{
idb.AddParameter("@CIR_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Code", canteenItem_Record.CIR_Code);
}
}
if (canteenItem_Record.CIR_Name_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Name))
{
idb.AddParameter("@CIR_Name", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Name", canteenItem_Record.CIR_Name);
}
}
if (canteenItem_Record.CIR_Model_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Model))
{
idb.AddParameter("@CIR_Model", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Model", canteenItem_Record.CIR_Model);
}
}
if (canteenItem_Record.CIR_CanteenItemCode_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_CanteenItemCode))
{
idb.AddParameter("@CIR_CanteenItemCode", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_CanteenItemCode", canteenItem_Record.CIR_CanteenItemCode);
}
}
if (canteenItem_Record.CIR_Date_IsChanged)
{
if (canteenItem_Record.CIR_Date == DateTime.MinValue)
{
idb.AddParameter("@CIR_Date", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Date", canteenItem_Record.CIR_Date);
}
}
if (canteenItem_Record.CIR_Money_IsChanged)
{
if (canteenItem_Record.CIR_Money == 0)
{
idb.AddParameter("@CIR_Money", 0);
}
else
{
idb.AddParameter("@CIR_Money", canteenItem_Record.CIR_Money);
}
}
if (canteenItem_Record.CIR_Remark_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Remark))
{
idb.AddParameter("@CIR_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Remark", canteenItem_Record.CIR_Remark);
}
}
if (canteenItem_Record.CIR_Company_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Company))
{
idb.AddParameter("@CIR_Company", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Company", canteenItem_Record.CIR_Company);
}
}
if (canteenItem_Record.CIR_Dept_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Dept))
{
idb.AddParameter("@CIR_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Dept", canteenItem_Record.CIR_Dept);
}
}
if (canteenItem_Record.CIR_Num_IsChanged)
{
if (canteenItem_Record.CIR_Num == 0)
{
idb.AddParameter("@CIR_Num", 0);
}
else
{
idb.AddParameter("@CIR_Num", canteenItem_Record.CIR_Num);
}
}
if (canteenItem_Record.CIR_Price_IsChanged)
{
if (canteenItem_Record.CIR_Price == 0)
{
idb.AddParameter("@CIR_Price", 0);
}
else
{
idb.AddParameter("@CIR_Price", canteenItem_Record.CIR_Price);
}
}
if (canteenItem_Record.CIR_Unit_IsChanged)
{
if (string.IsNullOrEmpty(canteenItem_Record.CIR_Unit))
{
idb.AddParameter("@CIR_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@CIR_Unit", canteenItem_Record.CIR_Unit);
}
}
if (canteenItem_Record.Stat_IsChanged)
{
if (canteenItem_Record.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", canteenItem_Record.Stat);
}
}
if (canteenItem_Record.CreateDate_IsChanged)
{
if (canteenItem_Record.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", canteenItem_Record.CreateDate);
}
}
if (canteenItem_Record.UpdateDate_IsChanged)
{
if (canteenItem_Record.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", canteenItem_Record.UpdateDate);
}
}
if (canteenItem_Record.DeleteDate_IsChanged)
{
if (canteenItem_Record.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", canteenItem_Record.DeleteDate);
}
}
idb.AddParameter("@CIR_ID", canteenItem_Record.CIR_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加5S环保处罚记录 SEP_Record对象(即:一条记录)
/// </summary>
public int Add(SEP_Record sEP_Record)
{
string sql = "INSERT INTO SEP_Record (SEPRecord_Code,SEPRecord_Date,SEPRecord_Event,SEPRecord_Content,SEPRecord_Result,SEPRecord_Type,SEPRecord_Remark,SEPRecordCompany,SEPRecord_Dept,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@SEPRecord_Code,@SEPRecord_Date,@SEPRecord_Event,@SEPRecord_Content,@SEPRecord_Result,@SEPRecord_Type,@SEPRecord_Remark,@SEPRecordCompany,@SEPRecord_Dept,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Code))
{
idb.AddParameter("@SEPRecord_Code", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Code", sEP_Record.SEPRecord_Code);
}
if (sEP_Record.SEPRecord_Date == DateTime.MinValue)
{
idb.AddParameter("@SEPRecord_Date", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Date", sEP_Record.SEPRecord_Date);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Event))
{
idb.AddParameter("@SEPRecord_Event", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Event", sEP_Record.SEPRecord_Event);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Content))
{
idb.AddParameter("@SEPRecord_Content", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Content", sEP_Record.SEPRecord_Content);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Result))
{
idb.AddParameter("@SEPRecord_Result", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Result", sEP_Record.SEPRecord_Result);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Type))
{
idb.AddParameter("@SEPRecord_Type", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Type", sEP_Record.SEPRecord_Type);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Remark))
{
idb.AddParameter("@SEPRecord_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Remark", sEP_Record.SEPRecord_Remark);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecordCompany))
{
idb.AddParameter("@SEPRecordCompany", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecordCompany", sEP_Record.SEPRecordCompany);
}
if (string.IsNullOrEmpty(sEP_Record.SEPRecord_Dept))
{
idb.AddParameter("@SEPRecord_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@SEPRecord_Dept", sEP_Record.SEPRecord_Dept);
}
if (sEP_Record.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sEP_Record.Stat);
}
if (sEP_Record.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", sEP_Record.CreateDate);
}
if (sEP_Record.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", sEP_Record.UpdateDate);
}
if (sEP_Record.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", sEP_Record.DeleteDate);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新物料盘存表 WH_CheckList对象(即:一条记录
/// </summary>
public int Update(WH_CheckList wH_CheckList)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE WH_CheckList SET ");
if (wH_CheckList.CL_MCode_IsChanged)
{
sbParameter.Append("CL_MCode=@CL_MCode, ");
}
if (wH_CheckList.CL_MName_IsChanged)
{
sbParameter.Append("CL_MName=@CL_MName, ");
}
if (wH_CheckList.CL_MSpec_IsChanged)
{
sbParameter.Append("CL_MSpec=@CL_MSpec, ");
}
if (wH_CheckList.CL_Month_IsChanged)
{
sbParameter.Append("CL_Month=@CL_Month, ");
}
if (wH_CheckList.CL_Last_IsChanged)
{
sbParameter.Append("CL_Last=@CL_Last, ");
}
if (wH_CheckList.CL_In_IsChanged)
{
sbParameter.Append("CL_In=@CL_In, ");
}
if (wH_CheckList.CL_Out_IsChanged)
{
sbParameter.Append("CL_Out=@CL_Out, ");
}
if (wH_CheckList.CL_Current_IsChanged)
{
sbParameter.Append("CL_Current=@CL_Current, ");
}
if (wH_CheckList.CL_CIn_IsChanged)
{
sbParameter.Append("CL_CIn=@CL_CIn, ");
}
if (wH_CheckList.CL_Mid_IsChanged)
{
sbParameter.Append("CL_Mid=@CL_Mid, ");
}
if (wH_CheckList.CL_LOut_IsChanged)
{
sbParameter.Append("CL_LOut=@CL_LOut, ");
}
if (wH_CheckList.CL_Date_IsChanged)
{
sbParameter.Append("CL_Date=@CL_Date, ");
}
if (wH_CheckList.CL_Stuff1_IsChanged)
{
sbParameter.Append("CL_Stuff1=@CL_Stuff1, ");
}
if (wH_CheckList.CL_Stuff2_IsChanged)
{
sbParameter.Append("CL_Stuff2=@CL_Stuff2, ");
}
if (wH_CheckList.CL_Bak_IsChanged)
{
sbParameter.Append("CL_Bak=@CL_Bak, ");
}
if (wH_CheckList.Creator_IsChanged)
{
sbParameter.Append("Creator=@Creator, ");
}
if (wH_CheckList.CreateTime_IsChanged)
{
sbParameter.Append("CreateTime=@CreateTime, ");
}
if (wH_CheckList.VerifyStuff_IsChanged)
{
sbParameter.Append("VerifyStuff=@VerifyStuff, ");
}
if (wH_CheckList.VerifyDate_IsChanged)
{
sbParameter.Append("VerifyDate=@VerifyDate, ");
}
if (wH_CheckList.VerifyStep_IsChanged)
{
sbParameter.Append("VerifyStep=@VerifyStep, ");
}
if (wH_CheckList.VerifyStat_IsChanged)
{
sbParameter.Append("VerifyStat=@VerifyStat, ");
}
if (wH_CheckList.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CL_ID=@CL_ID; ");
string sql = sb.ToString();
if (wH_CheckList.CL_MCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_MCode))
{
idb.AddParameter("@CL_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@CL_MCode", wH_CheckList.CL_MCode);
}
}
if (wH_CheckList.CL_MName_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_MName))
{
idb.AddParameter("@CL_MName", DBNull.Value);
}
else
{
idb.AddParameter("@CL_MName", wH_CheckList.CL_MName);
}
}
if (wH_CheckList.CL_MSpec_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_MSpec))
{
idb.AddParameter("@CL_MSpec", DBNull.Value);
}
else
{
idb.AddParameter("@CL_MSpec", wH_CheckList.CL_MSpec);
}
}
if (wH_CheckList.CL_Month_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Month))
{
idb.AddParameter("@CL_Month", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Month", wH_CheckList.CL_Month);
}
}
if (wH_CheckList.CL_Last_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Last))
{
idb.AddParameter("@CL_Last", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Last", wH_CheckList.CL_Last);
}
}
if (wH_CheckList.CL_In_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_In))
{
idb.AddParameter("@CL_In", DBNull.Value);
}
else
{
idb.AddParameter("@CL_In", wH_CheckList.CL_In);
}
}
if (wH_CheckList.CL_Out_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Out))
{
idb.AddParameter("@CL_Out", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Out", wH_CheckList.CL_Out);
}
}
if (wH_CheckList.CL_Current_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Current))
{
idb.AddParameter("@CL_Current", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Current", wH_CheckList.CL_Current);
}
}
if (wH_CheckList.CL_CIn_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_CIn))
{
idb.AddParameter("@CL_CIn", DBNull.Value);
}
else
{
idb.AddParameter("@CL_CIn", wH_CheckList.CL_CIn);
}
}
if (wH_CheckList.CL_Mid_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Mid))
{
idb.AddParameter("@CL_Mid", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Mid", wH_CheckList.CL_Mid);
}
}
if (wH_CheckList.CL_LOut_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_LOut))
{
idb.AddParameter("@CL_LOut", DBNull.Value);
}
else
{
idb.AddParameter("@CL_LOut", wH_CheckList.CL_LOut);
}
}
if (wH_CheckList.CL_Date_IsChanged)
{
if (wH_CheckList.CL_Date == DateTime.MinValue)
{
idb.AddParameter("@CL_Date", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Date", wH_CheckList.CL_Date);
}
}
if (wH_CheckList.CL_Stuff1_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Stuff1))
{
idb.AddParameter("@CL_Stuff1", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Stuff1", wH_CheckList.CL_Stuff1);
}
}
if (wH_CheckList.CL_Stuff2_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Stuff2))
{
idb.AddParameter("@CL_Stuff2", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Stuff2", wH_CheckList.CL_Stuff2);
}
}
if (wH_CheckList.CL_Bak_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.CL_Bak))
{
idb.AddParameter("@CL_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@CL_Bak", wH_CheckList.CL_Bak);
}
}
if (wH_CheckList.Creator_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.Creator))
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", wH_CheckList.Creator);
}
}
if (wH_CheckList.CreateTime_IsChanged)
{
if (wH_CheckList.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", wH_CheckList.CreateTime);
}
}
if (wH_CheckList.VerifyStuff_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.VerifyStuff))
{
idb.AddParameter("@VerifyStuff", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStuff", wH_CheckList.VerifyStuff);
}
}
if (wH_CheckList.VerifyDate_IsChanged)
{
if (wH_CheckList.VerifyDate == DateTime.MinValue)
{
idb.AddParameter("@VerifyDate", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyDate", wH_CheckList.VerifyDate);
}
}
if (wH_CheckList.VerifyStep_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.VerifyStep))
{
idb.AddParameter("@VerifyStep", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStep", wH_CheckList.VerifyStep);
}
}
if (wH_CheckList.VerifyStat_IsChanged)
{
if (string.IsNullOrEmpty(wH_CheckList.VerifyStat))
{
idb.AddParameter("@VerifyStat", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStat", wH_CheckList.VerifyStat);
}
}
if (wH_CheckList.Stat_IsChanged)
{
if (wH_CheckList.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_CheckList.Stat);
}
}
idb.AddParameter("@CL_ID", wH_CheckList.CL_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 更新审核模板列表 Audit_Template对象(即:一条记录
/// </summary>
public int Update(Audit_Template audit_Template)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Audit_Template SET ");
if (audit_Template.Template_Code_IsChanged)
{
sbParameter.Append("Template_Code=@Template_Code, ");
}
if (audit_Template.Template_Key_IsChanged)
{
sbParameter.Append("Template_Key=@Template_Key, ");
}
if (audit_Template.Template_Name_IsChanged)
{
sbParameter.Append("Template_Name=@Template_Name, ");
}
if (audit_Template.Template_Remark_IsChanged)
{
sbParameter.Append("Template_Remark=@Template_Remark, ");
}
if (audit_Template.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (audit_Template.Template_Table_IsChanged)
{
sbParameter.Append("Template_Table=@Template_Table, ");
}
if (audit_Template.Template_Column_IsChanged)
{
sbParameter.Append("Template_Column=@Template_Column, ");
}
if (audit_Template.Template_ColumnType_IsChanged)
{
sbParameter.Append("Template_ColumnType=@Template_ColumnType, ");
}
if (audit_Template.Template_CheckSQL_IsChanged)
{
sbParameter.Append("Template_CheckSQL=@Template_CheckSQL ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Template_ID=@Template_ID; ");
string sql = sb.ToString();
if (audit_Template.Template_Code_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_Code))
{
idb.AddParameter("@Template_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Template_Code", audit_Template.Template_Code);
}
}
if (audit_Template.Template_Key_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_Key))
{
idb.AddParameter("@Template_Key", DBNull.Value);
}
else
{
idb.AddParameter("@Template_Key", audit_Template.Template_Key);
}
}
if (audit_Template.Template_Name_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_Name))
{
idb.AddParameter("@Template_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Template_Name", audit_Template.Template_Name);
}
}
if (audit_Template.Template_Remark_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_Remark))
{
idb.AddParameter("@Template_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@Template_Remark", audit_Template.Template_Remark);
}
}
if (audit_Template.Stat_IsChanged)
{
if (audit_Template.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", audit_Template.Stat);
}
}
if (audit_Template.Template_Table_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_Table))
{
idb.AddParameter("@Template_Table", DBNull.Value);
}
else
{
idb.AddParameter("@Template_Table", audit_Template.Template_Table);
}
}
if (audit_Template.Template_Column_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_Column))
{
idb.AddParameter("@Template_Column", DBNull.Value);
}
else
{
idb.AddParameter("@Template_Column", audit_Template.Template_Column);
}
}
if (audit_Template.Template_ColumnType_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_ColumnType))
{
idb.AddParameter("@Template_ColumnType", DBNull.Value);
}
else
{
idb.AddParameter("@Template_ColumnType", audit_Template.Template_ColumnType);
}
}
if (audit_Template.Template_CheckSQL_IsChanged)
{
if (string.IsNullOrEmpty(audit_Template.Template_CheckSQL))
{
idb.AddParameter("@Template_CheckSQL", DBNull.Value);
}
else
{
idb.AddParameter("@Template_CheckSQL", audit_Template.Template_CheckSQL);
}
}
idb.AddParameter("@Template_ID", audit_Template.Template_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
