/// <summary>
/// 更新PCD_Queue对象(即:一条记录
/// </summary>
public int Update(PCD_Queue pCD_Queue)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE PCD_Queue SET ");
if (pCD_Queue.PCDO_PlanCode_IsChanged)
{
sbParameter.Append("PCDO_PlanCode=@PCDO_PlanCode, ");
}
if (pCD_Queue.PCDO_NCode_IsChanged)
{
sbParameter.Append("PCDO_NCode=@PCDO_NCode, ");
}
if (pCD_Queue.PCDO_Order_IsChanged)
{
sbParameter.Append("PCDO_Order=@PCDO_Order, ");
}
if (pCD_Queue.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 PCDO_ID=@PCDO_ID; ");
string sql = sb.ToString();
if (pCD_Queue.PCDO_PlanCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_Queue.PCDO_PlanCode))
{
idb.AddParameter("@PCDO_PlanCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDO_PlanCode", pCD_Queue.PCDO_PlanCode);
}
}
if (pCD_Queue.PCDO_NCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_Queue.PCDO_NCode))
{
idb.AddParameter("@PCDO_NCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDO_NCode", pCD_Queue.PCDO_NCode);
}
}
if (pCD_Queue.PCDO_Order_IsChanged)
{
if (pCD_Queue.PCDO_Order == 0)
{
idb.AddParameter("@PCDO_Order", 0);
}
else
{
idb.AddParameter("@PCDO_Order", pCD_Queue.PCDO_Order);
}
}
if (pCD_Queue.Stat_IsChanged)
{
if (pCD_Queue.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pCD_Queue.Stat);
}
}
idb.AddParameter("@PCDO_ID", pCD_Queue.PCDO_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>
/// 添加审核阶段信息 Verify_Nodes对象(即:一条记录)
/// </summary>
public object AddWithReturn(Verify_Nodes verify_Nodes)
{
string sql = "INSERT INTO Verify_Nodes (VerifyNode_Code,VerifyNode_Name,VerifyNode_Remark,VerifyNode_AuditNum,Stat) VALUES (@VerifyNode_Code,@VerifyNode_Name,@VerifyNode_Remark,@VerifyNode_AuditNum,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(verify_Nodes.VerifyNode_Code))
{
idb.AddParameter("@VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyNode_Code", verify_Nodes.VerifyNode_Code);
}
if (string.IsNullOrEmpty(verify_Nodes.VerifyNode_Name))
{
idb.AddParameter("@VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyNode_Name", verify_Nodes.VerifyNode_Name);
}
if (string.IsNullOrEmpty(verify_Nodes.VerifyNode_Remark))
{
idb.AddParameter("@VerifyNode_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyNode_Remark", verify_Nodes.VerifyNode_Remark);
}
if (verify_Nodes.VerifyNode_AuditNum == 0)
{
idb.AddParameter("@VerifyNode_AuditNum", 0);
}
else
{
idb.AddParameter("@VerifyNode_AuditNum", verify_Nodes.VerifyNode_AuditNum);
}
if (verify_Nodes.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_Nodes.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>
/// 添加外联协调信息 Outreach_Coordination对象(即:一条记录)
/// </summary>
public object AddWithReturn(Outreach_Coordination outreach_Coordination)
{
string sql = "INSERT INTO Outreach_Coordination (OC_Code,OC_OutretachCode,OC_OutreachName,OC_CoordinationType,OC_MainContactor,OC_Telephone,OC_Content,OC_Result,OC_ResultType,OC_Cost,OC_Remark,OC_Attachment,OC_Company,OC_Dept,OC_iType,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@OC_Code,@OC_OutretachCode,@OC_OutreachName,@OC_CoordinationType,@OC_MainContactor,@OC_Telephone,@OC_Content,@OC_Result,@OC_ResultType,@OC_Cost,@OC_Remark,@OC_Attachment,@OC_Company,@OC_Dept,@OC_iType,@Stat,@CreateDate,@UpdateDate,@DeleteDate);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(outreach_Coordination.OC_Code))
{
idb.AddParameter("@OC_Code", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Code", outreach_Coordination.OC_Code);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_OutretachCode))
{
idb.AddParameter("@OC_OutretachCode", DBNull.Value);
}
else
{
idb.AddParameter("@OC_OutretachCode", outreach_Coordination.OC_OutretachCode);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_OutreachName))
{
idb.AddParameter("@OC_OutreachName", DBNull.Value);
}
else
{
idb.AddParameter("@OC_OutreachName", outreach_Coordination.OC_OutreachName);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_CoordinationType))
{
idb.AddParameter("@OC_CoordinationType", DBNull.Value);
}
else
{
idb.AddParameter("@OC_CoordinationType", outreach_Coordination.OC_CoordinationType);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_MainContactor))
{
idb.AddParameter("@OC_MainContactor", DBNull.Value);
}
else
{
idb.AddParameter("@OC_MainContactor", outreach_Coordination.OC_MainContactor);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Telephone))
{
idb.AddParameter("@OC_Telephone", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Telephone", outreach_Coordination.OC_Telephone);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Content))
{
idb.AddParameter("@OC_Content", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Content", outreach_Coordination.OC_Content);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Result))
{
idb.AddParameter("@OC_Result", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Result", outreach_Coordination.OC_Result);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_ResultType))
{
idb.AddParameter("@OC_ResultType", DBNull.Value);
}
else
{
idb.AddParameter("@OC_ResultType", outreach_Coordination.OC_ResultType);
}
if (outreach_Coordination.OC_Cost == 0)
{
idb.AddParameter("@OC_Cost", 0);
}
else
{
idb.AddParameter("@OC_Cost", outreach_Coordination.OC_Cost);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Remark))
{
idb.AddParameter("@OC_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Remark", outreach_Coordination.OC_Remark);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Attachment))
{
idb.AddParameter("@OC_Attachment", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Attachment", outreach_Coordination.OC_Attachment);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Company))
{
idb.AddParameter("@OC_Company", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Company", outreach_Coordination.OC_Company);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_Dept))
{
idb.AddParameter("@OC_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Dept", outreach_Coordination.OC_Dept);
}
if (string.IsNullOrEmpty(outreach_Coordination.OC_iType))
{
idb.AddParameter("@OC_iType", DBNull.Value);
}
else
{
idb.AddParameter("@OC_iType", outreach_Coordination.OC_iType);
}
if (outreach_Coordination.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", outreach_Coordination.Stat);
}
if (outreach_Coordination.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", outreach_Coordination.CreateDate);
}
if (outreach_Coordination.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", outreach_Coordination.UpdateDate);
}
if (outreach_Coordination.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", outreach_Coordination.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>
/// 更新公司物料类别 WH_MaterialType对象(即:一条记录
/// </summary>
public int Update(WH_MaterialType wH_MaterialType)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE WH_MaterialType SET ");
if (wH_MaterialType.MT_Code_IsChanged)
{
sbParameter.Append("MT_Code=@MT_Code, ");
}
if (wH_MaterialType.MT_TCode_IsChanged)
{
sbParameter.Append("MT_TCode=@MT_TCode, ");
}
if (wH_MaterialType.MT_TName_IsChanged)
{
sbParameter.Append("MT_TName=@MT_TName, ");
}
if (wH_MaterialType.MT_Company_IsChanged)
{
sbParameter.Append("MT_Company=@MT_Company, ");
}
if (wH_MaterialType.MT_CompanyCode_IsChanged)
{
sbParameter.Append("MT_CompanyCode=@MT_CompanyCode, ");
}
if (wH_MaterialType.MT_Dept_IsChanged)
{
sbParameter.Append("MT_Dept=@MT_Dept, ");
}
if (wH_MaterialType.MT_DeptCode_IsChanged)
{
sbParameter.Append("MT_DeptCode=@MT_DeptCode, ");
}
if (wH_MaterialType.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (wH_MaterialType.MT_Status_IsChanged)
{
sbParameter.Append("MT_Status=@MT_Status, ");
}
if (wH_MaterialType.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (wH_MaterialType.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (wH_MaterialType.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (wH_MaterialType.MT_Itype_IsChanged)
{
sbParameter.Append("MT_Itype=@MT_Itype, ");
}
if (wH_MaterialType.MT_Type_IsChanged)
{
sbParameter.Append("MT_Type=@MT_Type, ");
}
if (wH_MaterialType.MT_Employee_IsChanged)
{
sbParameter.Append("MT_Employee=@MT_Employee, ");
}
if (wH_MaterialType.MT_EmployeeName_IsChanged)
{
sbParameter.Append("MT_EmployeeName=@MT_EmployeeName, ");
}
if (wH_MaterialType.MT_TPCode_IsChanged)
{
sbParameter.Append("MT_TPCode=@MT_TPCode, ");
}
if (wH_MaterialType.MT_Order_IsChanged)
{
sbParameter.Append("MT_Order=@MT_Order ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and MT_ID=@MT_ID; ");
string sql = sb.ToString();
if (wH_MaterialType.MT_Code_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Code))
{
idb.AddParameter("@MT_Code", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Code", wH_MaterialType.MT_Code);
}
}
if (wH_MaterialType.MT_TCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_TCode))
{
idb.AddParameter("@MT_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_TCode", wH_MaterialType.MT_TCode);
}
}
if (wH_MaterialType.MT_TName_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_TName))
{
idb.AddParameter("@MT_TName", DBNull.Value);
}
else
{
idb.AddParameter("@MT_TName", wH_MaterialType.MT_TName);
}
}
if (wH_MaterialType.MT_Company_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Company))
{
idb.AddParameter("@MT_Company", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Company", wH_MaterialType.MT_Company);
}
}
if (wH_MaterialType.MT_CompanyCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_CompanyCode))
{
idb.AddParameter("@MT_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_CompanyCode", wH_MaterialType.MT_CompanyCode);
}
}
if (wH_MaterialType.MT_Dept_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Dept))
{
idb.AddParameter("@MT_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Dept", wH_MaterialType.MT_Dept);
}
}
if (wH_MaterialType.MT_DeptCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_DeptCode))
{
idb.AddParameter("@MT_DeptCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_DeptCode", wH_MaterialType.MT_DeptCode);
}
}
if (wH_MaterialType.Stat_IsChanged)
{
if (wH_MaterialType.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_MaterialType.Stat);
}
}
if (wH_MaterialType.MT_Status_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Status))
{
idb.AddParameter("@MT_Status", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Status", wH_MaterialType.MT_Status);
}
}
if (wH_MaterialType.CreateDate_IsChanged)
{
if (wH_MaterialType.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_MaterialType.CreateDate);
}
}
if (wH_MaterialType.UpdateDate_IsChanged)
{
if (wH_MaterialType.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_MaterialType.UpdateDate);
}
}
if (wH_MaterialType.DeleteDate_IsChanged)
{
if (wH_MaterialType.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_MaterialType.DeleteDate);
}
}
if (wH_MaterialType.MT_Itype_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Itype))
{
idb.AddParameter("@MT_Itype", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Itype", wH_MaterialType.MT_Itype);
}
}
if (wH_MaterialType.MT_Type_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Type))
{
idb.AddParameter("@MT_Type", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Type", wH_MaterialType.MT_Type);
}
}
if (wH_MaterialType.MT_Employee_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_Employee))
{
idb.AddParameter("@MT_Employee", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Employee", wH_MaterialType.MT_Employee);
}
}
if (wH_MaterialType.MT_EmployeeName_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_EmployeeName))
{
idb.AddParameter("@MT_EmployeeName", DBNull.Value);
}
else
{
idb.AddParameter("@MT_EmployeeName", wH_MaterialType.MT_EmployeeName);
}
}
if (wH_MaterialType.MT_TPCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_MaterialType.MT_TPCode))
{
idb.AddParameter("@MT_TPCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_TPCode", wH_MaterialType.MT_TPCode);
}
}
if (wH_MaterialType.MT_Order_IsChanged)
{
if (wH_MaterialType.MT_Order == 0)
{
idb.AddParameter("@MT_Order", 0);
}
else
{
idb.AddParameter("@MT_Order", wH_MaterialType.MT_Order);
}
}
idb.AddParameter("@MT_ID", wH_MaterialType.MT_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_BStation对象(即:一条记录
/// </summary>
public int Update(PC_BStation pC_BStation)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE PC_BStation SET ");
if (pC_BStation.PCBS_Code_IsChanged)
{
sbParameter.Append("PCBS_Code=@PCBS_Code, ");
}
if (pC_BStation.PCBS_Name_IsChanged)
{
sbParameter.Append("PCBS_Name=@PCBS_Name, ");
}
if (pC_BStation.PCBS_Addr_IsChanged)
{
sbParameter.Append("PCBS_Addr=@PCBS_Addr, ");
}
if (pC_BStation.PCBS_Start_IsChanged)
{
sbParameter.Append("PCBS_Start=@PCBS_Start, ");
}
if (pC_BStation.PCBS_Status_IsChanged)
{
sbParameter.Append("PCBS_Status=@PCBS_Status, ");
}
if (pC_BStation.PCBS_Bak_IsChanged)
{
sbParameter.Append("PCBS_Bak=@PCBS_Bak, ");
}
if (pC_BStation.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (pC_BStation.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (pC_BStation.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (pC_BStation.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 PCBS_ID=@PCBS_ID; ");
string sql = sb.ToString();
if (pC_BStation.PCBS_Code_IsChanged)
{
if (string.IsNullOrEmpty(pC_BStation.PCBS_Code))
{
idb.AddParameter("@PCBS_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Code", pC_BStation.PCBS_Code);
}
}
if (pC_BStation.PCBS_Name_IsChanged)
{
if (string.IsNullOrEmpty(pC_BStation.PCBS_Name))
{
idb.AddParameter("@PCBS_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Name", pC_BStation.PCBS_Name);
}
}
if (pC_BStation.PCBS_Addr_IsChanged)
{
if (string.IsNullOrEmpty(pC_BStation.PCBS_Addr))
{
idb.AddParameter("@PCBS_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Addr", pC_BStation.PCBS_Addr);
}
}
if (pC_BStation.PCBS_Start_IsChanged)
{
if (pC_BStation.PCBS_Start == DateTime.MinValue)
{
idb.AddParameter("@PCBS_Start", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Start", pC_BStation.PCBS_Start);
}
}
if (pC_BStation.PCBS_Status_IsChanged)
{
if (string.IsNullOrEmpty(pC_BStation.PCBS_Status))
{
idb.AddParameter("@PCBS_Status", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Status", pC_BStation.PCBS_Status);
}
}
if (pC_BStation.PCBS_Bak_IsChanged)
{
if (string.IsNullOrEmpty(pC_BStation.PCBS_Bak))
{
idb.AddParameter("@PCBS_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Bak", pC_BStation.PCBS_Bak);
}
}
if (pC_BStation.Stat_IsChanged)
{
if (pC_BStation.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_BStation.Stat);
}
}
if (pC_BStation.CreateDate_IsChanged)
{
if (pC_BStation.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_BStation.CreateDate);
}
}
if (pC_BStation.UpdateDate_IsChanged)
{
if (pC_BStation.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_BStation.UpdateDate);
}
}
if (pC_BStation.DeleteDate_IsChanged)
{
if (pC_BStation.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_BStation.DeleteDate);
}
}
idb.AddParameter("@PCBS_ID", pC_BStation.PCBS_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>
/// 添加Bug管理系统 Sys_Bug对象(即:一条记录)
/// </summary>
public int Add(Sys_Bug sys_Bug)
{
string sql = "INSERT INTO Sys_Bug (Sys_Code,Sys_Date,Sys_Title,Sys_Des,Sys_Project,Sys_Module,Sys_UserCode,Sys_UserName,Sys_Owner,Sys_OpUser,Sys_Status,Stat) VALUES (@Sys_Code,@Sys_Date,@Sys_Title,@Sys_Des,@Sys_Project,@Sys_Module,@Sys_UserCode,@Sys_UserName,@Sys_Owner,@Sys_OpUser,@Sys_Status,@Stat)";
if (string.IsNullOrEmpty(sys_Bug.Sys_Code))
{
idb.AddParameter("@Sys_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Code", sys_Bug.Sys_Code);
}
if (sys_Bug.Sys_Date == DateTime.MinValue)
{
idb.AddParameter("@Sys_Date", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Date", sys_Bug.Sys_Date);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_Title))
{
idb.AddParameter("@Sys_Title", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Title", sys_Bug.Sys_Title);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_Des))
{
idb.AddParameter("@Sys_Des", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Des", sys_Bug.Sys_Des);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_Project))
{
idb.AddParameter("@Sys_Project", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Project", sys_Bug.Sys_Project);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_Module))
{
idb.AddParameter("@Sys_Module", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Module", sys_Bug.Sys_Module);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_UserCode))
{
idb.AddParameter("@Sys_UserCode", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_UserCode", sys_Bug.Sys_UserCode);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_UserName))
{
idb.AddParameter("@Sys_UserName", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_UserName", sys_Bug.Sys_UserName);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_Owner))
{
idb.AddParameter("@Sys_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Owner", sys_Bug.Sys_Owner);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_OpUser))
{
idb.AddParameter("@Sys_OpUser", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_OpUser", sys_Bug.Sys_OpUser);
}
if (string.IsNullOrEmpty(sys_Bug.Sys_Status))
{
idb.AddParameter("@Sys_Status", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Status", sys_Bug.Sys_Status);
}
if (sys_Bug.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Bug.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>
/// 添加外联单位管理 Outreach_Info对象(即:一条记录)
/// </summary>
public int Add(Outreach_Info outreach_Info)
{
string sql = "INSERT INTO Outreach_Info (OI_Code,OI_Name,OI_Address,OI_Telephone,OI_CompanyType,OI_iType,OI_MainContactor,OI_ContactPhone,OI_Contactor,Ol_Attachment,OI_Remark,OI_Company,OI_Dept,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@OI_Code,@OI_Name,@OI_Address,@OI_Telephone,@OI_CompanyType,@OI_iType,@OI_MainContactor,@OI_ContactPhone,@OI_Contactor,@Ol_Attachment,@OI_Remark,@OI_Company,@OI_Dept,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(outreach_Info.OI_Code))
{
idb.AddParameter("@OI_Code", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Code", outreach_Info.OI_Code);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Name))
{
idb.AddParameter("@OI_Name", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Name", outreach_Info.OI_Name);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Address))
{
idb.AddParameter("@OI_Address", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Address", outreach_Info.OI_Address);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Telephone))
{
idb.AddParameter("@OI_Telephone", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Telephone", outreach_Info.OI_Telephone);
}
if (string.IsNullOrEmpty(outreach_Info.OI_CompanyType))
{
idb.AddParameter("@OI_CompanyType", DBNull.Value);
}
else
{
idb.AddParameter("@OI_CompanyType", outreach_Info.OI_CompanyType);
}
if (string.IsNullOrEmpty(outreach_Info.OI_iType))
{
idb.AddParameter("@OI_iType", DBNull.Value);
}
else
{
idb.AddParameter("@OI_iType", outreach_Info.OI_iType);
}
if (string.IsNullOrEmpty(outreach_Info.OI_MainContactor))
{
idb.AddParameter("@OI_MainContactor", DBNull.Value);
}
else
{
idb.AddParameter("@OI_MainContactor", outreach_Info.OI_MainContactor);
}
if (string.IsNullOrEmpty(outreach_Info.OI_ContactPhone))
{
idb.AddParameter("@OI_ContactPhone", DBNull.Value);
}
else
{
idb.AddParameter("@OI_ContactPhone", outreach_Info.OI_ContactPhone);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Contactor))
{
idb.AddParameter("@OI_Contactor", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Contactor", outreach_Info.OI_Contactor);
}
if (string.IsNullOrEmpty(outreach_Info.Ol_Attachment))
{
idb.AddParameter("@Ol_Attachment", DBNull.Value);
}
else
{
idb.AddParameter("@Ol_Attachment", outreach_Info.Ol_Attachment);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Remark))
{
idb.AddParameter("@OI_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Remark", outreach_Info.OI_Remark);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Company))
{
idb.AddParameter("@OI_Company", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Company", outreach_Info.OI_Company);
}
if (string.IsNullOrEmpty(outreach_Info.OI_Dept))
{
idb.AddParameter("@OI_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@OI_Dept", outreach_Info.OI_Dept);
}
if (outreach_Info.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", outreach_Info.Stat);
}
if (outreach_Info.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", outreach_Info.CreateDate);
}
if (outreach_Info.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", outreach_Info.UpdateDate);
}
if (outreach_Info.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", outreach_Info.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>
/// 添加Assets_Apply对象(即:一条记录)
/// </summary>
public int Add(Assets_Apply assets_Apply)
{
string sql = "INSERT INTO Assets_Apply (AssetsApply_Code,AssetsApply_AppPerson,AssetsApply_AppDept,AssetsApply_AppName,AssetsApply_Parameter,AssetsApply_Description,AssetsApply_AppCount,AssetsApply_Type,AssetsApply_AppType,AssetsApply_Date,AssetsApply_AudistStat,AssetsApply_Stat,AssetsApply_Remark,Stat) VALUES (@AssetsApply_Code,@AssetsApply_AppPerson,@AssetsApply_AppDept,@AssetsApply_AppName,@AssetsApply_Parameter,@AssetsApply_Description,@AssetsApply_AppCount,@AssetsApply_Type,@AssetsApply_AppType,@AssetsApply_Date,@AssetsApply_AudistStat,@AssetsApply_Stat,@AssetsApply_Remark,@Stat)";
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Code))
{
idb.AddParameter("@AssetsApply_Code", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Code", assets_Apply.AssetsApply_Code);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppPerson))
{
idb.AddParameter("@AssetsApply_AppPerson", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppPerson", assets_Apply.AssetsApply_AppPerson);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppDept))
{
idb.AddParameter("@AssetsApply_AppDept", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppDept", assets_Apply.AssetsApply_AppDept);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppName))
{
idb.AddParameter("@AssetsApply_AppName", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppName", assets_Apply.AssetsApply_AppName);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Parameter))
{
idb.AddParameter("@AssetsApply_Parameter", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Parameter", assets_Apply.AssetsApply_Parameter);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Description))
{
idb.AddParameter("@AssetsApply_Description", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Description", assets_Apply.AssetsApply_Description);
}
if (assets_Apply.AssetsApply_AppCount == 0)
{
idb.AddParameter("@AssetsApply_AppCount", 0);
}
else
{
idb.AddParameter("@AssetsApply_AppCount", assets_Apply.AssetsApply_AppCount);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Type))
{
idb.AddParameter("@AssetsApply_Type", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Type", assets_Apply.AssetsApply_Type);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppType))
{
idb.AddParameter("@AssetsApply_AppType", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppType", assets_Apply.AssetsApply_AppType);
}
if (assets_Apply.AssetsApply_Date == DateTime.MinValue)
{
idb.AddParameter("@AssetsApply_Date", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Date", assets_Apply.AssetsApply_Date);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AudistStat))
{
idb.AddParameter("@AssetsApply_AudistStat", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AudistStat", assets_Apply.AssetsApply_AudistStat);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Stat))
{
idb.AddParameter("@AssetsApply_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Stat", assets_Apply.AssetsApply_Stat);
}
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Remark))
{
idb.AddParameter("@AssetsApply_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Remark", assets_Apply.AssetsApply_Remark);
}
if (assets_Apply.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", assets_Apply.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>
/// 更新Assets_Apply对象(即:一条记录
/// </summary>
public int Update(Assets_Apply assets_Apply)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Assets_Apply SET ");
if (assets_Apply.AssetsApply_Code_IsChanged)
{
sbParameter.Append("AssetsApply_Code=@AssetsApply_Code, ");
}
if (assets_Apply.AssetsApply_AppPerson_IsChanged)
{
sbParameter.Append("AssetsApply_AppPerson=@AssetsApply_AppPerson, ");
}
if (assets_Apply.AssetsApply_AppDept_IsChanged)
{
sbParameter.Append("AssetsApply_AppDept=@AssetsApply_AppDept, ");
}
if (assets_Apply.AssetsApply_AppName_IsChanged)
{
sbParameter.Append("AssetsApply_AppName=@AssetsApply_AppName, ");
}
if (assets_Apply.AssetsApply_Parameter_IsChanged)
{
sbParameter.Append("AssetsApply_Parameter=@AssetsApply_Parameter, ");
}
if (assets_Apply.AssetsApply_Description_IsChanged)
{
sbParameter.Append("AssetsApply_Description=@AssetsApply_Description, ");
}
if (assets_Apply.AssetsApply_AppCount_IsChanged)
{
sbParameter.Append("AssetsApply_AppCount=@AssetsApply_AppCount, ");
}
if (assets_Apply.AssetsApply_Type_IsChanged)
{
sbParameter.Append("AssetsApply_Type=@AssetsApply_Type, ");
}
if (assets_Apply.AssetsApply_AppType_IsChanged)
{
sbParameter.Append("AssetsApply_AppType=@AssetsApply_AppType, ");
}
if (assets_Apply.AssetsApply_Date_IsChanged)
{
sbParameter.Append("AssetsApply_Date=@AssetsApply_Date, ");
}
if (assets_Apply.AssetsApply_AudistStat_IsChanged)
{
sbParameter.Append("AssetsApply_AudistStat=@AssetsApply_AudistStat, ");
}
if (assets_Apply.AssetsApply_Stat_IsChanged)
{
sbParameter.Append("AssetsApply_Stat=@AssetsApply_Stat, ");
}
if (assets_Apply.AssetsApply_Remark_IsChanged)
{
sbParameter.Append("AssetsApply_Remark=@AssetsApply_Remark, ");
}
if (assets_Apply.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 AssetsApply_ID=@AssetsApply_ID; ");
string sql = sb.ToString();
if (assets_Apply.AssetsApply_Code_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Code))
{
idb.AddParameter("@AssetsApply_Code", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Code", assets_Apply.AssetsApply_Code);
}
}
if (assets_Apply.AssetsApply_AppPerson_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppPerson))
{
idb.AddParameter("@AssetsApply_AppPerson", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppPerson", assets_Apply.AssetsApply_AppPerson);
}
}
if (assets_Apply.AssetsApply_AppDept_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppDept))
{
idb.AddParameter("@AssetsApply_AppDept", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppDept", assets_Apply.AssetsApply_AppDept);
}
}
if (assets_Apply.AssetsApply_AppName_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppName))
{
idb.AddParameter("@AssetsApply_AppName", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppName", assets_Apply.AssetsApply_AppName);
}
}
if (assets_Apply.AssetsApply_Parameter_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Parameter))
{
idb.AddParameter("@AssetsApply_Parameter", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Parameter", assets_Apply.AssetsApply_Parameter);
}
}
if (assets_Apply.AssetsApply_Description_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Description))
{
idb.AddParameter("@AssetsApply_Description", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Description", assets_Apply.AssetsApply_Description);
}
}
if (assets_Apply.AssetsApply_AppCount_IsChanged)
{
if (assets_Apply.AssetsApply_AppCount == 0)
{
idb.AddParameter("@AssetsApply_AppCount", 0);
}
else
{
idb.AddParameter("@AssetsApply_AppCount", assets_Apply.AssetsApply_AppCount);
}
}
if (assets_Apply.AssetsApply_Type_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Type))
{
idb.AddParameter("@AssetsApply_Type", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Type", assets_Apply.AssetsApply_Type);
}
}
if (assets_Apply.AssetsApply_AppType_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AppType))
{
idb.AddParameter("@AssetsApply_AppType", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AppType", assets_Apply.AssetsApply_AppType);
}
}
if (assets_Apply.AssetsApply_Date_IsChanged)
{
if (assets_Apply.AssetsApply_Date == DateTime.MinValue)
{
idb.AddParameter("@AssetsApply_Date", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Date", assets_Apply.AssetsApply_Date);
}
}
if (assets_Apply.AssetsApply_AudistStat_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_AudistStat))
{
idb.AddParameter("@AssetsApply_AudistStat", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_AudistStat", assets_Apply.AssetsApply_AudistStat);
}
}
if (assets_Apply.AssetsApply_Stat_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Stat))
{
idb.AddParameter("@AssetsApply_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Stat", assets_Apply.AssetsApply_Stat);
}
}
if (assets_Apply.AssetsApply_Remark_IsChanged)
{
if (string.IsNullOrEmpty(assets_Apply.AssetsApply_Remark))
{
idb.AddParameter("@AssetsApply_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@AssetsApply_Remark", assets_Apply.AssetsApply_Remark);
}
}
if (assets_Apply.Stat_IsChanged)
{
if (assets_Apply.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", assets_Apply.Stat);
}
}
idb.AddParameter("@AssetsApply_ID", assets_Apply.AssetsApply_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_CItem对象(即:一条记录)
/// </summary>
public int Add(WH_CItem wH_CItem)
{
string sql = "INSERT INTO WH_CItem (WHCI_CCode,WHCI_MCode,WHCI_Num,WHCI_Unit,WHCI_Manu,WHCI_MDate,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@WHCI_CCode,@WHCI_MCode,@WHCI_Num,@WHCI_Unit,@WHCI_Manu,@WHCI_MDate,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(wH_CItem.WHCI_CCode))
{
idb.AddParameter("@WHCI_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_CCode", wH_CItem.WHCI_CCode);
}
if (string.IsNullOrEmpty(wH_CItem.WHCI_MCode))
{
idb.AddParameter("@WHCI_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_MCode", wH_CItem.WHCI_MCode);
}
if (wH_CItem.WHCI_Num == 0)
{
idb.AddParameter("@WHCI_Num", 0);
}
else
{
idb.AddParameter("@WHCI_Num", wH_CItem.WHCI_Num);
}
if (string.IsNullOrEmpty(wH_CItem.WHCI_Unit))
{
idb.AddParameter("@WHCI_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_Unit", wH_CItem.WHCI_Unit);
}
if (string.IsNullOrEmpty(wH_CItem.WHCI_Manu))
{
idb.AddParameter("@WHCI_Manu", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_Manu", wH_CItem.WHCI_Manu);
}
if (wH_CItem.WHCI_MDate == DateTime.MinValue)
{
idb.AddParameter("@WHCI_MDate", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_MDate", wH_CItem.WHCI_MDate);
}
if (wH_CItem.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_CItem.Stat);
}
if (wH_CItem.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_CItem.CreateDate);
}
if (wH_CItem.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_CItem.UpdateDate);
}
if (wH_CItem.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_CItem.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_CItem对象(即:一条记录
/// </summary>
public int Update(WH_CItem wH_CItem)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE WH_CItem SET ");
if (wH_CItem.WHCI_CCode_IsChanged)
{
sbParameter.Append("WHCI_CCode=@WHCI_CCode, ");
}
if (wH_CItem.WHCI_MCode_IsChanged)
{
sbParameter.Append("WHCI_MCode=@WHCI_MCode, ");
}
if (wH_CItem.WHCI_Num_IsChanged)
{
sbParameter.Append("WHCI_Num=@WHCI_Num, ");
}
if (wH_CItem.WHCI_Unit_IsChanged)
{
sbParameter.Append("WHCI_Unit=@WHCI_Unit, ");
}
if (wH_CItem.WHCI_Manu_IsChanged)
{
sbParameter.Append("WHCI_Manu=@WHCI_Manu, ");
}
if (wH_CItem.WHCI_MDate_IsChanged)
{
sbParameter.Append("WHCI_MDate=@WHCI_MDate, ");
}
if (wH_CItem.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (wH_CItem.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (wH_CItem.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (wH_CItem.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 WHCI_ID=@WHCI_ID; ");
string sql = sb.ToString();
if (wH_CItem.WHCI_CCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_CItem.WHCI_CCode))
{
idb.AddParameter("@WHCI_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_CCode", wH_CItem.WHCI_CCode);
}
}
if (wH_CItem.WHCI_MCode_IsChanged)
{
if (string.IsNullOrEmpty(wH_CItem.WHCI_MCode))
{
idb.AddParameter("@WHCI_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_MCode", wH_CItem.WHCI_MCode);
}
}
if (wH_CItem.WHCI_Num_IsChanged)
{
if (wH_CItem.WHCI_Num == 0)
{
idb.AddParameter("@WHCI_Num", 0);
}
else
{
idb.AddParameter("@WHCI_Num", wH_CItem.WHCI_Num);
}
}
if (wH_CItem.WHCI_Unit_IsChanged)
{
if (string.IsNullOrEmpty(wH_CItem.WHCI_Unit))
{
idb.AddParameter("@WHCI_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_Unit", wH_CItem.WHCI_Unit);
}
}
if (wH_CItem.WHCI_Manu_IsChanged)
{
if (string.IsNullOrEmpty(wH_CItem.WHCI_Manu))
{
idb.AddParameter("@WHCI_Manu", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_Manu", wH_CItem.WHCI_Manu);
}
}
if (wH_CItem.WHCI_MDate_IsChanged)
{
if (wH_CItem.WHCI_MDate == DateTime.MinValue)
{
idb.AddParameter("@WHCI_MDate", DBNull.Value);
}
else
{
idb.AddParameter("@WHCI_MDate", wH_CItem.WHCI_MDate);
}
}
if (wH_CItem.Stat_IsChanged)
{
if (wH_CItem.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_CItem.Stat);
}
}
if (wH_CItem.CreateDate_IsChanged)
{
if (wH_CItem.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_CItem.CreateDate);
}
}
if (wH_CItem.UpdateDate_IsChanged)
{
if (wH_CItem.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_CItem.UpdateDate);
}
}
if (wH_CItem.DeleteDate_IsChanged)
{
if (wH_CItem.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_CItem.DeleteDate);
}
}
idb.AddParameter("@WHCI_ID", wH_CItem.WHCI_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_Bak对象(即:一条记录)
/// </summary>
public object AddWithReturn(Bse_Bak bse_Bak)
{
string sql = "INSERT INTO Bse_Bak (Module_Code,Record_ID,Bak_Content,Stat) VALUES (@Module_Code,@Record_ID,@Bak_Content,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(bse_Bak.Module_Code))
{
idb.AddParameter("@Module_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Module_Code", bse_Bak.Module_Code);
}
if (string.IsNullOrEmpty(bse_Bak.Record_ID))
{
idb.AddParameter("@Record_ID", DBNull.Value);
}
else
{
idb.AddParameter("@Record_ID", bse_Bak.Record_ID);
}
if (string.IsNullOrEmpty(bse_Bak.Bak_Content))
{
idb.AddParameter("@Bak_Content", DBNull.Value);
}
else
{
idb.AddParameter("@Bak_Content", bse_Bak.Bak_Content);
}
if (bse_Bak.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Bak.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>
/// 更新备注信息 Bse_Bak对象(即:一条记录
/// </summary>
public int Update(Bse_Bak bse_Bak)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_Bak SET ");
if (bse_Bak.Module_Code_IsChanged)
{
sbParameter.Append("Module_Code=@Module_Code, ");
}
if (bse_Bak.Record_ID_IsChanged)
{
sbParameter.Append("Record_ID=@Record_ID, ");
}
if (bse_Bak.Bak_Content_IsChanged)
{
sbParameter.Append("Bak_Content=@Bak_Content, ");
}
if (bse_Bak.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 Bak_ID=@Bak_ID; ");
string sql = sb.ToString();
if (bse_Bak.Module_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bak.Module_Code))
{
idb.AddParameter("@Module_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Module_Code", bse_Bak.Module_Code);
}
}
if (bse_Bak.Record_ID_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bak.Record_ID))
{
idb.AddParameter("@Record_ID", DBNull.Value);
}
else
{
idb.AddParameter("@Record_ID", bse_Bak.Record_ID);
}
}
if (bse_Bak.Bak_Content_IsChanged)
{
if (string.IsNullOrEmpty(bse_Bak.Bak_Content))
{
idb.AddParameter("@Bak_Content", DBNull.Value);
}
else
{
idb.AddParameter("@Bak_Content", bse_Bak.Bak_Content);
}
}
if (bse_Bak.Stat_IsChanged)
{
if (bse_Bak.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Bak.Stat);
}
}
idb.AddParameter("@Bak_ID", bse_Bak.Bak_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>
/// 添加PCD_Queue对象(即:一条记录)
/// </summary>
public object AddWithReturn(PCD_Queue pCD_Queue)
{
string sql = "INSERT INTO PCD_Queue (PCDO_PlanCode,PCDO_NCode,PCDO_Order,Stat) VALUES (@PCDO_PlanCode,@PCDO_NCode,@PCDO_Order,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(pCD_Queue.PCDO_PlanCode))
{
idb.AddParameter("@PCDO_PlanCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDO_PlanCode", pCD_Queue.PCDO_PlanCode);
}
if (string.IsNullOrEmpty(pCD_Queue.PCDO_NCode))
{
idb.AddParameter("@PCDO_NCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDO_NCode", pCD_Queue.PCDO_NCode);
}
if (pCD_Queue.PCDO_Order == 0)
{
idb.AddParameter("@PCDO_Order", 0);
}
else
{
idb.AddParameter("@PCDO_Order", pCD_Queue.PCDO_Order);
}
if (pCD_Queue.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pCD_Queue.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>
/// 更新设备检修计划 Equ_MPlan对象(即:一条记录
/// </summary>
public int Update(Equ_MPlan equ_MPlan)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Equ_MPlan SET ");
if (equ_MPlan.MP_Code_IsChanged)
{
sbParameter.Append("MP_Code=@MP_Code, ");
}
if (equ_MPlan.MP_Name_IsChanged)
{
sbParameter.Append("MP_Name=@MP_Name, ");
}
if (equ_MPlan.MP_Stuff_IsChanged)
{
sbParameter.Append("MP_Stuff=@MP_Stuff, ");
}
if (equ_MPlan.MP_Start_IsChanged)
{
sbParameter.Append("MP_Start=@MP_Start, ");
}
if (equ_MPlan.MP_End_IsChanged)
{
sbParameter.Append("MP_End=@MP_End, ");
}
if (equ_MPlan.VerifyStuff_IsChanged)
{
sbParameter.Append("VerifyStuff=@VerifyStuff, ");
}
if (equ_MPlan.VerifyStat_IsChanged)
{
sbParameter.Append("VerifyStat=@VerifyStat, ");
}
if (equ_MPlan.VerifyDate_IsChanged)
{
sbParameter.Append("VerifyDate=@VerifyDate, ");
}
if (equ_MPlan.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (equ_MPlan.MP_ECode_IsChanged)
{
sbParameter.Append("MP_ECode=@MP_ECode, ");
}
if (equ_MPlan.MP_EName_IsChanged)
{
sbParameter.Append("MP_EName=@MP_EName ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and MP_ID=@MP_ID; ");
string sql = sb.ToString();
if (equ_MPlan.MP_Code_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.MP_Code))
{
idb.AddParameter("@MP_Code", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Code", equ_MPlan.MP_Code);
}
}
if (equ_MPlan.MP_Name_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.MP_Name))
{
idb.AddParameter("@MP_Name", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Name", equ_MPlan.MP_Name);
}
}
if (equ_MPlan.MP_Stuff_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.MP_Stuff))
{
idb.AddParameter("@MP_Stuff", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Stuff", equ_MPlan.MP_Stuff);
}
}
if (equ_MPlan.MP_Start_IsChanged)
{
if (equ_MPlan.MP_Start == DateTime.MinValue)
{
idb.AddParameter("@MP_Start", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Start", equ_MPlan.MP_Start);
}
}
if (equ_MPlan.MP_End_IsChanged)
{
if (equ_MPlan.MP_End == DateTime.MinValue)
{
idb.AddParameter("@MP_End", DBNull.Value);
}
else
{
idb.AddParameter("@MP_End", equ_MPlan.MP_End);
}
}
if (equ_MPlan.VerifyStuff_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.VerifyStuff))
{
idb.AddParameter("@VerifyStuff", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStuff", equ_MPlan.VerifyStuff);
}
}
if (equ_MPlan.VerifyStat_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.VerifyStat))
{
idb.AddParameter("@VerifyStat", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStat", equ_MPlan.VerifyStat);
}
}
if (equ_MPlan.VerifyDate_IsChanged)
{
if (equ_MPlan.VerifyDate == DateTime.MinValue)
{
idb.AddParameter("@VerifyDate", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyDate", equ_MPlan.VerifyDate);
}
}
if (equ_MPlan.Stat_IsChanged)
{
if (equ_MPlan.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", equ_MPlan.Stat);
}
}
if (equ_MPlan.MP_ECode_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.MP_ECode))
{
idb.AddParameter("@MP_ECode", DBNull.Value);
}
else
{
idb.AddParameter("@MP_ECode", equ_MPlan.MP_ECode);
}
}
if (equ_MPlan.MP_EName_IsChanged)
{
if (string.IsNullOrEmpty(equ_MPlan.MP_EName))
{
idb.AddParameter("@MP_EName", DBNull.Value);
}
else
{
idb.AddParameter("@MP_EName", equ_MPlan.MP_EName);
}
}
idb.AddParameter("@MP_ID", equ_MPlan.MP_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>
/// 添加Bug日志 Sys_BugLog对象(即:一条记录)
/// </summary>
public object AddWithReturn(Sys_BugLog sys_BugLog)
{
string sql = "INSERT INTO Sys_BugLog (SL_Code,SL_OpUser,SL_Date,SL_Status,SL_Owner,Stat) VALUES (@SL_Code,@SL_OpUser,@SL_Date,@SL_Status,@SL_Owner,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(sys_BugLog.SL_Code))
{
idb.AddParameter("@SL_Code", DBNull.Value);
}
else
{
idb.AddParameter("@SL_Code", sys_BugLog.SL_Code);
}
if (string.IsNullOrEmpty(sys_BugLog.SL_OpUser))
{
idb.AddParameter("@SL_OpUser", DBNull.Value);
}
else
{
idb.AddParameter("@SL_OpUser", sys_BugLog.SL_OpUser);
}
if (sys_BugLog.SL_Date == DateTime.MinValue)
{
idb.AddParameter("@SL_Date", DBNull.Value);
}
else
{
idb.AddParameter("@SL_Date", sys_BugLog.SL_Date);
}
if (string.IsNullOrEmpty(sys_BugLog.SL_Status))
{
idb.AddParameter("@SL_Status", DBNull.Value);
}
else
{
idb.AddParameter("@SL_Status", sys_BugLog.SL_Status);
}
if (string.IsNullOrEmpty(sys_BugLog.SL_Owner))
{
idb.AddParameter("@SL_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@SL_Owner", sys_BugLog.SL_Owner);
}
if (sys_BugLog.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_BugLog.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>
/// 添加PC_WError对象(即:一条记录)
/// </summary>
public object AddWithReturn(PC_WError pC_WError)
{
string sql = "INSERT INTO PC_WError (PCWE_Code,PCWE_Module,PCWE_WHCode,PCWE_WHName,PCWE_MCode,PCWE_MName,PCWE_Unit,PCWE_Num,PCWE_Operator,PCWE_OpDate,PCWE_Bak,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@PCWE_Code,@PCWE_Module,@PCWE_WHCode,@PCWE_WHName,@PCWE_MCode,@PCWE_MName,@PCWE_Unit,@PCWE_Num,@PCWE_Operator,@PCWE_OpDate,@PCWE_Bak,@Stat,@CreateDate,@UpdateDate,@DeleteDate);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(pC_WError.PCWE_Code))
{
idb.AddParameter("@PCWE_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_Code", pC_WError.PCWE_Code);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_Module))
{
idb.AddParameter("@PCWE_Module", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_Module", pC_WError.PCWE_Module);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_WHCode))
{
idb.AddParameter("@PCWE_WHCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_WHCode", pC_WError.PCWE_WHCode);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_WHName))
{
idb.AddParameter("@PCWE_WHName", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_WHName", pC_WError.PCWE_WHName);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_MCode))
{
idb.AddParameter("@PCWE_MCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_MCode", pC_WError.PCWE_MCode);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_MName))
{
idb.AddParameter("@PCWE_MName", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_MName", pC_WError.PCWE_MName);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_Unit))
{
idb.AddParameter("@PCWE_Unit", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_Unit", pC_WError.PCWE_Unit);
}
if (pC_WError.PCWE_Num == 0)
{
idb.AddParameter("@PCWE_Num", 0);
}
else
{
idb.AddParameter("@PCWE_Num", pC_WError.PCWE_Num);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_Operator))
{
idb.AddParameter("@PCWE_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_Operator", pC_WError.PCWE_Operator);
}
if (pC_WError.PCWE_OpDate == DateTime.MinValue)
{
idb.AddParameter("@PCWE_OpDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_OpDate", pC_WError.PCWE_OpDate);
}
if (string.IsNullOrEmpty(pC_WError.PCWE_Bak))
{
idb.AddParameter("@PCWE_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCWE_Bak", pC_WError.PCWE_Bak);
}
if (pC_WError.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_WError.Stat);
}
if (pC_WError.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_WError.CreateDate);
}
if (pC_WError.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_WError.UpdateDate);
}
if (pC_WError.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_WError.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>
/// 添加车辆事件表 PCT_Event对象(即:一条记录)
/// </summary>
public object AddWithReturn(PCT_Event pCT_Event)
{
string sql = "INSERT INTO PCT_Event (PCTE_Code,PCTE_CCode,PCTE_CNo,PCTE_Description,PCTE_BeginDate,PCTE_EndDate,PCTE_EventType,PCTE_DCode,PCTE_Join,PCTE_Cost,PCTE_Before,PCTE_After,PCTE_Address,Stat,CreateDate,UpdateDate,DeleteDate,PCTE_iType,PCTE_TCode,PCTE_Udef2,PCTE_Udef3,PCTE_Udef4,PCTE_Udef5) VALUES (@PCTE_Code,@PCTE_CCode,@PCTE_CNo,@PCTE_Description,@PCTE_BeginDate,@PCTE_EndDate,@PCTE_EventType,@PCTE_DCode,@PCTE_Join,@PCTE_Cost,@PCTE_Before,@PCTE_After,@PCTE_Address,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@PCTE_iType,@PCTE_TCode,@PCTE_Udef2,@PCTE_Udef3,@PCTE_Udef4,@PCTE_Udef5);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(pCT_Event.PCTE_Code))
{
idb.AddParameter("@PCTE_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Code", pCT_Event.PCTE_Code);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_CCode))
{
idb.AddParameter("@PCTE_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_CCode", pCT_Event.PCTE_CCode);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_CNo))
{
idb.AddParameter("@PCTE_CNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_CNo", pCT_Event.PCTE_CNo);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Description))
{
idb.AddParameter("@PCTE_Description", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Description", pCT_Event.PCTE_Description);
}
if (pCT_Event.PCTE_BeginDate == DateTime.MinValue)
{
idb.AddParameter("@PCTE_BeginDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_BeginDate", pCT_Event.PCTE_BeginDate);
}
if (pCT_Event.PCTE_EndDate == DateTime.MinValue)
{
idb.AddParameter("@PCTE_EndDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_EndDate", pCT_Event.PCTE_EndDate);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_EventType))
{
idb.AddParameter("@PCTE_EventType", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_EventType", pCT_Event.PCTE_EventType);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_DCode))
{
idb.AddParameter("@PCTE_DCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_DCode", pCT_Event.PCTE_DCode);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Join))
{
idb.AddParameter("@PCTE_Join", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Join", pCT_Event.PCTE_Join);
}
if (pCT_Event.PCTE_Cost == 0)
{
idb.AddParameter("@PCTE_Cost", 0);
}
else
{
idb.AddParameter("@PCTE_Cost", pCT_Event.PCTE_Cost);
}
if (pCT_Event.PCTE_Before == 0)
{
idb.AddParameter("@PCTE_Before", 0);
}
else
{
idb.AddParameter("@PCTE_Before", pCT_Event.PCTE_Before);
}
if (pCT_Event.PCTE_After == 0)
{
idb.AddParameter("@PCTE_After", 0);
}
else
{
idb.AddParameter("@PCTE_After", pCT_Event.PCTE_After);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Address))
{
idb.AddParameter("@PCTE_Address", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Address", pCT_Event.PCTE_Address);
}
if (pCT_Event.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pCT_Event.Stat);
}
if (pCT_Event.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pCT_Event.CreateDate);
}
if (pCT_Event.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pCT_Event.UpdateDate);
}
if (pCT_Event.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pCT_Event.DeleteDate);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_iType))
{
idb.AddParameter("@PCTE_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_iType", pCT_Event.PCTE_iType);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_TCode))
{
idb.AddParameter("@PCTE_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_TCode", pCT_Event.PCTE_TCode);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef2))
{
idb.AddParameter("@PCTE_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef2", pCT_Event.PCTE_Udef2);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef3))
{
idb.AddParameter("@PCTE_Udef3", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef3", pCT_Event.PCTE_Udef3);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef4))
{
idb.AddParameter("@PCTE_Udef4", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef4", pCT_Event.PCTE_Udef4);
}
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef5))
{
idb.AddParameter("@PCTE_Udef5", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef5", pCT_Event.PCTE_Udef5);
}
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>
/// 更新Bug管理系统 Sys_Bug对象(即:一条记录
/// </summary>
public int Update(Sys_Bug sys_Bug)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Sys_Bug SET ");
if (sys_Bug.Sys_Code_IsChanged)
{
sbParameter.Append("Sys_Code=@Sys_Code, ");
}
if (sys_Bug.Sys_Date_IsChanged)
{
sbParameter.Append("Sys_Date=@Sys_Date, ");
}
if (sys_Bug.Sys_Title_IsChanged)
{
sbParameter.Append("Sys_Title=@Sys_Title, ");
}
if (sys_Bug.Sys_Des_IsChanged)
{
sbParameter.Append("Sys_Des=@Sys_Des, ");
}
if (sys_Bug.Sys_Project_IsChanged)
{
sbParameter.Append("Sys_Project=@Sys_Project, ");
}
if (sys_Bug.Sys_Module_IsChanged)
{
sbParameter.Append("Sys_Module=@Sys_Module, ");
}
if (sys_Bug.Sys_UserCode_IsChanged)
{
sbParameter.Append("Sys_UserCode=@Sys_UserCode, ");
}
if (sys_Bug.Sys_UserName_IsChanged)
{
sbParameter.Append("Sys_UserName=@Sys_UserName, ");
}
if (sys_Bug.Sys_Owner_IsChanged)
{
sbParameter.Append("Sys_Owner=@Sys_Owner, ");
}
if (sys_Bug.Sys_OpUser_IsChanged)
{
sbParameter.Append("Sys_OpUser=@Sys_OpUser, ");
}
if (sys_Bug.Sys_Status_IsChanged)
{
sbParameter.Append("Sys_Status=@Sys_Status, ");
}
if (sys_Bug.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 Sys_ID=@Sys_ID; ");
string sql = sb.ToString();
if (sys_Bug.Sys_Code_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Code))
{
idb.AddParameter("@Sys_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Code", sys_Bug.Sys_Code);
}
}
if (sys_Bug.Sys_Date_IsChanged)
{
if (sys_Bug.Sys_Date == DateTime.MinValue)
{
idb.AddParameter("@Sys_Date", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Date", sys_Bug.Sys_Date);
}
}
if (sys_Bug.Sys_Title_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Title))
{
idb.AddParameter("@Sys_Title", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Title", sys_Bug.Sys_Title);
}
}
if (sys_Bug.Sys_Des_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Des))
{
idb.AddParameter("@Sys_Des", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Des", sys_Bug.Sys_Des);
}
}
if (sys_Bug.Sys_Project_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Project))
{
idb.AddParameter("@Sys_Project", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Project", sys_Bug.Sys_Project);
}
}
if (sys_Bug.Sys_Module_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Module))
{
idb.AddParameter("@Sys_Module", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Module", sys_Bug.Sys_Module);
}
}
if (sys_Bug.Sys_UserCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_UserCode))
{
idb.AddParameter("@Sys_UserCode", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_UserCode", sys_Bug.Sys_UserCode);
}
}
if (sys_Bug.Sys_UserName_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_UserName))
{
idb.AddParameter("@Sys_UserName", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_UserName", sys_Bug.Sys_UserName);
}
}
if (sys_Bug.Sys_Owner_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Owner))
{
idb.AddParameter("@Sys_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Owner", sys_Bug.Sys_Owner);
}
}
if (sys_Bug.Sys_OpUser_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_OpUser))
{
idb.AddParameter("@Sys_OpUser", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_OpUser", sys_Bug.Sys_OpUser);
}
}
if (sys_Bug.Sys_Status_IsChanged)
{
if (string.IsNullOrEmpty(sys_Bug.Sys_Status))
{
idb.AddParameter("@Sys_Status", DBNull.Value);
}
else
{
idb.AddParameter("@Sys_Status", sys_Bug.Sys_Status);
}
}
if (sys_Bug.Stat_IsChanged)
{
if (sys_Bug.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Bug.Stat);
}
}
idb.AddParameter("@Sys_ID", sys_Bug.Sys_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>
/// 更新车辆事件表 PCT_Event对象(即:一条记录
/// </summary>
public int Update(PCT_Event pCT_Event)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE PCT_Event SET ");
if (pCT_Event.PCTE_Code_IsChanged)
{
sbParameter.Append("PCTE_Code=@PCTE_Code, ");
}
if (pCT_Event.PCTE_CCode_IsChanged)
{
sbParameter.Append("PCTE_CCode=@PCTE_CCode, ");
}
if (pCT_Event.PCTE_CNo_IsChanged)
{
sbParameter.Append("PCTE_CNo=@PCTE_CNo, ");
}
if (pCT_Event.PCTE_Description_IsChanged)
{
sbParameter.Append("PCTE_Description=@PCTE_Description, ");
}
if (pCT_Event.PCTE_BeginDate_IsChanged)
{
sbParameter.Append("PCTE_BeginDate=@PCTE_BeginDate, ");
}
if (pCT_Event.PCTE_EndDate_IsChanged)
{
sbParameter.Append("PCTE_EndDate=@PCTE_EndDate, ");
}
if (pCT_Event.PCTE_EventType_IsChanged)
{
sbParameter.Append("PCTE_EventType=@PCTE_EventType, ");
}
if (pCT_Event.PCTE_DCode_IsChanged)
{
sbParameter.Append("PCTE_DCode=@PCTE_DCode, ");
}
if (pCT_Event.PCTE_Join_IsChanged)
{
sbParameter.Append("PCTE_Join=@PCTE_Join, ");
}
if (pCT_Event.PCTE_Cost_IsChanged)
{
sbParameter.Append("PCTE_Cost=@PCTE_Cost, ");
}
if (pCT_Event.PCTE_Before_IsChanged)
{
sbParameter.Append("PCTE_Before=@PCTE_Before, ");
}
if (pCT_Event.PCTE_After_IsChanged)
{
sbParameter.Append("PCTE_After=@PCTE_After, ");
}
if (pCT_Event.PCTE_Address_IsChanged)
{
sbParameter.Append("PCTE_Address=@PCTE_Address, ");
}
if (pCT_Event.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (pCT_Event.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (pCT_Event.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (pCT_Event.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (pCT_Event.PCTE_iType_IsChanged)
{
sbParameter.Append("PCTE_iType=@PCTE_iType, ");
}
if (pCT_Event.PCTE_TCode_IsChanged)
{
sbParameter.Append("PCTE_TCode=@PCTE_TCode, ");
}
if (pCT_Event.PCTE_Udef2_IsChanged)
{
sbParameter.Append("PCTE_Udef2=@PCTE_Udef2, ");
}
if (pCT_Event.PCTE_Udef3_IsChanged)
{
sbParameter.Append("PCTE_Udef3=@PCTE_Udef3, ");
}
if (pCT_Event.PCTE_Udef4_IsChanged)
{
sbParameter.Append("PCTE_Udef4=@PCTE_Udef4, ");
}
if (pCT_Event.PCTE_Udef5_IsChanged)
{
sbParameter.Append("PCTE_Udef5=@PCTE_Udef5 ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PCTE_ID=@PCTE_ID; ");
string sql = sb.ToString();
if (pCT_Event.PCTE_Code_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Code))
{
idb.AddParameter("@PCTE_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Code", pCT_Event.PCTE_Code);
}
}
if (pCT_Event.PCTE_CCode_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_CCode))
{
idb.AddParameter("@PCTE_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_CCode", pCT_Event.PCTE_CCode);
}
}
if (pCT_Event.PCTE_CNo_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_CNo))
{
idb.AddParameter("@PCTE_CNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_CNo", pCT_Event.PCTE_CNo);
}
}
if (pCT_Event.PCTE_Description_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Description))
{
idb.AddParameter("@PCTE_Description", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Description", pCT_Event.PCTE_Description);
}
}
if (pCT_Event.PCTE_BeginDate_IsChanged)
{
if (pCT_Event.PCTE_BeginDate == DateTime.MinValue)
{
idb.AddParameter("@PCTE_BeginDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_BeginDate", pCT_Event.PCTE_BeginDate);
}
}
if (pCT_Event.PCTE_EndDate_IsChanged)
{
if (pCT_Event.PCTE_EndDate == DateTime.MinValue)
{
idb.AddParameter("@PCTE_EndDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_EndDate", pCT_Event.PCTE_EndDate);
}
}
if (pCT_Event.PCTE_EventType_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_EventType))
{
idb.AddParameter("@PCTE_EventType", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_EventType", pCT_Event.PCTE_EventType);
}
}
if (pCT_Event.PCTE_DCode_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_DCode))
{
idb.AddParameter("@PCTE_DCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_DCode", pCT_Event.PCTE_DCode);
}
}
if (pCT_Event.PCTE_Join_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Join))
{
idb.AddParameter("@PCTE_Join", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Join", pCT_Event.PCTE_Join);
}
}
if (pCT_Event.PCTE_Cost_IsChanged)
{
if (pCT_Event.PCTE_Cost == 0)
{
idb.AddParameter("@PCTE_Cost", 0);
}
else
{
idb.AddParameter("@PCTE_Cost", pCT_Event.PCTE_Cost);
}
}
if (pCT_Event.PCTE_Before_IsChanged)
{
if (pCT_Event.PCTE_Before == 0)
{
idb.AddParameter("@PCTE_Before", 0);
}
else
{
idb.AddParameter("@PCTE_Before", pCT_Event.PCTE_Before);
}
}
if (pCT_Event.PCTE_After_IsChanged)
{
if (pCT_Event.PCTE_After == 0)
{
idb.AddParameter("@PCTE_After", 0);
}
else
{
idb.AddParameter("@PCTE_After", pCT_Event.PCTE_After);
}
}
if (pCT_Event.PCTE_Address_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Address))
{
idb.AddParameter("@PCTE_Address", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Address", pCT_Event.PCTE_Address);
}
}
if (pCT_Event.Stat_IsChanged)
{
if (pCT_Event.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pCT_Event.Stat);
}
}
if (pCT_Event.CreateDate_IsChanged)
{
if (pCT_Event.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pCT_Event.CreateDate);
}
}
if (pCT_Event.UpdateDate_IsChanged)
{
if (pCT_Event.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pCT_Event.UpdateDate);
}
}
if (pCT_Event.DeleteDate_IsChanged)
{
if (pCT_Event.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pCT_Event.DeleteDate);
}
}
if (pCT_Event.PCTE_iType_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_iType))
{
idb.AddParameter("@PCTE_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_iType", pCT_Event.PCTE_iType);
}
}
if (pCT_Event.PCTE_TCode_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_TCode))
{
idb.AddParameter("@PCTE_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_TCode", pCT_Event.PCTE_TCode);
}
}
if (pCT_Event.PCTE_Udef2_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef2))
{
idb.AddParameter("@PCTE_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef2", pCT_Event.PCTE_Udef2);
}
}
if (pCT_Event.PCTE_Udef3_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef3))
{
idb.AddParameter("@PCTE_Udef3", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef3", pCT_Event.PCTE_Udef3);
}
}
if (pCT_Event.PCTE_Udef4_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef4))
{
idb.AddParameter("@PCTE_Udef4", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef4", pCT_Event.PCTE_Udef4);
}
}
if (pCT_Event.PCTE_Udef5_IsChanged)
{
if (string.IsNullOrEmpty(pCT_Event.PCTE_Udef5))
{
idb.AddParameter("@PCTE_Udef5", DBNull.Value);
}
else
{
idb.AddParameter("@PCTE_Udef5", pCT_Event.PCTE_Udef5);
}
}
idb.AddParameter("@PCTE_ID", pCT_Event.PCTE_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_MaterialType对象(即:一条记录)
/// </summary>
public int Add(WH_MaterialType wH_MaterialType)
{
string sql = "INSERT INTO WH_MaterialType (MT_Code,MT_TCode,MT_TName,MT_Company,MT_CompanyCode,MT_Dept,MT_DeptCode,Stat,MT_Status,CreateDate,UpdateDate,DeleteDate,MT_Itype,MT_Type,MT_Employee,MT_EmployeeName,MT_TPCode,MT_Order) VALUES (@MT_Code,@MT_TCode,@MT_TName,@MT_Company,@MT_CompanyCode,@MT_Dept,@MT_DeptCode,@Stat,@MT_Status,@CreateDate,@UpdateDate,@DeleteDate,@MT_Itype,@MT_Type,@MT_Employee,@MT_EmployeeName,@MT_TPCode,@MT_Order)";
if (string.IsNullOrEmpty(wH_MaterialType.MT_Code))
{
idb.AddParameter("@MT_Code", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Code", wH_MaterialType.MT_Code);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_TCode))
{
idb.AddParameter("@MT_TCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_TCode", wH_MaterialType.MT_TCode);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_TName))
{
idb.AddParameter("@MT_TName", DBNull.Value);
}
else
{
idb.AddParameter("@MT_TName", wH_MaterialType.MT_TName);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_Company))
{
idb.AddParameter("@MT_Company", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Company", wH_MaterialType.MT_Company);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_CompanyCode))
{
idb.AddParameter("@MT_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_CompanyCode", wH_MaterialType.MT_CompanyCode);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_Dept))
{
idb.AddParameter("@MT_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Dept", wH_MaterialType.MT_Dept);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_DeptCode))
{
idb.AddParameter("@MT_DeptCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_DeptCode", wH_MaterialType.MT_DeptCode);
}
if (wH_MaterialType.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", wH_MaterialType.Stat);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_Status))
{
idb.AddParameter("@MT_Status", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Status", wH_MaterialType.MT_Status);
}
if (wH_MaterialType.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", wH_MaterialType.CreateDate);
}
if (wH_MaterialType.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", wH_MaterialType.UpdateDate);
}
if (wH_MaterialType.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", wH_MaterialType.DeleteDate);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_Itype))
{
idb.AddParameter("@MT_Itype", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Itype", wH_MaterialType.MT_Itype);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_Type))
{
idb.AddParameter("@MT_Type", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Type", wH_MaterialType.MT_Type);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_Employee))
{
idb.AddParameter("@MT_Employee", DBNull.Value);
}
else
{
idb.AddParameter("@MT_Employee", wH_MaterialType.MT_Employee);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_EmployeeName))
{
idb.AddParameter("@MT_EmployeeName", DBNull.Value);
}
else
{
idb.AddParameter("@MT_EmployeeName", wH_MaterialType.MT_EmployeeName);
}
if (string.IsNullOrEmpty(wH_MaterialType.MT_TPCode))
{
idb.AddParameter("@MT_TPCode", DBNull.Value);
}
else
{
idb.AddParameter("@MT_TPCode", wH_MaterialType.MT_TPCode);
}
if (wH_MaterialType.MT_Order == 0)
{
idb.AddParameter("@MT_Order", 0);
}
else
{
idb.AddParameter("@MT_Order", wH_MaterialType.MT_Order);
}
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_Contacts对象(即:一条记录)
/// </summary>
public object AddWithReturn(Bse_Contacts bse_Contacts)
{
string sql = "INSERT INTO Bse_Contacts (Module_Code,Record_ID,BContact_Name,BContact_Tel1,BContact_Tel2,BContact_Fax,BContact_Addr,BContact_Email,BContact_Duty,BContact_Gender,BContact_Career,BContact_Birth,BContact_From,BContact_IsDefault,CreateDate,Creator,BContact_Bak1,BContact_Bak2,Stat,BContact_Code,UpdateDate,DeleteDate) VALUES (@Module_Code,@Record_ID,@BContact_Name,@BContact_Tel1,@BContact_Tel2,@BContact_Fax,@BContact_Addr,@BContact_Email,@BContact_Duty,@BContact_Gender,@BContact_Career,@BContact_Birth,@BContact_From,@BContact_IsDefault,@CreateDate,@Creator,@BContact_Bak1,@BContact_Bak2,@Stat,@BContact_Code,@UpdateDate,@DeleteDate);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(bse_Contacts.Module_Code))
{
idb.AddParameter("@Module_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Module_Code", bse_Contacts.Module_Code);
}
if (string.IsNullOrEmpty(bse_Contacts.Record_ID))
{
idb.AddParameter("@Record_ID", DBNull.Value);
}
else
{
idb.AddParameter("@Record_ID", bse_Contacts.Record_ID);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Name))
{
idb.AddParameter("@BContact_Name", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Name", bse_Contacts.BContact_Name);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Tel1))
{
idb.AddParameter("@BContact_Tel1", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Tel1", bse_Contacts.BContact_Tel1);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Tel2))
{
idb.AddParameter("@BContact_Tel2", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Tel2", bse_Contacts.BContact_Tel2);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Fax))
{
idb.AddParameter("@BContact_Fax", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Fax", bse_Contacts.BContact_Fax);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Addr))
{
idb.AddParameter("@BContact_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Addr", bse_Contacts.BContact_Addr);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Email))
{
idb.AddParameter("@BContact_Email", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Email", bse_Contacts.BContact_Email);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Duty))
{
idb.AddParameter("@BContact_Duty", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Duty", bse_Contacts.BContact_Duty);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Gender))
{
idb.AddParameter("@BContact_Gender", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Gender", bse_Contacts.BContact_Gender);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Career))
{
idb.AddParameter("@BContact_Career", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Career", bse_Contacts.BContact_Career);
}
if (bse_Contacts.BContact_Birth == DateTime.MinValue)
{
idb.AddParameter("@BContact_Birth", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Birth", bse_Contacts.BContact_Birth);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_From))
{
idb.AddParameter("@BContact_From", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_From", bse_Contacts.BContact_From);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_IsDefault))
{
idb.AddParameter("@BContact_IsDefault", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_IsDefault", bse_Contacts.BContact_IsDefault);
}
if (bse_Contacts.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_Contacts.CreateDate);
}
if (string.IsNullOrEmpty(bse_Contacts.Creator))
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", bse_Contacts.Creator);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Bak1))
{
idb.AddParameter("@BContact_Bak1", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Bak1", bse_Contacts.BContact_Bak1);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Bak2))
{
idb.AddParameter("@BContact_Bak2", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Bak2", bse_Contacts.BContact_Bak2);
}
if (bse_Contacts.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Contacts.Stat);
}
if (string.IsNullOrEmpty(bse_Contacts.BContact_Code))
{
idb.AddParameter("@BContact_Code", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Code", bse_Contacts.BContact_Code);
}
if (bse_Contacts.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_Contacts.UpdateDate);
}
if (bse_Contacts.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_Contacts.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>
/// 添加搅拌站信息 PC_BStation对象(即:一条记录)
/// </summary>
public int Add(PC_BStation pC_BStation)
{
string sql = "INSERT INTO PC_BStation (PCBS_Code,PCBS_Name,PCBS_Addr,PCBS_Start,PCBS_Status,PCBS_Bak,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@PCBS_Code,@PCBS_Name,@PCBS_Addr,@PCBS_Start,@PCBS_Status,@PCBS_Bak,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(pC_BStation.PCBS_Code))
{
idb.AddParameter("@PCBS_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Code", pC_BStation.PCBS_Code);
}
if (string.IsNullOrEmpty(pC_BStation.PCBS_Name))
{
idb.AddParameter("@PCBS_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Name", pC_BStation.PCBS_Name);
}
if (string.IsNullOrEmpty(pC_BStation.PCBS_Addr))
{
idb.AddParameter("@PCBS_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Addr", pC_BStation.PCBS_Addr);
}
if (pC_BStation.PCBS_Start == DateTime.MinValue)
{
idb.AddParameter("@PCBS_Start", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Start", pC_BStation.PCBS_Start);
}
if (string.IsNullOrEmpty(pC_BStation.PCBS_Status))
{
idb.AddParameter("@PCBS_Status", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Status", pC_BStation.PCBS_Status);
}
if (string.IsNullOrEmpty(pC_BStation.PCBS_Bak))
{
idb.AddParameter("@PCBS_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCBS_Bak", pC_BStation.PCBS_Bak);
}
if (pC_BStation.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_BStation.Stat);
}
if (pC_BStation.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_BStation.CreateDate);
}
if (pC_BStation.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_BStation.UpdateDate);
}
if (pC_BStation.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_BStation.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_Contacts对象(即:一条记录
/// </summary>
public int Update(Bse_Contacts bse_Contacts)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_Contacts SET ");
if (bse_Contacts.Module_Code_IsChanged)
{
sbParameter.Append("Module_Code=@Module_Code, ");
}
if (bse_Contacts.Record_ID_IsChanged)
{
sbParameter.Append("Record_ID=@Record_ID, ");
}
if (bse_Contacts.BContact_Name_IsChanged)
{
sbParameter.Append("BContact_Name=@BContact_Name, ");
}
if (bse_Contacts.BContact_Tel1_IsChanged)
{
sbParameter.Append("BContact_Tel1=@BContact_Tel1, ");
}
if (bse_Contacts.BContact_Tel2_IsChanged)
{
sbParameter.Append("BContact_Tel2=@BContact_Tel2, ");
}
if (bse_Contacts.BContact_Fax_IsChanged)
{
sbParameter.Append("BContact_Fax=@BContact_Fax, ");
}
if (bse_Contacts.BContact_Addr_IsChanged)
{
sbParameter.Append("BContact_Addr=@BContact_Addr, ");
}
if (bse_Contacts.BContact_Email_IsChanged)
{
sbParameter.Append("BContact_Email=@BContact_Email, ");
}
if (bse_Contacts.BContact_Duty_IsChanged)
{
sbParameter.Append("BContact_Duty=@BContact_Duty, ");
}
if (bse_Contacts.BContact_Gender_IsChanged)
{
sbParameter.Append("BContact_Gender=@BContact_Gender, ");
}
if (bse_Contacts.BContact_Career_IsChanged)
{
sbParameter.Append("BContact_Career=@BContact_Career, ");
}
if (bse_Contacts.BContact_Birth_IsChanged)
{
sbParameter.Append("BContact_Birth=@BContact_Birth, ");
}
if (bse_Contacts.BContact_From_IsChanged)
{
sbParameter.Append("BContact_From=@BContact_From, ");
}
if (bse_Contacts.BContact_IsDefault_IsChanged)
{
sbParameter.Append("BContact_IsDefault=@BContact_IsDefault, ");
}
if (bse_Contacts.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (bse_Contacts.Creator_IsChanged)
{
sbParameter.Append("Creator=@Creator, ");
}
if (bse_Contacts.BContact_Bak1_IsChanged)
{
sbParameter.Append("BContact_Bak1=@BContact_Bak1, ");
}
if (bse_Contacts.BContact_Bak2_IsChanged)
{
sbParameter.Append("BContact_Bak2=@BContact_Bak2, ");
}
if (bse_Contacts.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (bse_Contacts.BContact_Code_IsChanged)
{
sbParameter.Append("BContact_Code=@BContact_Code, ");
}
if (bse_Contacts.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (bse_Contacts.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 BContact_ID=@BContact_ID; ");
string sql = sb.ToString();
if (bse_Contacts.Module_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.Module_Code))
{
idb.AddParameter("@Module_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Module_Code", bse_Contacts.Module_Code);
}
}
if (bse_Contacts.Record_ID_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.Record_ID))
{
idb.AddParameter("@Record_ID", DBNull.Value);
}
else
{
idb.AddParameter("@Record_ID", bse_Contacts.Record_ID);
}
}
if (bse_Contacts.BContact_Name_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Name))
{
idb.AddParameter("@BContact_Name", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Name", bse_Contacts.BContact_Name);
}
}
if (bse_Contacts.BContact_Tel1_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Tel1))
{
idb.AddParameter("@BContact_Tel1", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Tel1", bse_Contacts.BContact_Tel1);
}
}
if (bse_Contacts.BContact_Tel2_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Tel2))
{
idb.AddParameter("@BContact_Tel2", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Tel2", bse_Contacts.BContact_Tel2);
}
}
if (bse_Contacts.BContact_Fax_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Fax))
{
idb.AddParameter("@BContact_Fax", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Fax", bse_Contacts.BContact_Fax);
}
}
if (bse_Contacts.BContact_Addr_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Addr))
{
idb.AddParameter("@BContact_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Addr", bse_Contacts.BContact_Addr);
}
}
if (bse_Contacts.BContact_Email_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Email))
{
idb.AddParameter("@BContact_Email", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Email", bse_Contacts.BContact_Email);
}
}
if (bse_Contacts.BContact_Duty_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Duty))
{
idb.AddParameter("@BContact_Duty", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Duty", bse_Contacts.BContact_Duty);
}
}
if (bse_Contacts.BContact_Gender_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Gender))
{
idb.AddParameter("@BContact_Gender", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Gender", bse_Contacts.BContact_Gender);
}
}
if (bse_Contacts.BContact_Career_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Career))
{
idb.AddParameter("@BContact_Career", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Career", bse_Contacts.BContact_Career);
}
}
if (bse_Contacts.BContact_Birth_IsChanged)
{
if (bse_Contacts.BContact_Birth == DateTime.MinValue)
{
idb.AddParameter("@BContact_Birth", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Birth", bse_Contacts.BContact_Birth);
}
}
if (bse_Contacts.BContact_From_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_From))
{
idb.AddParameter("@BContact_From", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_From", bse_Contacts.BContact_From);
}
}
if (bse_Contacts.BContact_IsDefault_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_IsDefault))
{
idb.AddParameter("@BContact_IsDefault", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_IsDefault", bse_Contacts.BContact_IsDefault);
}
}
if (bse_Contacts.CreateDate_IsChanged)
{
if (bse_Contacts.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_Contacts.CreateDate);
}
}
if (bse_Contacts.Creator_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.Creator))
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", bse_Contacts.Creator);
}
}
if (bse_Contacts.BContact_Bak1_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Bak1))
{
idb.AddParameter("@BContact_Bak1", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Bak1", bse_Contacts.BContact_Bak1);
}
}
if (bse_Contacts.BContact_Bak2_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Bak2))
{
idb.AddParameter("@BContact_Bak2", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Bak2", bse_Contacts.BContact_Bak2);
}
}
if (bse_Contacts.Stat_IsChanged)
{
if (bse_Contacts.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Contacts.Stat);
}
}
if (bse_Contacts.BContact_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Contacts.BContact_Code))
{
idb.AddParameter("@BContact_Code", DBNull.Value);
}
else
{
idb.AddParameter("@BContact_Code", bse_Contacts.BContact_Code);
}
}
if (bse_Contacts.UpdateDate_IsChanged)
{
if (bse_Contacts.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_Contacts.UpdateDate);
}
}
if (bse_Contacts.DeleteDate_IsChanged)
{
if (bse_Contacts.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_Contacts.DeleteDate);
}
}
idb.AddParameter("@BContact_ID", bse_Contacts.BContact_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>
/// 更新审核阶段信息 Verify_Nodes对象(即:一条记录
/// </summary>
public int Update(Verify_Nodes verify_Nodes)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Verify_Nodes SET ");
if (verify_Nodes.VerifyNode_Code_IsChanged)
{
sbParameter.Append("VerifyNode_Code=@VerifyNode_Code, ");
}
if (verify_Nodes.VerifyNode_Name_IsChanged)
{
sbParameter.Append("VerifyNode_Name=@VerifyNode_Name, ");
}
if (verify_Nodes.VerifyNode_Remark_IsChanged)
{
sbParameter.Append("VerifyNode_Remark=@VerifyNode_Remark, ");
}
if (verify_Nodes.VerifyNode_AuditNum_IsChanged)
{
sbParameter.Append("VerifyNode_AuditNum=@VerifyNode_AuditNum, ");
}
if (verify_Nodes.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 VerifyNode_ID=@VerifyNode_ID; ");
string sql = sb.ToString();
if (verify_Nodes.VerifyNode_Code_IsChanged)
{
if (string.IsNullOrEmpty(verify_Nodes.VerifyNode_Code))
{
idb.AddParameter("@VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyNode_Code", verify_Nodes.VerifyNode_Code);
}
}
if (verify_Nodes.VerifyNode_Name_IsChanged)
{
if (string.IsNullOrEmpty(verify_Nodes.VerifyNode_Name))
{
idb.AddParameter("@VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyNode_Name", verify_Nodes.VerifyNode_Name);
}
}
if (verify_Nodes.VerifyNode_Remark_IsChanged)
{
if (string.IsNullOrEmpty(verify_Nodes.VerifyNode_Remark))
{
idb.AddParameter("@VerifyNode_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyNode_Remark", verify_Nodes.VerifyNode_Remark);
}
}
if (verify_Nodes.VerifyNode_AuditNum_IsChanged)
{
if (verify_Nodes.VerifyNode_AuditNum == 0)
{
idb.AddParameter("@VerifyNode_AuditNum", 0);
}
else
{
idb.AddParameter("@VerifyNode_AuditNum", verify_Nodes.VerifyNode_AuditNum);
}
}
if (verify_Nodes.Stat_IsChanged)
{
if (verify_Nodes.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_Nodes.Stat);
}
}
idb.AddParameter("@VerifyNode_ID", verify_Nodes.VerifyNode_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>
/// 添加审核模板配置表 Verify_TemplateConfig对象(即:一条记录)
/// </summary>
public int Add(Verify_TemplateConfig verify_TemplateConfig)
{
string sql = "INSERT INTO Verify_TemplateConfig (VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode) VALUES (@VT_Template_Code,@VT_Key,@VT_VerifyNode_Code,@VT_VerifyNode_Name,@Flag,@VT_VerifyNode_Order,@VT_VerifyNode_Back,@VT_VerifyNode_BackName,@VT_Remark,@Stat,@VT_AcSum,@VT_AcNodeName,@VT_AcNodeCode)";
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Template_Code))
{
idb.AddParameter("@VT_Template_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Template_Code", verify_TemplateConfig.VT_Template_Code);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Key))
{
idb.AddParameter("@VT_Key", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Key", verify_TemplateConfig.VT_Key);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Code))
{
idb.AddParameter("@VT_VerifyNode_Code", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Code", verify_TemplateConfig.VT_VerifyNode_Code);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Name))
{
idb.AddParameter("@VT_VerifyNode_Name", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Name", verify_TemplateConfig.VT_VerifyNode_Name);
}
if (verify_TemplateConfig.Flag == 0)
{
idb.AddParameter("@Flag", 0);
}
else
{
idb.AddParameter("@Flag", verify_TemplateConfig.Flag);
}
if (verify_TemplateConfig.VT_VerifyNode_Order == 0)
{
idb.AddParameter("@VT_VerifyNode_Order", 0);
}
else
{
idb.AddParameter("@VT_VerifyNode_Order", verify_TemplateConfig.VT_VerifyNode_Order);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_Back))
{
idb.AddParameter("@VT_VerifyNode_Back", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_Back", verify_TemplateConfig.VT_VerifyNode_Back);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_VerifyNode_BackName))
{
idb.AddParameter("@VT_VerifyNode_BackName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_VerifyNode_BackName", verify_TemplateConfig.VT_VerifyNode_BackName);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_Remark))
{
idb.AddParameter("@VT_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@VT_Remark", verify_TemplateConfig.VT_Remark);
}
if (verify_TemplateConfig.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", verify_TemplateConfig.Stat);
}
if (verify_TemplateConfig.VT_AcSum == 0)
{
idb.AddParameter("@VT_AcSum", 0);
}
else
{
idb.AddParameter("@VT_AcSum", verify_TemplateConfig.VT_AcSum);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeName))
{
idb.AddParameter("@VT_AcNodeName", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeName", verify_TemplateConfig.VT_AcNodeName);
}
if (string.IsNullOrEmpty(verify_TemplateConfig.VT_AcNodeCode))
{
idb.AddParameter("@VT_AcNodeCode", DBNull.Value);
}
else
{
idb.AddParameter("@VT_AcNodeCode", verify_TemplateConfig.VT_AcNodeCode);
}
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>
/// 更新系统消息处理日志 Sys_AnnoceLog对象(即:一条记录
/// </summary>
public int Update(Sys_AnnoceLog sys_AnnoceLog)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Sys_AnnoceLog SET ");
if (sys_AnnoceLog.EL_UserCode_IsChanged)
{
sbParameter.Append("EL_UserCode=@EL_UserCode, ");
}
if (sys_AnnoceLog.EL_Date_IsChanged)
{
sbParameter.Append("EL_Date=@EL_Date, ");
}
if (sys_AnnoceLog.EL_IP_IsChanged)
{
sbParameter.Append("EL_IP=@EL_IP ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and EL_ID=@EL_ID; ");
string sql = sb.ToString();
if (sys_AnnoceLog.EL_UserCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_AnnoceLog.EL_UserCode))
{
idb.AddParameter("@EL_UserCode", DBNull.Value);
}
else
{
idb.AddParameter("@EL_UserCode", sys_AnnoceLog.EL_UserCode);
}
}
if (sys_AnnoceLog.EL_Date_IsChanged)
{
if (sys_AnnoceLog.EL_Date == DateTime.MinValue)
{
idb.AddParameter("@EL_Date", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Date", sys_AnnoceLog.EL_Date);
}
}
if (sys_AnnoceLog.EL_IP_IsChanged)
{
if (string.IsNullOrEmpty(sys_AnnoceLog.EL_IP))
{
idb.AddParameter("@EL_IP", DBNull.Value);
}
else
{
idb.AddParameter("@EL_IP", sys_AnnoceLog.EL_IP);
}
}
idb.AddParameter("@EL_ID", sys_AnnoceLog.EL_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_MPlan对象(即:一条记录)
/// </summary>
public int Add(Equ_MPlan equ_MPlan)
{
string sql = "INSERT INTO Equ_MPlan (MP_Code,MP_Name,MP_Stuff,MP_Start,MP_End,VerifyStuff,VerifyStat,VerifyDate,Stat,MP_ECode,MP_EName) VALUES (@MP_Code,@MP_Name,@MP_Stuff,@MP_Start,@MP_End,@VerifyStuff,@VerifyStat,@VerifyDate,@Stat,@MP_ECode,@MP_EName)";
if (string.IsNullOrEmpty(equ_MPlan.MP_Code))
{
idb.AddParameter("@MP_Code", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Code", equ_MPlan.MP_Code);
}
if (string.IsNullOrEmpty(equ_MPlan.MP_Name))
{
idb.AddParameter("@MP_Name", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Name", equ_MPlan.MP_Name);
}
if (string.IsNullOrEmpty(equ_MPlan.MP_Stuff))
{
idb.AddParameter("@MP_Stuff", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Stuff", equ_MPlan.MP_Stuff);
}
if (equ_MPlan.MP_Start == DateTime.MinValue)
{
idb.AddParameter("@MP_Start", DBNull.Value);
}
else
{
idb.AddParameter("@MP_Start", equ_MPlan.MP_Start);
}
if (equ_MPlan.MP_End == DateTime.MinValue)
{
idb.AddParameter("@MP_End", DBNull.Value);
}
else
{
idb.AddParameter("@MP_End", equ_MPlan.MP_End);
}
if (string.IsNullOrEmpty(equ_MPlan.VerifyStuff))
{
idb.AddParameter("@VerifyStuff", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStuff", equ_MPlan.VerifyStuff);
}
if (string.IsNullOrEmpty(equ_MPlan.VerifyStat))
{
idb.AddParameter("@VerifyStat", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyStat", equ_MPlan.VerifyStat);
}
if (equ_MPlan.VerifyDate == DateTime.MinValue)
{
idb.AddParameter("@VerifyDate", DBNull.Value);
}
else
{
idb.AddParameter("@VerifyDate", equ_MPlan.VerifyDate);
}
if (equ_MPlan.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", equ_MPlan.Stat);
}
if (string.IsNullOrEmpty(equ_MPlan.MP_ECode))
{
idb.AddParameter("@MP_ECode", DBNull.Value);
}
else
{
idb.AddParameter("@MP_ECode", equ_MPlan.MP_ECode);
}
if (string.IsNullOrEmpty(equ_MPlan.MP_EName))
{
idb.AddParameter("@MP_EName", DBNull.Value);
}
else
{
idb.AddParameter("@MP_EName", equ_MPlan.MP_EName);
}
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>
/// 更新外联协调信息 Outreach_Coordination对象(即:一条记录
/// </summary>
public int Update(Outreach_Coordination outreach_Coordination)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Outreach_Coordination SET ");
if (outreach_Coordination.OC_Code_IsChanged)
{
sbParameter.Append("OC_Code=@OC_Code, ");
}
if (outreach_Coordination.OC_OutretachCode_IsChanged)
{
sbParameter.Append("OC_OutretachCode=@OC_OutretachCode, ");
}
if (outreach_Coordination.OC_OutreachName_IsChanged)
{
sbParameter.Append("OC_OutreachName=@OC_OutreachName, ");
}
if (outreach_Coordination.OC_CoordinationType_IsChanged)
{
sbParameter.Append("OC_CoordinationType=@OC_CoordinationType, ");
}
if (outreach_Coordination.OC_MainContactor_IsChanged)
{
sbParameter.Append("OC_MainContactor=@OC_MainContactor, ");
}
if (outreach_Coordination.OC_Telephone_IsChanged)
{
sbParameter.Append("OC_Telephone=@OC_Telephone, ");
}
if (outreach_Coordination.OC_Content_IsChanged)
{
sbParameter.Append("OC_Content=@OC_Content, ");
}
if (outreach_Coordination.OC_Result_IsChanged)
{
sbParameter.Append("OC_Result=@OC_Result, ");
}
if (outreach_Coordination.OC_ResultType_IsChanged)
{
sbParameter.Append("OC_ResultType=@OC_ResultType, ");
}
if (outreach_Coordination.OC_Cost_IsChanged)
{
sbParameter.Append("OC_Cost=@OC_Cost, ");
}
if (outreach_Coordination.OC_Remark_IsChanged)
{
sbParameter.Append("OC_Remark=@OC_Remark, ");
}
if (outreach_Coordination.OC_Attachment_IsChanged)
{
sbParameter.Append("OC_Attachment=@OC_Attachment, ");
}
if (outreach_Coordination.OC_Company_IsChanged)
{
sbParameter.Append("OC_Company=@OC_Company, ");
}
if (outreach_Coordination.OC_Dept_IsChanged)
{
sbParameter.Append("OC_Dept=@OC_Dept, ");
}
if (outreach_Coordination.OC_iType_IsChanged)
{
sbParameter.Append("OC_iType=@OC_iType, ");
}
if (outreach_Coordination.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (outreach_Coordination.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (outreach_Coordination.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (outreach_Coordination.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 OC_ID=@OC_ID; ");
string sql = sb.ToString();
if (outreach_Coordination.OC_Code_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Code))
{
idb.AddParameter("@OC_Code", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Code", outreach_Coordination.OC_Code);
}
}
if (outreach_Coordination.OC_OutretachCode_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_OutretachCode))
{
idb.AddParameter("@OC_OutretachCode", DBNull.Value);
}
else
{
idb.AddParameter("@OC_OutretachCode", outreach_Coordination.OC_OutretachCode);
}
}
if (outreach_Coordination.OC_OutreachName_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_OutreachName))
{
idb.AddParameter("@OC_OutreachName", DBNull.Value);
}
else
{
idb.AddParameter("@OC_OutreachName", outreach_Coordination.OC_OutreachName);
}
}
if (outreach_Coordination.OC_CoordinationType_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_CoordinationType))
{
idb.AddParameter("@OC_CoordinationType", DBNull.Value);
}
else
{
idb.AddParameter("@OC_CoordinationType", outreach_Coordination.OC_CoordinationType);
}
}
if (outreach_Coordination.OC_MainContactor_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_MainContactor))
{
idb.AddParameter("@OC_MainContactor", DBNull.Value);
}
else
{
idb.AddParameter("@OC_MainContactor", outreach_Coordination.OC_MainContactor);
}
}
if (outreach_Coordination.OC_Telephone_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Telephone))
{
idb.AddParameter("@OC_Telephone", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Telephone", outreach_Coordination.OC_Telephone);
}
}
if (outreach_Coordination.OC_Content_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Content))
{
idb.AddParameter("@OC_Content", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Content", outreach_Coordination.OC_Content);
}
}
if (outreach_Coordination.OC_Result_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Result))
{
idb.AddParameter("@OC_Result", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Result", outreach_Coordination.OC_Result);
}
}
if (outreach_Coordination.OC_ResultType_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_ResultType))
{
idb.AddParameter("@OC_ResultType", DBNull.Value);
}
else
{
idb.AddParameter("@OC_ResultType", outreach_Coordination.OC_ResultType);
}
}
if (outreach_Coordination.OC_Cost_IsChanged)
{
if (outreach_Coordination.OC_Cost == 0)
{
idb.AddParameter("@OC_Cost", 0);
}
else
{
idb.AddParameter("@OC_Cost", outreach_Coordination.OC_Cost);
}
}
if (outreach_Coordination.OC_Remark_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Remark))
{
idb.AddParameter("@OC_Remark", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Remark", outreach_Coordination.OC_Remark);
}
}
if (outreach_Coordination.OC_Attachment_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Attachment))
{
idb.AddParameter("@OC_Attachment", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Attachment", outreach_Coordination.OC_Attachment);
}
}
if (outreach_Coordination.OC_Company_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Company))
{
idb.AddParameter("@OC_Company", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Company", outreach_Coordination.OC_Company);
}
}
if (outreach_Coordination.OC_Dept_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_Dept))
{
idb.AddParameter("@OC_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@OC_Dept", outreach_Coordination.OC_Dept);
}
}
if (outreach_Coordination.OC_iType_IsChanged)
{
if (string.IsNullOrEmpty(outreach_Coordination.OC_iType))
{
idb.AddParameter("@OC_iType", DBNull.Value);
}
else
{
idb.AddParameter("@OC_iType", outreach_Coordination.OC_iType);
}
}
if (outreach_Coordination.Stat_IsChanged)
{
if (outreach_Coordination.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", outreach_Coordination.Stat);
}
}
if (outreach_Coordination.CreateDate_IsChanged)
{
if (outreach_Coordination.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", outreach_Coordination.CreateDate);
}
}
if (outreach_Coordination.UpdateDate_IsChanged)
{
if (outreach_Coordination.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", outreach_Coordination.UpdateDate);
}
}
if (outreach_Coordination.DeleteDate_IsChanged)
{
if (outreach_Coordination.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", outreach_Coordination.DeleteDate);
}
}
idb.AddParameter("@OC_ID", outreach_Coordination.OC_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>
/// 更新考评信息 HR_Evaluation对象(即:一条记录
/// </summary>
public int Update(HR_Evaluation hR_Evaluation)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE HR_Evaluation SET ");
if (hR_Evaluation.Eva_Code_IsChanged)
{
sbParameter.Append("Eva_Code=@Eva_Code, ");
}
if (hR_Evaluation.Eva_StuffCode_IsChanged)
{
sbParameter.Append("Eva_StuffCode=@Eva_StuffCode, ");
}
if (hR_Evaluation.Eva_StuffName_IsChanged)
{
sbParameter.Append("Eva_StuffName=@Eva_StuffName, ");
}
if (hR_Evaluation.Eva_Date_IsChanged)
{
sbParameter.Append("Eva_Date=@Eva_Date, ");
}
if (hR_Evaluation.Eva_Records_IsChanged)
{
sbParameter.Append("Eva_Records=@Eva_Records, ");
}
if (hR_Evaluation.Eva_Conclusion_IsChanged)
{
sbParameter.Append("Eva_Conclusion=@Eva_Conclusion, ");
}
if (hR_Evaluation.Eva_Manager_IsChanged)
{
sbParameter.Append("Eva_Manager=@Eva_Manager, ");
}
if (hR_Evaluation.Eva_Level_IsChanged)
{
sbParameter.Append("Eva_Level=@Eva_Level, ");
}
if (hR_Evaluation.Eva_Bak_IsChanged)
{
sbParameter.Append("Eva_Bak=@Eva_Bak, ");
}
if (hR_Evaluation.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (hR_Evaluation.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (hR_Evaluation.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (hR_Evaluation.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 Eva_ID=@Eva_ID; ");
string sql = sb.ToString();
if (hR_Evaluation.Eva_Code_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_Code))
{
idb.AddParameter("@Eva_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Code", hR_Evaluation.Eva_Code);
}
}
if (hR_Evaluation.Eva_StuffCode_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_StuffCode))
{
idb.AddParameter("@Eva_StuffCode", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_StuffCode", hR_Evaluation.Eva_StuffCode);
}
}
if (hR_Evaluation.Eva_StuffName_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_StuffName))
{
idb.AddParameter("@Eva_StuffName", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_StuffName", hR_Evaluation.Eva_StuffName);
}
}
if (hR_Evaluation.Eva_Date_IsChanged)
{
if (hR_Evaluation.Eva_Date == DateTime.MinValue)
{
idb.AddParameter("@Eva_Date", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Date", hR_Evaluation.Eva_Date);
}
}
if (hR_Evaluation.Eva_Records_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_Records))
{
idb.AddParameter("@Eva_Records", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Records", hR_Evaluation.Eva_Records);
}
}
if (hR_Evaluation.Eva_Conclusion_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_Conclusion))
{
idb.AddParameter("@Eva_Conclusion", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Conclusion", hR_Evaluation.Eva_Conclusion);
}
}
if (hR_Evaluation.Eva_Manager_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_Manager))
{
idb.AddParameter("@Eva_Manager", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Manager", hR_Evaluation.Eva_Manager);
}
}
if (hR_Evaluation.Eva_Level_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_Level))
{
idb.AddParameter("@Eva_Level", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Level", hR_Evaluation.Eva_Level);
}
}
if (hR_Evaluation.Eva_Bak_IsChanged)
{
if (string.IsNullOrEmpty(hR_Evaluation.Eva_Bak))
{
idb.AddParameter("@Eva_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@Eva_Bak", hR_Evaluation.Eva_Bak);
}
}
if (hR_Evaluation.Stat_IsChanged)
{
if (hR_Evaluation.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", hR_Evaluation.Stat);
}
}
if (hR_Evaluation.CreateDate_IsChanged)
{
if (hR_Evaluation.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", hR_Evaluation.CreateDate);
}
}
if (hR_Evaluation.UpdateDate_IsChanged)
{
if (hR_Evaluation.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", hR_Evaluation.UpdateDate);
}
}
if (hR_Evaluation.DeleteDate_IsChanged)
{
if (hR_Evaluation.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", hR_Evaluation.DeleteDate);
}
}
idb.AddParameter("@Eva_ID", hR_Evaluation.Eva_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);
}