/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public SD_Contract GetModel(string strCondition)
{
List<SD_Contract> list = instance.GetListByWhere(strCondition);
SD_Contract model = new SD_Contract();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 添加销售合同基本信息 SD_Contract对象(即:一条记录)
/// </summary>
public object AddWithReturn(SD_Contract sD_Contract)
{
string sql = "INSERT INTO SD_Contract (SDC_iType,SDC_Code,SDC_CName,SDC_CCode,SDC_Date,SDC_Place,SC_OwnerCode,SDC_Owner,SDC_Dept,SDC_Start,SDC_End,SDC_EOwnerCode,SDC_EOwner,SDC_Num,SDC_TechDecision,SDC_TechCode,SDC_PayContent,SDC_COwner,SDC_CContact,SDC_Content,SDC_Description,SDC_Control,SDC_IsAFor,Audit1CurAudit,Audit1Stat,Audit1Date,Audit1Owner,AuditCurAudit,AuditStat,AuditDate,AuditOwner,Stat,CreateDate,UpdateDate,DeleteDate,CreateOwner,SDC_Stat,SDC_Type,SDC_Company,SDC_CompanyCode,SDC_TotalSend,SDC_LastSend,SDC_LastDate,SDC_Return,SDC_StartSend,SDC_EndSend,SDC_TotalDate,SDC_AgreeQuantity,SDC_PlanQuantity,SDC_SupQuantity,SDC_TotalMoney,SDC_PayMoney,SDC_SPayMoney,SDC_PayType,SDC_BType,SDC_BTypeName) VALUES (@SDC_iType,@SDC_Code,@SDC_CName,@SDC_CCode,@SDC_Date,@SDC_Place,@SC_OwnerCode,@SDC_Owner,@SDC_Dept,@SDC_Start,@SDC_End,@SDC_EOwnerCode,@SDC_EOwner,@SDC_Num,@SDC_TechDecision,@SDC_TechCode,@SDC_PayContent,@SDC_COwner,@SDC_CContact,@SDC_Content,@SDC_Description,@SDC_Control,@SDC_IsAFor,@Audit1CurAudit,@Audit1Stat,@Audit1Date,@Audit1Owner,@AuditCurAudit,@AuditStat,@AuditDate,@AuditOwner,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@CreateOwner,@SDC_Stat,@SDC_Type,@SDC_Company,@SDC_CompanyCode,@SDC_TotalSend,@SDC_LastSend,@SDC_LastDate,@SDC_Return,@SDC_StartSend,@SDC_EndSend,@SDC_TotalDate,@SDC_AgreeQuantity,@SDC_PlanQuantity,@SDC_SupQuantity,@SDC_TotalMoney,@SDC_PayMoney,@SDC_SPayMoney,@SDC_PayType,@SDC_BType,@SDC_BTypeName);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(sD_Contract.SDC_iType))
{
idb.AddParameter("@SDC_iType", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_iType", sD_Contract.SDC_iType);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Code))
{
idb.AddParameter("@SDC_Code", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Code", sD_Contract.SDC_Code);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_CName))
{
idb.AddParameter("@SDC_CName", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CName", sD_Contract.SDC_CName);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_CCode))
{
idb.AddParameter("@SDC_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CCode", sD_Contract.SDC_CCode);
}
if (sD_Contract.SDC_Date == DateTime.MinValue)
{
idb.AddParameter("@SDC_Date", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Date", sD_Contract.SDC_Date);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Place))
{
idb.AddParameter("@SDC_Place", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Place", sD_Contract.SDC_Place);
}
if (string.IsNullOrEmpty(sD_Contract.SC_OwnerCode))
{
idb.AddParameter("@SC_OwnerCode", DBNull.Value);
}
else
{
idb.AddParameter("@SC_OwnerCode", sD_Contract.SC_OwnerCode);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Owner))
{
idb.AddParameter("@SDC_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Owner", sD_Contract.SDC_Owner);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Dept))
{
idb.AddParameter("@SDC_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Dept", sD_Contract.SDC_Dept);
}
if (sD_Contract.SDC_Start == DateTime.MinValue)
{
idb.AddParameter("@SDC_Start", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Start", sD_Contract.SDC_Start);
}
if (sD_Contract.SDC_End == DateTime.MinValue)
{
idb.AddParameter("@SDC_End", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_End", sD_Contract.SDC_End);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_EOwnerCode))
{
idb.AddParameter("@SDC_EOwnerCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_EOwnerCode", sD_Contract.SDC_EOwnerCode);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_EOwner))
{
idb.AddParameter("@SDC_EOwner", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_EOwner", sD_Contract.SDC_EOwner);
}
if (sD_Contract.SDC_Num == 0)
{
idb.AddParameter("@SDC_Num", 0);
}
else
{
idb.AddParameter("@SDC_Num", sD_Contract.SDC_Num);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_TechDecision))
{
idb.AddParameter("@SDC_TechDecision", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TechDecision", sD_Contract.SDC_TechDecision);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_TechCode))
{
idb.AddParameter("@SDC_TechCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TechCode", sD_Contract.SDC_TechCode);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_PayContent))
{
idb.AddParameter("@SDC_PayContent", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_PayContent", sD_Contract.SDC_PayContent);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_COwner))
{
idb.AddParameter("@SDC_COwner", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_COwner", sD_Contract.SDC_COwner);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_CContact))
{
idb.AddParameter("@SDC_CContact", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CContact", sD_Contract.SDC_CContact);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Content))
{
idb.AddParameter("@SDC_Content", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Content", sD_Contract.SDC_Content);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Description))
{
idb.AddParameter("@SDC_Description", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Description", sD_Contract.SDC_Description);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Control))
{
idb.AddParameter("@SDC_Control", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Control", sD_Contract.SDC_Control);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_IsAFor))
{
idb.AddParameter("@SDC_IsAFor", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_IsAFor", sD_Contract.SDC_IsAFor);
}
if (string.IsNullOrEmpty(sD_Contract.Audit1CurAudit))
{
idb.AddParameter("@Audit1CurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1CurAudit", sD_Contract.Audit1CurAudit);
}
if (string.IsNullOrEmpty(sD_Contract.Audit1Stat))
{
idb.AddParameter("@Audit1Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1Stat", sD_Contract.Audit1Stat);
}
if (sD_Contract.Audit1Date == DateTime.MinValue)
{
idb.AddParameter("@Audit1Date", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1Date", sD_Contract.Audit1Date);
}
if (string.IsNullOrEmpty(sD_Contract.Audit1Owner))
{
idb.AddParameter("@Audit1Owner", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1Owner", sD_Contract.Audit1Owner);
}
if (string.IsNullOrEmpty(sD_Contract.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", sD_Contract.AuditCurAudit);
}
if (string.IsNullOrEmpty(sD_Contract.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", sD_Contract.AuditStat);
}
if (sD_Contract.AuditDate == DateTime.MinValue)
{
idb.AddParameter("@AuditDate", DBNull.Value);
}
else
{
idb.AddParameter("@AuditDate", sD_Contract.AuditDate);
}
if (string.IsNullOrEmpty(sD_Contract.AuditOwner))
{
idb.AddParameter("@AuditOwner", DBNull.Value);
}
else
{
idb.AddParameter("@AuditOwner", sD_Contract.AuditOwner);
}
if (sD_Contract.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sD_Contract.Stat);
}
if (sD_Contract.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", sD_Contract.CreateDate);
}
if (sD_Contract.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", sD_Contract.UpdateDate);
}
if (sD_Contract.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", sD_Contract.DeleteDate);
}
if (string.IsNullOrEmpty(sD_Contract.CreateOwner))
{
idb.AddParameter("@CreateOwner", DBNull.Value);
}
else
{
idb.AddParameter("@CreateOwner", sD_Contract.CreateOwner);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Stat))
{
idb.AddParameter("@SDC_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Stat", sD_Contract.SDC_Stat);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Type))
{
idb.AddParameter("@SDC_Type", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Type", sD_Contract.SDC_Type);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Company))
{
idb.AddParameter("@SDC_Company", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Company", sD_Contract.SDC_Company);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_CompanyCode))
{
idb.AddParameter("@SDC_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CompanyCode", sD_Contract.SDC_CompanyCode);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_TotalSend))
{
idb.AddParameter("@SDC_TotalSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TotalSend", sD_Contract.SDC_TotalSend);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_LastSend))
{
idb.AddParameter("@SDC_LastSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_LastSend", sD_Contract.SDC_LastSend);
}
if (sD_Contract.SDC_LastDate == DateTime.MinValue)
{
idb.AddParameter("@SDC_LastDate", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_LastDate", sD_Contract.SDC_LastDate);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_Return))
{
idb.AddParameter("@SDC_Return", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Return", sD_Contract.SDC_Return);
}
if (sD_Contract.SDC_StartSend == DateTime.MinValue)
{
idb.AddParameter("@SDC_StartSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_StartSend", sD_Contract.SDC_StartSend);
}
if (sD_Contract.SDC_EndSend == DateTime.MinValue)
{
idb.AddParameter("@SDC_EndSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_EndSend", sD_Contract.SDC_EndSend);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_TotalDate))
{
idb.AddParameter("@SDC_TotalDate", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TotalDate", sD_Contract.SDC_TotalDate);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_AgreeQuantity))
{
idb.AddParameter("@SDC_AgreeQuantity", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_AgreeQuantity", sD_Contract.SDC_AgreeQuantity);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_PlanQuantity))
{
idb.AddParameter("@SDC_PlanQuantity", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_PlanQuantity", sD_Contract.SDC_PlanQuantity);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_SupQuantity))
{
idb.AddParameter("@SDC_SupQuantity", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_SupQuantity", sD_Contract.SDC_SupQuantity);
}
if (sD_Contract.SDC_TotalMoney == 0)
{
idb.AddParameter("@SDC_TotalMoney", 0);
}
else
{
idb.AddParameter("@SDC_TotalMoney", sD_Contract.SDC_TotalMoney);
}
if (sD_Contract.SDC_PayMoney == 0)
{
idb.AddParameter("@SDC_PayMoney", 0);
}
else
{
idb.AddParameter("@SDC_PayMoney", sD_Contract.SDC_PayMoney);
}
if (sD_Contract.SDC_SPayMoney == 0)
{
idb.AddParameter("@SDC_SPayMoney", 0);
}
else
{
idb.AddParameter("@SDC_SPayMoney", sD_Contract.SDC_SPayMoney);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_PayType))
{
idb.AddParameter("@SDC_PayType", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_PayType", sD_Contract.SDC_PayType);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_BType))
{
idb.AddParameter("@SDC_BType", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_BType", sD_Contract.SDC_BType);
}
if (string.IsNullOrEmpty(sD_Contract.SDC_BTypeName))
{
idb.AddParameter("@SDC_BTypeName", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_BTypeName", sD_Contract.SDC_BTypeName);
}
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>
/// 更新销售合同基本信息 SD_Contract对象(即:一条记录
/// </summary>
public int Update(SD_Contract sD_Contract)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE SD_Contract SET ");
if(sD_Contract.SDC_iType_IsChanged){sbParameter.Append("SDC_iType=@SDC_iType, ");}
if(sD_Contract.SDC_Code_IsChanged){sbParameter.Append("SDC_Code=@SDC_Code, ");}
if(sD_Contract.SDC_CName_IsChanged){sbParameter.Append("SDC_CName=@SDC_CName, ");}
if(sD_Contract.SDC_CCode_IsChanged){sbParameter.Append("SDC_CCode=@SDC_CCode, ");}
if(sD_Contract.SDC_Date_IsChanged){sbParameter.Append("SDC_Date=@SDC_Date, ");}
if(sD_Contract.SDC_Place_IsChanged){sbParameter.Append("SDC_Place=@SDC_Place, ");}
if(sD_Contract.SC_OwnerCode_IsChanged){sbParameter.Append("SC_OwnerCode=@SC_OwnerCode, ");}
if(sD_Contract.SDC_Owner_IsChanged){sbParameter.Append("SDC_Owner=@SDC_Owner, ");}
if(sD_Contract.SDC_Dept_IsChanged){sbParameter.Append("SDC_Dept=@SDC_Dept, ");}
if(sD_Contract.SDC_Start_IsChanged){sbParameter.Append("SDC_Start=@SDC_Start, ");}
if(sD_Contract.SDC_End_IsChanged){sbParameter.Append("SDC_End=@SDC_End, ");}
if(sD_Contract.SDC_EOwnerCode_IsChanged){sbParameter.Append("SDC_EOwnerCode=@SDC_EOwnerCode, ");}
if(sD_Contract.SDC_EOwner_IsChanged){sbParameter.Append("SDC_EOwner=@SDC_EOwner, ");}
if(sD_Contract.SDC_Num_IsChanged){sbParameter.Append("SDC_Num=@SDC_Num, ");}
if(sD_Contract.SDC_TechDecision_IsChanged){sbParameter.Append("SDC_TechDecision=@SDC_TechDecision, ");}
if(sD_Contract.SDC_TechCode_IsChanged){sbParameter.Append("SDC_TechCode=@SDC_TechCode, ");}
if(sD_Contract.SDC_PayContent_IsChanged){sbParameter.Append("SDC_PayContent=@SDC_PayContent, ");}
if(sD_Contract.SDC_COwner_IsChanged){sbParameter.Append("SDC_COwner=@SDC_COwner, ");}
if(sD_Contract.SDC_CContact_IsChanged){sbParameter.Append("SDC_CContact=@SDC_CContact, ");}
if(sD_Contract.SDC_Content_IsChanged){sbParameter.Append("SDC_Content=@SDC_Content, ");}
if(sD_Contract.SDC_Description_IsChanged){sbParameter.Append("SDC_Description=@SDC_Description, ");}
if(sD_Contract.SDC_Control_IsChanged){sbParameter.Append("SDC_Control=@SDC_Control, ");}
if(sD_Contract.SDC_IsAFor_IsChanged){sbParameter.Append("SDC_IsAFor=@SDC_IsAFor, ");}
if(sD_Contract.Audit1CurAudit_IsChanged){sbParameter.Append("Audit1CurAudit=@Audit1CurAudit, ");}
if(sD_Contract.Audit1Stat_IsChanged){sbParameter.Append("Audit1Stat=@Audit1Stat, ");}
if(sD_Contract.Audit1Date_IsChanged){sbParameter.Append("Audit1Date=@Audit1Date, ");}
if(sD_Contract.Audit1Owner_IsChanged){sbParameter.Append("Audit1Owner=@Audit1Owner, ");}
if(sD_Contract.AuditCurAudit_IsChanged){sbParameter.Append("AuditCurAudit=@AuditCurAudit, ");}
if(sD_Contract.AuditStat_IsChanged){sbParameter.Append("AuditStat=@AuditStat, ");}
if(sD_Contract.AuditDate_IsChanged){sbParameter.Append("AuditDate=@AuditDate, ");}
if(sD_Contract.AuditOwner_IsChanged){sbParameter.Append("AuditOwner=@AuditOwner, ");}
if(sD_Contract.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(sD_Contract.CreateDate_IsChanged){sbParameter.Append("CreateDate=@CreateDate, ");}
if(sD_Contract.UpdateDate_IsChanged){sbParameter.Append("UpdateDate=@UpdateDate, ");}
if(sD_Contract.DeleteDate_IsChanged){sbParameter.Append("DeleteDate=@DeleteDate, ");}
if(sD_Contract.CreateOwner_IsChanged){sbParameter.Append("CreateOwner=@CreateOwner, ");}
if(sD_Contract.SDC_Stat_IsChanged){sbParameter.Append("SDC_Stat=@SDC_Stat, ");}
if(sD_Contract.SDC_Type_IsChanged){sbParameter.Append("SDC_Type=@SDC_Type, ");}
if(sD_Contract.SDC_Company_IsChanged){sbParameter.Append("SDC_Company=@SDC_Company, ");}
if(sD_Contract.SDC_CompanyCode_IsChanged){sbParameter.Append("SDC_CompanyCode=@SDC_CompanyCode, ");}
if(sD_Contract.SDC_TotalSend_IsChanged){sbParameter.Append("SDC_TotalSend=@SDC_TotalSend, ");}
if(sD_Contract.SDC_LastSend_IsChanged){sbParameter.Append("SDC_LastSend=@SDC_LastSend, ");}
if(sD_Contract.SDC_LastDate_IsChanged){sbParameter.Append("SDC_LastDate=@SDC_LastDate, ");}
if(sD_Contract.SDC_Return_IsChanged){sbParameter.Append("SDC_Return=@SDC_Return, ");}
if(sD_Contract.SDC_StartSend_IsChanged){sbParameter.Append("SDC_StartSend=@SDC_StartSend, ");}
if(sD_Contract.SDC_EndSend_IsChanged){sbParameter.Append("SDC_EndSend=@SDC_EndSend, ");}
if(sD_Contract.SDC_TotalDate_IsChanged){sbParameter.Append("SDC_TotalDate=@SDC_TotalDate, ");}
if(sD_Contract.SDC_AgreeQuantity_IsChanged){sbParameter.Append("SDC_AgreeQuantity=@SDC_AgreeQuantity, ");}
if(sD_Contract.SDC_PlanQuantity_IsChanged){sbParameter.Append("SDC_PlanQuantity=@SDC_PlanQuantity, ");}
if(sD_Contract.SDC_SupQuantity_IsChanged){sbParameter.Append("SDC_SupQuantity=@SDC_SupQuantity, ");}
if(sD_Contract.SDC_TotalMoney_IsChanged){sbParameter.Append("SDC_TotalMoney=@SDC_TotalMoney, ");}
if(sD_Contract.SDC_PayMoney_IsChanged){sbParameter.Append("SDC_PayMoney=@SDC_PayMoney, ");}
if(sD_Contract.SDC_SPayMoney_IsChanged){sbParameter.Append("SDC_SPayMoney=@SDC_SPayMoney, ");}
if(sD_Contract.SDC_PayType_IsChanged){sbParameter.Append("SDC_PayType=@SDC_PayType, ");}
if(sD_Contract.SDC_BType_IsChanged){sbParameter.Append("SDC_BType=@SDC_BType, ");}
if(sD_Contract.SDC_BTypeName_IsChanged){sbParameter.Append("SDC_BTypeName=@SDC_BTypeName ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and SDC_ID=@SDC_ID; " );
string sql=sb.ToString();
if(sD_Contract.SDC_iType_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_iType))
{
idb.AddParameter("@SDC_iType", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_iType", sD_Contract.SDC_iType);
}
}
if(sD_Contract.SDC_Code_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Code))
{
idb.AddParameter("@SDC_Code", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Code", sD_Contract.SDC_Code);
}
}
if(sD_Contract.SDC_CName_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_CName))
{
idb.AddParameter("@SDC_CName", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CName", sD_Contract.SDC_CName);
}
}
if(sD_Contract.SDC_CCode_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_CCode))
{
idb.AddParameter("@SDC_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CCode", sD_Contract.SDC_CCode);
}
}
if(sD_Contract.SDC_Date_IsChanged)
{
if (sD_Contract.SDC_Date == DateTime.MinValue)
{
idb.AddParameter("@SDC_Date", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Date", sD_Contract.SDC_Date);
}
}
if(sD_Contract.SDC_Place_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Place))
{
idb.AddParameter("@SDC_Place", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Place", sD_Contract.SDC_Place);
}
}
if(sD_Contract.SC_OwnerCode_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SC_OwnerCode))
{
idb.AddParameter("@SC_OwnerCode", DBNull.Value);
}
else
{
idb.AddParameter("@SC_OwnerCode", sD_Contract.SC_OwnerCode);
}
}
if(sD_Contract.SDC_Owner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Owner))
{
idb.AddParameter("@SDC_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Owner", sD_Contract.SDC_Owner);
}
}
if(sD_Contract.SDC_Dept_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Dept))
{
idb.AddParameter("@SDC_Dept", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Dept", sD_Contract.SDC_Dept);
}
}
if(sD_Contract.SDC_Start_IsChanged)
{
if (sD_Contract.SDC_Start == DateTime.MinValue)
{
idb.AddParameter("@SDC_Start", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Start", sD_Contract.SDC_Start);
}
}
if(sD_Contract.SDC_End_IsChanged)
{
if (sD_Contract.SDC_End == DateTime.MinValue)
{
idb.AddParameter("@SDC_End", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_End", sD_Contract.SDC_End);
}
}
if(sD_Contract.SDC_EOwnerCode_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_EOwnerCode))
{
idb.AddParameter("@SDC_EOwnerCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_EOwnerCode", sD_Contract.SDC_EOwnerCode);
}
}
if(sD_Contract.SDC_EOwner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_EOwner))
{
idb.AddParameter("@SDC_EOwner", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_EOwner", sD_Contract.SDC_EOwner);
}
}
if(sD_Contract.SDC_Num_IsChanged)
{
if (sD_Contract.SDC_Num == 0)
{
idb.AddParameter("@SDC_Num", 0);
}
else
{
idb.AddParameter("@SDC_Num", sD_Contract.SDC_Num);
}
}
if(sD_Contract.SDC_TechDecision_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_TechDecision))
{
idb.AddParameter("@SDC_TechDecision", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TechDecision", sD_Contract.SDC_TechDecision);
}
}
if(sD_Contract.SDC_TechCode_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_TechCode))
{
idb.AddParameter("@SDC_TechCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TechCode", sD_Contract.SDC_TechCode);
}
}
if(sD_Contract.SDC_PayContent_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_PayContent))
{
idb.AddParameter("@SDC_PayContent", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_PayContent", sD_Contract.SDC_PayContent);
}
}
if(sD_Contract.SDC_COwner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_COwner))
{
idb.AddParameter("@SDC_COwner", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_COwner", sD_Contract.SDC_COwner);
}
}
if(sD_Contract.SDC_CContact_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_CContact))
{
idb.AddParameter("@SDC_CContact", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CContact", sD_Contract.SDC_CContact);
}
}
if(sD_Contract.SDC_Content_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Content))
{
idb.AddParameter("@SDC_Content", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Content", sD_Contract.SDC_Content);
}
}
if(sD_Contract.SDC_Description_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Description))
{
idb.AddParameter("@SDC_Description", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Description", sD_Contract.SDC_Description);
}
}
if(sD_Contract.SDC_Control_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Control))
{
idb.AddParameter("@SDC_Control", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Control", sD_Contract.SDC_Control);
}
}
if(sD_Contract.SDC_IsAFor_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_IsAFor))
{
idb.AddParameter("@SDC_IsAFor", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_IsAFor", sD_Contract.SDC_IsAFor);
}
}
if(sD_Contract.Audit1CurAudit_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.Audit1CurAudit))
{
idb.AddParameter("@Audit1CurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1CurAudit", sD_Contract.Audit1CurAudit);
}
}
if(sD_Contract.Audit1Stat_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.Audit1Stat))
{
idb.AddParameter("@Audit1Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1Stat", sD_Contract.Audit1Stat);
}
}
if(sD_Contract.Audit1Date_IsChanged)
{
if (sD_Contract.Audit1Date == DateTime.MinValue)
{
idb.AddParameter("@Audit1Date", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1Date", sD_Contract.Audit1Date);
}
}
if(sD_Contract.Audit1Owner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.Audit1Owner))
{
idb.AddParameter("@Audit1Owner", DBNull.Value);
}
else
{
idb.AddParameter("@Audit1Owner", sD_Contract.Audit1Owner);
}
}
if(sD_Contract.AuditCurAudit_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", sD_Contract.AuditCurAudit);
}
}
if(sD_Contract.AuditStat_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", sD_Contract.AuditStat);
}
}
if(sD_Contract.AuditDate_IsChanged)
{
if (sD_Contract.AuditDate == DateTime.MinValue)
{
idb.AddParameter("@AuditDate", DBNull.Value);
}
else
{
idb.AddParameter("@AuditDate", sD_Contract.AuditDate);
}
}
if(sD_Contract.AuditOwner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.AuditOwner))
{
idb.AddParameter("@AuditOwner", DBNull.Value);
}
else
{
idb.AddParameter("@AuditOwner", sD_Contract.AuditOwner);
}
}
if(sD_Contract.Stat_IsChanged)
{
if (sD_Contract.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sD_Contract.Stat);
}
}
if(sD_Contract.CreateDate_IsChanged)
{
if (sD_Contract.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", sD_Contract.CreateDate);
}
}
if(sD_Contract.UpdateDate_IsChanged)
{
if (sD_Contract.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", sD_Contract.UpdateDate);
}
}
if(sD_Contract.DeleteDate_IsChanged)
{
if (sD_Contract.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", sD_Contract.DeleteDate);
}
}
if(sD_Contract.CreateOwner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.CreateOwner))
{
idb.AddParameter("@CreateOwner", DBNull.Value);
}
else
{
idb.AddParameter("@CreateOwner", sD_Contract.CreateOwner);
}
}
if(sD_Contract.SDC_Stat_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Stat))
{
idb.AddParameter("@SDC_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Stat", sD_Contract.SDC_Stat);
}
}
if(sD_Contract.SDC_Type_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Type))
{
idb.AddParameter("@SDC_Type", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Type", sD_Contract.SDC_Type);
}
}
if(sD_Contract.SDC_Company_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Company))
{
idb.AddParameter("@SDC_Company", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Company", sD_Contract.SDC_Company);
}
}
if(sD_Contract.SDC_CompanyCode_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_CompanyCode))
{
idb.AddParameter("@SDC_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_CompanyCode", sD_Contract.SDC_CompanyCode);
}
}
if(sD_Contract.SDC_TotalSend_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_TotalSend))
{
idb.AddParameter("@SDC_TotalSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TotalSend", sD_Contract.SDC_TotalSend);
}
}
if(sD_Contract.SDC_LastSend_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_LastSend))
{
idb.AddParameter("@SDC_LastSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_LastSend", sD_Contract.SDC_LastSend);
}
}
if(sD_Contract.SDC_LastDate_IsChanged)
{
if (sD_Contract.SDC_LastDate == DateTime.MinValue)
{
idb.AddParameter("@SDC_LastDate", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_LastDate", sD_Contract.SDC_LastDate);
}
}
if(sD_Contract.SDC_Return_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_Return))
{
idb.AddParameter("@SDC_Return", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_Return", sD_Contract.SDC_Return);
}
}
if(sD_Contract.SDC_StartSend_IsChanged)
{
if (sD_Contract.SDC_StartSend == DateTime.MinValue)
{
idb.AddParameter("@SDC_StartSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_StartSend", sD_Contract.SDC_StartSend);
}
}
if(sD_Contract.SDC_EndSend_IsChanged)
{
if (sD_Contract.SDC_EndSend == DateTime.MinValue)
{
idb.AddParameter("@SDC_EndSend", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_EndSend", sD_Contract.SDC_EndSend);
}
}
if(sD_Contract.SDC_TotalDate_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_TotalDate))
{
idb.AddParameter("@SDC_TotalDate", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_TotalDate", sD_Contract.SDC_TotalDate);
}
}
if(sD_Contract.SDC_AgreeQuantity_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_AgreeQuantity))
{
idb.AddParameter("@SDC_AgreeQuantity", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_AgreeQuantity", sD_Contract.SDC_AgreeQuantity);
}
}
if(sD_Contract.SDC_PlanQuantity_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_PlanQuantity))
{
idb.AddParameter("@SDC_PlanQuantity", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_PlanQuantity", sD_Contract.SDC_PlanQuantity);
}
}
if(sD_Contract.SDC_SupQuantity_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_SupQuantity))
{
idb.AddParameter("@SDC_SupQuantity", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_SupQuantity", sD_Contract.SDC_SupQuantity);
}
}
if(sD_Contract.SDC_TotalMoney_IsChanged)
{
if (sD_Contract.SDC_TotalMoney == 0)
{
idb.AddParameter("@SDC_TotalMoney", 0);
}
else
{
idb.AddParameter("@SDC_TotalMoney", sD_Contract.SDC_TotalMoney);
}
}
if(sD_Contract.SDC_PayMoney_IsChanged)
{
if (sD_Contract.SDC_PayMoney == 0)
{
idb.AddParameter("@SDC_PayMoney", 0);
}
else
{
idb.AddParameter("@SDC_PayMoney", sD_Contract.SDC_PayMoney);
}
}
if(sD_Contract.SDC_SPayMoney_IsChanged)
{
if (sD_Contract.SDC_SPayMoney == 0)
{
idb.AddParameter("@SDC_SPayMoney", 0);
}
else
{
idb.AddParameter("@SDC_SPayMoney", sD_Contract.SDC_SPayMoney);
}
}
if(sD_Contract.SDC_PayType_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_PayType))
{
idb.AddParameter("@SDC_PayType", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_PayType", sD_Contract.SDC_PayType);
}
}
if(sD_Contract.SDC_BType_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_BType))
{
idb.AddParameter("@SDC_BType", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_BType", sD_Contract.SDC_BType);
}
}
if(sD_Contract.SDC_BTypeName_IsChanged)
{
if (string.IsNullOrEmpty(sD_Contract.SDC_BTypeName))
{
idb.AddParameter("@SDC_BTypeName", DBNull.Value);
}
else
{
idb.AddParameter("@SDC_BTypeName", sD_Contract.SDC_BTypeName);
}
}
idb.AddParameter("@SDC_ID", sD_Contract.SDC_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>
/// 获取指定的销售合同基本信息 SD_Contract对象集合
/// </summary>
public List<SD_Contract> GetListByWhere(string strCondition)
{
List<SD_Contract> ret = new List<SD_Contract>();
string sql = "SELECT SDC_ID,SDC_iType,SDC_Code,SDC_CName,SDC_CCode,SDC_Date,SDC_Place,SC_OwnerCode,SDC_Owner,SDC_Dept,SDC_Start,SDC_End,SDC_EOwnerCode,SDC_EOwner,SDC_Num,SDC_TechDecision,SDC_TechCode,SDC_PayContent,SDC_COwner,SDC_CContact,SDC_Content,SDC_Description,SDC_Control,SDC_IsAFor,Audit1CurAudit,Audit1Stat,Audit1Date,Audit1Owner,AuditCurAudit,AuditStat,AuditDate,AuditOwner,Stat,CreateDate,UpdateDate,DeleteDate,CreateOwner,SDC_Stat,SDC_Type,SDC_Company,SDC_CompanyCode,SDC_TotalSend,SDC_LastSend,SDC_LastDate,SDC_Return,SDC_StartSend,SDC_EndSend,SDC_TotalDate,SDC_AgreeQuantity,SDC_PlanQuantity,SDC_SupQuantity,SDC_TotalMoney,SDC_PayMoney,SDC_SPayMoney,SDC_PayType,SDC_BType,SDC_BTypeName FROM SD_Contract WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
SD_Contract sD_Contract = new SD_Contract();
if (dr["SDC_ID"] != DBNull.Value) sD_Contract.SDC_ID = Convert.ToDecimal(dr["SDC_ID"]);
if (dr["SDC_iType"] != DBNull.Value) sD_Contract.SDC_iType = Convert.ToString(dr["SDC_iType"]);
if (dr["SDC_Code"] != DBNull.Value) sD_Contract.SDC_Code = Convert.ToString(dr["SDC_Code"]);
if (dr["SDC_CName"] != DBNull.Value) sD_Contract.SDC_CName = Convert.ToString(dr["SDC_CName"]);
if (dr["SDC_CCode"] != DBNull.Value) sD_Contract.SDC_CCode = Convert.ToString(dr["SDC_CCode"]);
if (dr["SDC_Date"] != DBNull.Value) sD_Contract.SDC_Date = Convert.ToDateTime(dr["SDC_Date"]);
if (dr["SDC_Place"] != DBNull.Value) sD_Contract.SDC_Place = Convert.ToString(dr["SDC_Place"]);
if (dr["SC_OwnerCode"] != DBNull.Value) sD_Contract.SC_OwnerCode = Convert.ToString(dr["SC_OwnerCode"]);
if (dr["SDC_Owner"] != DBNull.Value) sD_Contract.SDC_Owner = Convert.ToString(dr["SDC_Owner"]);
if (dr["SDC_Dept"] != DBNull.Value) sD_Contract.SDC_Dept = Convert.ToString(dr["SDC_Dept"]);
if (dr["SDC_Start"] != DBNull.Value) sD_Contract.SDC_Start = Convert.ToDateTime(dr["SDC_Start"]);
if (dr["SDC_End"] != DBNull.Value) sD_Contract.SDC_End = Convert.ToDateTime(dr["SDC_End"]);
if (dr["SDC_EOwnerCode"] != DBNull.Value) sD_Contract.SDC_EOwnerCode = Convert.ToString(dr["SDC_EOwnerCode"]);
if (dr["SDC_EOwner"] != DBNull.Value) sD_Contract.SDC_EOwner = Convert.ToString(dr["SDC_EOwner"]);
if (dr["SDC_Num"] != DBNull.Value) sD_Contract.SDC_Num = Convert.ToInt32(dr["SDC_Num"]);
if (dr["SDC_TechDecision"] != DBNull.Value) sD_Contract.SDC_TechDecision = Convert.ToString(dr["SDC_TechDecision"]);
if (dr["SDC_TechCode"] != DBNull.Value) sD_Contract.SDC_TechCode = Convert.ToString(dr["SDC_TechCode"]);
if (dr["SDC_PayContent"] != DBNull.Value) sD_Contract.SDC_PayContent = Convert.ToString(dr["SDC_PayContent"]);
if (dr["SDC_COwner"] != DBNull.Value) sD_Contract.SDC_COwner = Convert.ToString(dr["SDC_COwner"]);
if (dr["SDC_CContact"] != DBNull.Value) sD_Contract.SDC_CContact = Convert.ToString(dr["SDC_CContact"]);
if (dr["SDC_Content"] != DBNull.Value) sD_Contract.SDC_Content = Convert.ToString(dr["SDC_Content"]);
if (dr["SDC_Description"] != DBNull.Value) sD_Contract.SDC_Description = Convert.ToString(dr["SDC_Description"]);
if (dr["SDC_Control"] != DBNull.Value) sD_Contract.SDC_Control = Convert.ToString(dr["SDC_Control"]);
if (dr["SDC_IsAFor"] != DBNull.Value) sD_Contract.SDC_IsAFor = Convert.ToString(dr["SDC_IsAFor"]);
if (dr["Audit1CurAudit"] != DBNull.Value) sD_Contract.Audit1CurAudit = Convert.ToString(dr["Audit1CurAudit"]);
if (dr["Audit1Stat"] != DBNull.Value) sD_Contract.Audit1Stat = Convert.ToString(dr["Audit1Stat"]);
if (dr["Audit1Date"] != DBNull.Value) sD_Contract.Audit1Date = Convert.ToDateTime(dr["Audit1Date"]);
if (dr["Audit1Owner"] != DBNull.Value) sD_Contract.Audit1Owner = Convert.ToString(dr["Audit1Owner"]);
if (dr["AuditCurAudit"] != DBNull.Value) sD_Contract.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
if (dr["AuditStat"] != DBNull.Value) sD_Contract.AuditStat = Convert.ToString(dr["AuditStat"]);
if (dr["AuditDate"] != DBNull.Value) sD_Contract.AuditDate = Convert.ToDateTime(dr["AuditDate"]);
if (dr["AuditOwner"] != DBNull.Value) sD_Contract.AuditOwner = Convert.ToString(dr["AuditOwner"]);
if (dr["Stat"] != DBNull.Value) sD_Contract.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["CreateDate"] != DBNull.Value) sD_Contract.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["UpdateDate"] != DBNull.Value) sD_Contract.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
if (dr["DeleteDate"] != DBNull.Value) sD_Contract.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
if (dr["CreateOwner"] != DBNull.Value) sD_Contract.CreateOwner = Convert.ToString(dr["CreateOwner"]);
if (dr["SDC_Stat"] != DBNull.Value) sD_Contract.SDC_Stat = Convert.ToString(dr["SDC_Stat"]);
if (dr["SDC_Type"] != DBNull.Value) sD_Contract.SDC_Type = Convert.ToString(dr["SDC_Type"]);
if (dr["SDC_Company"] != DBNull.Value) sD_Contract.SDC_Company = Convert.ToString(dr["SDC_Company"]);
if (dr["SDC_CompanyCode"] != DBNull.Value) sD_Contract.SDC_CompanyCode = Convert.ToString(dr["SDC_CompanyCode"]);
if (dr["SDC_TotalSend"] != DBNull.Value) sD_Contract.SDC_TotalSend = Convert.ToString(dr["SDC_TotalSend"]);
if (dr["SDC_LastSend"] != DBNull.Value) sD_Contract.SDC_LastSend = Convert.ToString(dr["SDC_LastSend"]);
if (dr["SDC_LastDate"] != DBNull.Value) sD_Contract.SDC_LastDate = Convert.ToDateTime(dr["SDC_LastDate"]);
if (dr["SDC_Return"] != DBNull.Value) sD_Contract.SDC_Return = Convert.ToString(dr["SDC_Return"]);
if (dr["SDC_StartSend"] != DBNull.Value) sD_Contract.SDC_StartSend = Convert.ToDateTime(dr["SDC_StartSend"]);
if (dr["SDC_EndSend"] != DBNull.Value) sD_Contract.SDC_EndSend = Convert.ToDateTime(dr["SDC_EndSend"]);
if (dr["SDC_TotalDate"] != DBNull.Value) sD_Contract.SDC_TotalDate = Convert.ToString(dr["SDC_TotalDate"]);
if (dr["SDC_AgreeQuantity"] != DBNull.Value) sD_Contract.SDC_AgreeQuantity = Convert.ToString(dr["SDC_AgreeQuantity"]);
if (dr["SDC_PlanQuantity"] != DBNull.Value) sD_Contract.SDC_PlanQuantity = Convert.ToString(dr["SDC_PlanQuantity"]);
if (dr["SDC_SupQuantity"] != DBNull.Value) sD_Contract.SDC_SupQuantity = Convert.ToString(dr["SDC_SupQuantity"]);
if (dr["SDC_TotalMoney"] != DBNull.Value) sD_Contract.SDC_TotalMoney = Convert.ToDecimal(dr["SDC_TotalMoney"]);
if (dr["SDC_PayMoney"] != DBNull.Value) sD_Contract.SDC_PayMoney = Convert.ToDecimal(dr["SDC_PayMoney"]);
if (dr["SDC_SPayMoney"] != DBNull.Value) sD_Contract.SDC_SPayMoney = Convert.ToDecimal(dr["SDC_SPayMoney"]);
if (dr["SDC_PayType"] != DBNull.Value) sD_Contract.SDC_PayType = Convert.ToString(dr["SDC_PayType"]);
if (dr["SDC_BType"] != DBNull.Value) sD_Contract.SDC_BType = Convert.ToString(dr["SDC_BType"]);
if (dr["SDC_BTypeName"] != DBNull.Value) sD_Contract.SDC_BTypeName = Convert.ToString(dr["SDC_BTypeName"]);
ret.Add(sD_Contract);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return ret;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(SD_Contract model,bool IsValid)
{
bool result = false;
var e = new ModelExceptions();
if(e.IsValid && IsValid){
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(SD_Contract model,bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(SD_Contract model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
public ActionResult ContractPreOperation(FormCollection formCollect)
{
var flag = false;
SD_Contract conMain = new SD_Contract();
bmHelper.BindFormToModel<SD_Contract>(conMain, formCollect);
if (formCollect["ContractFormoper"] == "edit")
{
//点击提交
if (formCollect["ContractEditType"] == "valid")
{
///提交时改变状态，进入审核状态
if (formCollect["ContractType"] == "Audit")
{
conMain.AuditStat = AudtiOperaTypeEnum.Auditing.ToString();
conMain.AuditCurAudit = new Bll_Audit().GetVerifyTemplateFirstNode(AuditModuleEnum.ContractAudit.ToString()).VT_VerifyNode_Code;
conMain.SDC_Stat = ContractTypeEnum.Valid.ToString();
}
conMain.SDC_iType = DataITypeEnum.PreCust.ToString();
conMain.SDC_ID = conInstance.GetModel(" and SDC_Code='" + conMain.SDC_Code + "' and SDC_iType='PreCust' ").SDC_ID;
if (conInstance.Update(conMain))
{
flag = true;
}
}//点击草稿
else
{
conMain.SDC_ID = conInstance.GetModel(" and SDC_Code='" + conMain.SDC_Code + "' and SDC_iType='PreCust' ").SDC_ID;
conMain.SDC_iType = DataITypeEnum.PreCust.ToString();
conMain.SDC_Stat = ContractTypeEnum.Draft.ToString();
if (conInstance.Update(conMain))
{
flag = true;
}
}
//日志记录
this.OpLog(this.GetControllerName(), "修改:预审合同,编码:" + conMain.SDC_Code, flag.ToString());
}
else //添加预审合同
{
var temp = conInstance.GetModelByCode(conMain.SDC_Code);
if (temp != null)
{
var id = temp.SDC_ID;
conMain.SDC_ID = id;
conMain.SDC_iType = formCollect["ContractEditType"];
conMain.SDC_Stat = ContractTypeEnum.Draft.ToString();//草稿状态
if (conInstance.Update(conMain))
{
flag = true;
}
}
else
{
conMain.SDC_iType = formCollect["ContractEditType"];
conMain.SDC_Stat = ContractTypeEnum.Draft.ToString();//草稿状态
if (conInstance.Insert(conMain))
{
flag = true;
}
}
//日志记录
this.OpLog(this.GetControllerName(), "添加:预审合同,编码:" + conMain.SDC_Code, flag.ToString());
//conMain.SDC_iType = DataITypeEnum.PreCust.ToString();
//conMain.SDC_Stat = ContractTypeEnum.Draft.ToString();
//if (conInstance.Insert(conMain))
//{
// flag = true;
//}
}
if (flag)
{
return new JsonResult { Data = new { result = "success" } };
}
else
{
return new JsonResult { Data = new { result = "fail" } };
}
}
public ActionResult QEditPreContract(string id)
{
string code = Request["code"];
ViewData["CType"] = id;
string tab = "#tabs-" + Request["tab"];
string view = Request["view"];
if (string.IsNullOrEmpty(view))
{
ViewData["view"] = "";
}
else
{
ViewData["view"] = view;
}
SD_Contract model = new SD_Contract();
if (!String.IsNullOrEmpty(code))
{
model = conInstance.GetModel(" and SDC_Code='" + code + "' and SDC_iType='" + id + "' ");
}
this.ViewData.Add("tab", tab);
return View(model);
}
public ActionResult QEditContract(string id)
{
string code = Request["code"];
string view = Request["view"];
string tab ="#tabs-" +Request["tab"];
//读出字典
List<Bse_Dict> root = dictInstance.GetListByCode(" AND Dict_Key!=Dict_Code AND Dict_Key='PRODUCT' ").OrderBy(o => o.Dict_Order).ToList();
ViewData["Product"] = root;
ViewData["view"] = !string.IsNullOrEmpty(view) ? "view" : "";
SD_Contract model = new SD_Contract();
if (!String.IsNullOrEmpty(code))
{
model = conInstance.GetModel(" and SDC_Code='" + code + "' ");
}
this.ViewData.Add("tab", tab);
return View(model);
}