/// <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); }