/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public PC_Plan GetModel(string strCondition)
{
List<PC_Plan> list = instance.GetListByWhere(strCondition);
PC_Plan model = new PC_Plan();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 添加生产计划 PC_Plan对象(即:一条记录)
/// </summary>
public object AddWithReturn(PC_Plan pC_Plan)
{
string sql = "INSERT INTO PC_Plan (PCP_PCode,PCP_SCode,PCP_Name,PCP_CPCode,PCP_PRCode,PCP_CCode,PCP_Part,PCP_Slump,PCP_Addr,PCP_IsPipe,PCP_PLCode,PCP_Leve,PCP_Impervious,PCP_SPC,PCP_Special1,PCP_Special2,PCP_Special3,PCP_Special4,PCP_Special5,PCP_PDate,PCP_RDate,PCP_POwner,PCP_POwnerName,PCP_Date,PCP_CureStep,PCP_NextStep,PCP_IsTech,PCP_IsStart,PCP_PMNum,PCP_PUNum,PCP_PINum,PCP_PJNum,PCP_PTNum,PCP_PWNum,PCP_PPNum,PCP_PRNum,PCP_PTRNum,PCP_PPRNum,PCP_PPMNum,PCP_PTMNum,PCP_TechType,PCP_Limit,PCP_Frequence,PCP_LastDate,PCP_LastNo,PCP_Transpot,PCP_Order,PCP_DBack,PCP_Status,PCP_Bak,Stat,CreateDate,UpdateDate,DeleteDate,PCP_Udef1,PCP_Udef2,PCP_Udef3,PCP_Udef4,PCP_Udef5,PCP_Udef6,PCP_Udef7,AuditCurAudit,AuditStat,PCP_LNum,PCP_ANum,PCP_Price,PCP_Sum,PCP_TankerFee,PCP_PumpFee,PCP_Operator,PCP_Schdule,PCP_Station,PCP_StatonName) VALUES (@PCP_PCode,@PCP_SCode,@PCP_Name,@PCP_CPCode,@PCP_PRCode,@PCP_CCode,@PCP_Part,@PCP_Slump,@PCP_Addr,@PCP_IsPipe,@PCP_PLCode,@PCP_Leve,@PCP_Impervious,@PCP_SPC,@PCP_Special1,@PCP_Special2,@PCP_Special3,@PCP_Special4,@PCP_Special5,@PCP_PDate,@PCP_RDate,@PCP_POwner,@PCP_POwnerName,@PCP_Date,@PCP_CureStep,@PCP_NextStep,@PCP_IsTech,@PCP_IsStart,@PCP_PMNum,@PCP_PUNum,@PCP_PINum,@PCP_PJNum,@PCP_PTNum,@PCP_PWNum,@PCP_PPNum,@PCP_PRNum,@PCP_PTRNum,@PCP_PPRNum,@PCP_PPMNum,@PCP_PTMNum,@PCP_TechType,@PCP_Limit,@PCP_Frequence,@PCP_LastDate,@PCP_LastNo,@PCP_Transpot,@PCP_Order,@PCP_DBack,@PCP_Status,@PCP_Bak,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@PCP_Udef1,@PCP_Udef2,@PCP_Udef3,@PCP_Udef4,@PCP_Udef5,@PCP_Udef6,@PCP_Udef7,@AuditCurAudit,@AuditStat,@PCP_LNum,@PCP_ANum,@PCP_Price,@PCP_Sum,@PCP_TankerFee,@PCP_PumpFee,@PCP_Operator,@PCP_Schdule,@PCP_Station,@PCP_StatonName);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(pC_Plan.PCP_PCode))
{
idb.AddParameter("@PCP_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PCode", pC_Plan.PCP_PCode);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_SCode))
{
idb.AddParameter("@PCP_SCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_SCode", pC_Plan.PCP_SCode);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Name))
{
idb.AddParameter("@PCP_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Name", pC_Plan.PCP_Name);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_CPCode))
{
idb.AddParameter("@PCP_CPCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_CPCode", pC_Plan.PCP_CPCode);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PRCode))
{
idb.AddParameter("@PCP_PRCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PRCode", pC_Plan.PCP_PRCode);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_CCode))
{
idb.AddParameter("@PCP_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_CCode", pC_Plan.PCP_CCode);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Part))
{
idb.AddParameter("@PCP_Part", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Part", pC_Plan.PCP_Part);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Slump))
{
idb.AddParameter("@PCP_Slump", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Slump", pC_Plan.PCP_Slump);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Addr))
{
idb.AddParameter("@PCP_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Addr", pC_Plan.PCP_Addr);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_IsPipe))
{
idb.AddParameter("@PCP_IsPipe", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_IsPipe", pC_Plan.PCP_IsPipe);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PLCode))
{
idb.AddParameter("@PCP_PLCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PLCode", pC_Plan.PCP_PLCode);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Leve))
{
idb.AddParameter("@PCP_Leve", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Leve", pC_Plan.PCP_Leve);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Impervious))
{
idb.AddParameter("@PCP_Impervious", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Impervious", pC_Plan.PCP_Impervious);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_SPC))
{
idb.AddParameter("@PCP_SPC", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_SPC", pC_Plan.PCP_SPC);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Special1))
{
idb.AddParameter("@PCP_Special1", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special1", pC_Plan.PCP_Special1);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Special2))
{
idb.AddParameter("@PCP_Special2", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special2", pC_Plan.PCP_Special2);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Special3))
{
idb.AddParameter("@PCP_Special3", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special3", pC_Plan.PCP_Special3);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Special4))
{
idb.AddParameter("@PCP_Special4", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special4", pC_Plan.PCP_Special4);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Special5))
{
idb.AddParameter("@PCP_Special5", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special5", pC_Plan.PCP_Special5);
}
if (pC_Plan.PCP_PDate == DateTime.MinValue)
{
idb.AddParameter("@PCP_PDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PDate", pC_Plan.PCP_PDate);
}
if (pC_Plan.PCP_RDate == DateTime.MinValue)
{
idb.AddParameter("@PCP_RDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_RDate", pC_Plan.PCP_RDate);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_POwner))
{
idb.AddParameter("@PCP_POwner", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_POwner", pC_Plan.PCP_POwner);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_POwnerName))
{
idb.AddParameter("@PCP_POwnerName", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_POwnerName", pC_Plan.PCP_POwnerName);
}
if (pC_Plan.PCP_Date == DateTime.MinValue)
{
idb.AddParameter("@PCP_Date", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Date", pC_Plan.PCP_Date);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_CureStep))
{
idb.AddParameter("@PCP_CureStep", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_CureStep", pC_Plan.PCP_CureStep);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_NextStep))
{
idb.AddParameter("@PCP_NextStep", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_NextStep", pC_Plan.PCP_NextStep);
}
if (pC_Plan.PCP_IsTech == 0)
{
idb.AddParameter("@PCP_IsTech", 0);
}
else
{
idb.AddParameter("@PCP_IsTech", pC_Plan.PCP_IsTech);
}
if (pC_Plan.PCP_IsStart == 0)
{
idb.AddParameter("@PCP_IsStart", 0);
}
else
{
idb.AddParameter("@PCP_IsStart", pC_Plan.PCP_IsStart);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PMNum))
{
idb.AddParameter("@PCP_PMNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PMNum", pC_Plan.PCP_PMNum);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PUNum))
{
idb.AddParameter("@PCP_PUNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PUNum", pC_Plan.PCP_PUNum);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PINum))
{
idb.AddParameter("@PCP_PINum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PINum", pC_Plan.PCP_PINum);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PJNum))
{
idb.AddParameter("@PCP_PJNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PJNum", pC_Plan.PCP_PJNum);
}
if (pC_Plan.PCP_PTNum == 0)
{
idb.AddParameter("@PCP_PTNum", 0);
}
else
{
idb.AddParameter("@PCP_PTNum", pC_Plan.PCP_PTNum);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_PWNum))
{
idb.AddParameter("@PCP_PWNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PWNum", pC_Plan.PCP_PWNum);
}
if (pC_Plan.PCP_PPNum == 0)
{
idb.AddParameter("@PCP_PPNum", 0);
}
else
{
idb.AddParameter("@PCP_PPNum", pC_Plan.PCP_PPNum);
}
if (pC_Plan.PCP_PRNum == 0)
{
idb.AddParameter("@PCP_PRNum", 0);
}
else
{
idb.AddParameter("@PCP_PRNum", pC_Plan.PCP_PRNum);
}
if (pC_Plan.PCP_PTRNum == 0)
{
idb.AddParameter("@PCP_PTRNum", 0);
}
else
{
idb.AddParameter("@PCP_PTRNum", pC_Plan.PCP_PTRNum);
}
if (pC_Plan.PCP_PPRNum == 0)
{
idb.AddParameter("@PCP_PPRNum", 0);
}
else
{
idb.AddParameter("@PCP_PPRNum", pC_Plan.PCP_PPRNum);
}
if (pC_Plan.PCP_PPMNum == 0)
{
idb.AddParameter("@PCP_PPMNum", 0);
}
else
{
idb.AddParameter("@PCP_PPMNum", pC_Plan.PCP_PPMNum);
}
if (pC_Plan.PCP_PTMNum == 0)
{
idb.AddParameter("@PCP_PTMNum", 0);
}
else
{
idb.AddParameter("@PCP_PTMNum", pC_Plan.PCP_PTMNum);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_TechType))
{
idb.AddParameter("@PCP_TechType", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_TechType", pC_Plan.PCP_TechType);
}
if (pC_Plan.PCP_Limit == 0)
{
idb.AddParameter("@PCP_Limit", 0);
}
else
{
idb.AddParameter("@PCP_Limit", pC_Plan.PCP_Limit);
}
if (pC_Plan.PCP_Frequence == 0)
{
idb.AddParameter("@PCP_Frequence", 0);
}
else
{
idb.AddParameter("@PCP_Frequence", pC_Plan.PCP_Frequence);
}
if (pC_Plan.PCP_LastDate == DateTime.MinValue)
{
idb.AddParameter("@PCP_LastDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_LastDate", pC_Plan.PCP_LastDate);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_LastNo))
{
idb.AddParameter("@PCP_LastNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_LastNo", pC_Plan.PCP_LastNo);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Transpot))
{
idb.AddParameter("@PCP_Transpot", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Transpot", pC_Plan.PCP_Transpot);
}
if (pC_Plan.PCP_Order == 0)
{
idb.AddParameter("@PCP_Order", 0);
}
else
{
idb.AddParameter("@PCP_Order", pC_Plan.PCP_Order);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_DBack))
{
idb.AddParameter("@PCP_DBack", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_DBack", pC_Plan.PCP_DBack);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Status))
{
idb.AddParameter("@PCP_Status", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Status", pC_Plan.PCP_Status);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Bak))
{
idb.AddParameter("@PCP_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Bak", pC_Plan.PCP_Bak);
}
if (pC_Plan.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_Plan.Stat);
}
if (pC_Plan.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_Plan.CreateDate);
}
if (pC_Plan.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_Plan.UpdateDate);
}
if (pC_Plan.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_Plan.DeleteDate);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef1))
{
idb.AddParameter("@PCP_Udef1", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef1", pC_Plan.PCP_Udef1);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef2))
{
idb.AddParameter("@PCP_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef2", pC_Plan.PCP_Udef2);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef3))
{
idb.AddParameter("@PCP_Udef3", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef3", pC_Plan.PCP_Udef3);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef4))
{
idb.AddParameter("@PCP_Udef4", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef4", pC_Plan.PCP_Udef4);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef5))
{
idb.AddParameter("@PCP_Udef5", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef5", pC_Plan.PCP_Udef5);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef6))
{
idb.AddParameter("@PCP_Udef6", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef6", pC_Plan.PCP_Udef6);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef7))
{
idb.AddParameter("@PCP_Udef7", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef7", pC_Plan.PCP_Udef7);
}
if (string.IsNullOrEmpty(pC_Plan.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", pC_Plan.AuditCurAudit);
}
if (string.IsNullOrEmpty(pC_Plan.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", pC_Plan.AuditStat);
}
if (pC_Plan.PCP_LNum == 0)
{
idb.AddParameter("@PCP_LNum", 0);
}
else
{
idb.AddParameter("@PCP_LNum", pC_Plan.PCP_LNum);
}
if (pC_Plan.PCP_ANum == 0)
{
idb.AddParameter("@PCP_ANum", 0);
}
else
{
idb.AddParameter("@PCP_ANum", pC_Plan.PCP_ANum);
}
if (pC_Plan.PCP_Price == 0)
{
idb.AddParameter("@PCP_Price", 0);
}
else
{
idb.AddParameter("@PCP_Price", pC_Plan.PCP_Price);
}
if (pC_Plan.PCP_Sum == 0)
{
idb.AddParameter("@PCP_Sum", 0);
}
else
{
idb.AddParameter("@PCP_Sum", pC_Plan.PCP_Sum);
}
if (pC_Plan.PCP_TankerFee == 0)
{
idb.AddParameter("@PCP_TankerFee", 0);
}
else
{
idb.AddParameter("@PCP_TankerFee", pC_Plan.PCP_TankerFee);
}
if (pC_Plan.PCP_PumpFee == 0)
{
idb.AddParameter("@PCP_PumpFee", 0);
}
else
{
idb.AddParameter("@PCP_PumpFee", pC_Plan.PCP_PumpFee);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Operator))
{
idb.AddParameter("@PCP_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Operator", pC_Plan.PCP_Operator);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Schdule))
{
idb.AddParameter("@PCP_Schdule", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Schdule", pC_Plan.PCP_Schdule);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_Station))
{
idb.AddParameter("@PCP_Station", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Station", pC_Plan.PCP_Station);
}
if (string.IsNullOrEmpty(pC_Plan.PCP_StatonName))
{
idb.AddParameter("@PCP_StatonName", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_StatonName", pC_Plan.PCP_StatonName);
}
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_Plan对象(即:一条记录
/// </summary>
public int Update(PC_Plan pC_Plan)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE PC_Plan SET ");
if(pC_Plan.PCP_PCode_IsChanged){sbParameter.Append("PCP_PCode=@PCP_PCode, ");}
if(pC_Plan.PCP_SCode_IsChanged){sbParameter.Append("PCP_SCode=@PCP_SCode, ");}
if(pC_Plan.PCP_Name_IsChanged){sbParameter.Append("PCP_Name=@PCP_Name, ");}
if(pC_Plan.PCP_CPCode_IsChanged){sbParameter.Append("PCP_CPCode=@PCP_CPCode, ");}
if(pC_Plan.PCP_PRCode_IsChanged){sbParameter.Append("PCP_PRCode=@PCP_PRCode, ");}
if(pC_Plan.PCP_CCode_IsChanged){sbParameter.Append("PCP_CCode=@PCP_CCode, ");}
if(pC_Plan.PCP_Part_IsChanged){sbParameter.Append("PCP_Part=@PCP_Part, ");}
if(pC_Plan.PCP_Slump_IsChanged){sbParameter.Append("PCP_Slump=@PCP_Slump, ");}
if(pC_Plan.PCP_Addr_IsChanged){sbParameter.Append("PCP_Addr=@PCP_Addr, ");}
if(pC_Plan.PCP_IsPipe_IsChanged){sbParameter.Append("PCP_IsPipe=@PCP_IsPipe, ");}
if(pC_Plan.PCP_PLCode_IsChanged){sbParameter.Append("PCP_PLCode=@PCP_PLCode, ");}
if(pC_Plan.PCP_Leve_IsChanged){sbParameter.Append("PCP_Leve=@PCP_Leve, ");}
if(pC_Plan.PCP_Impervious_IsChanged){sbParameter.Append("PCP_Impervious=@PCP_Impervious, ");}
if(pC_Plan.PCP_SPC_IsChanged){sbParameter.Append("PCP_SPC=@PCP_SPC, ");}
if(pC_Plan.PCP_Special1_IsChanged){sbParameter.Append("PCP_Special1=@PCP_Special1, ");}
if(pC_Plan.PCP_Special2_IsChanged){sbParameter.Append("PCP_Special2=@PCP_Special2, ");}
if(pC_Plan.PCP_Special3_IsChanged){sbParameter.Append("PCP_Special3=@PCP_Special3, ");}
if(pC_Plan.PCP_Special4_IsChanged){sbParameter.Append("PCP_Special4=@PCP_Special4, ");}
if(pC_Plan.PCP_Special5_IsChanged){sbParameter.Append("PCP_Special5=@PCP_Special5, ");}
if(pC_Plan.PCP_PDate_IsChanged){sbParameter.Append("PCP_PDate=@PCP_PDate, ");}
if(pC_Plan.PCP_RDate_IsChanged){sbParameter.Append("PCP_RDate=@PCP_RDate, ");}
if(pC_Plan.PCP_POwner_IsChanged){sbParameter.Append("PCP_POwner=@PCP_POwner, ");}
if(pC_Plan.PCP_POwnerName_IsChanged){sbParameter.Append("PCP_POwnerName=@PCP_POwnerName, ");}
if(pC_Plan.PCP_Date_IsChanged){sbParameter.Append("PCP_Date=@PCP_Date, ");}
if(pC_Plan.PCP_CureStep_IsChanged){sbParameter.Append("PCP_CureStep=@PCP_CureStep, ");}
if(pC_Plan.PCP_NextStep_IsChanged){sbParameter.Append("PCP_NextStep=@PCP_NextStep, ");}
if(pC_Plan.PCP_IsTech_IsChanged){sbParameter.Append("PCP_IsTech=@PCP_IsTech, ");}
if(pC_Plan.PCP_IsStart_IsChanged){sbParameter.Append("PCP_IsStart=@PCP_IsStart, ");}
if(pC_Plan.PCP_PMNum_IsChanged){sbParameter.Append("PCP_PMNum=@PCP_PMNum, ");}
if(pC_Plan.PCP_PUNum_IsChanged){sbParameter.Append("PCP_PUNum=@PCP_PUNum, ");}
if(pC_Plan.PCP_PINum_IsChanged){sbParameter.Append("PCP_PINum=@PCP_PINum, ");}
if(pC_Plan.PCP_PJNum_IsChanged){sbParameter.Append("PCP_PJNum=@PCP_PJNum, ");}
if(pC_Plan.PCP_PTNum_IsChanged){sbParameter.Append("PCP_PTNum=@PCP_PTNum, ");}
if(pC_Plan.PCP_PWNum_IsChanged){sbParameter.Append("PCP_PWNum=@PCP_PWNum, ");}
if(pC_Plan.PCP_PPNum_IsChanged){sbParameter.Append("PCP_PPNum=@PCP_PPNum, ");}
if(pC_Plan.PCP_PRNum_IsChanged){sbParameter.Append("PCP_PRNum=@PCP_PRNum, ");}
if(pC_Plan.PCP_PTRNum_IsChanged){sbParameter.Append("PCP_PTRNum=@PCP_PTRNum, ");}
if(pC_Plan.PCP_PPRNum_IsChanged){sbParameter.Append("PCP_PPRNum=@PCP_PPRNum, ");}
if(pC_Plan.PCP_PPMNum_IsChanged){sbParameter.Append("PCP_PPMNum=@PCP_PPMNum, ");}
if(pC_Plan.PCP_PTMNum_IsChanged){sbParameter.Append("PCP_PTMNum=@PCP_PTMNum, ");}
if(pC_Plan.PCP_TechType_IsChanged){sbParameter.Append("PCP_TechType=@PCP_TechType, ");}
if(pC_Plan.PCP_Limit_IsChanged){sbParameter.Append("PCP_Limit=@PCP_Limit, ");}
if(pC_Plan.PCP_Frequence_IsChanged){sbParameter.Append("PCP_Frequence=@PCP_Frequence, ");}
if(pC_Plan.PCP_LastDate_IsChanged){sbParameter.Append("PCP_LastDate=@PCP_LastDate, ");}
if(pC_Plan.PCP_LastNo_IsChanged){sbParameter.Append("PCP_LastNo=@PCP_LastNo, ");}
if(pC_Plan.PCP_Transpot_IsChanged){sbParameter.Append("PCP_Transpot=@PCP_Transpot, ");}
if(pC_Plan.PCP_Order_IsChanged){sbParameter.Append("PCP_Order=@PCP_Order, ");}
if(pC_Plan.PCP_DBack_IsChanged){sbParameter.Append("PCP_DBack=@PCP_DBack, ");}
if(pC_Plan.PCP_Status_IsChanged){sbParameter.Append("PCP_Status=@PCP_Status, ");}
if(pC_Plan.PCP_Bak_IsChanged){sbParameter.Append("PCP_Bak=@PCP_Bak, ");}
if(pC_Plan.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(pC_Plan.CreateDate_IsChanged){sbParameter.Append("CreateDate=@CreateDate, ");}
if(pC_Plan.UpdateDate_IsChanged){sbParameter.Append("UpdateDate=@UpdateDate, ");}
if(pC_Plan.DeleteDate_IsChanged){sbParameter.Append("DeleteDate=@DeleteDate, ");}
if(pC_Plan.PCP_Udef1_IsChanged){sbParameter.Append("PCP_Udef1=@PCP_Udef1, ");}
if(pC_Plan.PCP_Udef2_IsChanged){sbParameter.Append("PCP_Udef2=@PCP_Udef2, ");}
if(pC_Plan.PCP_Udef3_IsChanged){sbParameter.Append("PCP_Udef3=@PCP_Udef3, ");}
if(pC_Plan.PCP_Udef4_IsChanged){sbParameter.Append("PCP_Udef4=@PCP_Udef4, ");}
if(pC_Plan.PCP_Udef5_IsChanged){sbParameter.Append("PCP_Udef5=@PCP_Udef5, ");}
if(pC_Plan.PCP_Udef6_IsChanged){sbParameter.Append("PCP_Udef6=@PCP_Udef6, ");}
if(pC_Plan.PCP_Udef7_IsChanged){sbParameter.Append("PCP_Udef7=@PCP_Udef7, ");}
if(pC_Plan.AuditCurAudit_IsChanged){sbParameter.Append("AuditCurAudit=@AuditCurAudit, ");}
if(pC_Plan.AuditStat_IsChanged){sbParameter.Append("AuditStat=@AuditStat, ");}
if(pC_Plan.PCP_LNum_IsChanged){sbParameter.Append("PCP_LNum=@PCP_LNum, ");}
if(pC_Plan.PCP_ANum_IsChanged){sbParameter.Append("PCP_ANum=@PCP_ANum, ");}
if(pC_Plan.PCP_Price_IsChanged){sbParameter.Append("PCP_Price=@PCP_Price, ");}
if(pC_Plan.PCP_Sum_IsChanged){sbParameter.Append("PCP_Sum=@PCP_Sum, ");}
if(pC_Plan.PCP_TankerFee_IsChanged){sbParameter.Append("PCP_TankerFee=@PCP_TankerFee, ");}
if(pC_Plan.PCP_PumpFee_IsChanged){sbParameter.Append("PCP_PumpFee=@PCP_PumpFee, ");}
if(pC_Plan.PCP_Operator_IsChanged){sbParameter.Append("PCP_Operator=@PCP_Operator, ");}
if(pC_Plan.PCP_Schdule_IsChanged){sbParameter.Append("PCP_Schdule=@PCP_Schdule, ");}
if(pC_Plan.PCP_Station_IsChanged){sbParameter.Append("PCP_Station=@PCP_Station, ");}
if(pC_Plan.PCP_StatonName_IsChanged){sbParameter.Append("PCP_StatonName=@PCP_StatonName ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PCP_ID=@PCP_ID; " );
string sql=sb.ToString();
if(pC_Plan.PCP_PCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PCode))
{
idb.AddParameter("@PCP_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PCode", pC_Plan.PCP_PCode);
}
}
if(pC_Plan.PCP_SCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_SCode))
{
idb.AddParameter("@PCP_SCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_SCode", pC_Plan.PCP_SCode);
}
}
if(pC_Plan.PCP_Name_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Name))
{
idb.AddParameter("@PCP_Name", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Name", pC_Plan.PCP_Name);
}
}
if(pC_Plan.PCP_CPCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_CPCode))
{
idb.AddParameter("@PCP_CPCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_CPCode", pC_Plan.PCP_CPCode);
}
}
if(pC_Plan.PCP_PRCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PRCode))
{
idb.AddParameter("@PCP_PRCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PRCode", pC_Plan.PCP_PRCode);
}
}
if(pC_Plan.PCP_CCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_CCode))
{
idb.AddParameter("@PCP_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_CCode", pC_Plan.PCP_CCode);
}
}
if(pC_Plan.PCP_Part_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Part))
{
idb.AddParameter("@PCP_Part", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Part", pC_Plan.PCP_Part);
}
}
if(pC_Plan.PCP_Slump_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Slump))
{
idb.AddParameter("@PCP_Slump", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Slump", pC_Plan.PCP_Slump);
}
}
if(pC_Plan.PCP_Addr_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Addr))
{
idb.AddParameter("@PCP_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Addr", pC_Plan.PCP_Addr);
}
}
if(pC_Plan.PCP_IsPipe_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_IsPipe))
{
idb.AddParameter("@PCP_IsPipe", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_IsPipe", pC_Plan.PCP_IsPipe);
}
}
if(pC_Plan.PCP_PLCode_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PLCode))
{
idb.AddParameter("@PCP_PLCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PLCode", pC_Plan.PCP_PLCode);
}
}
if(pC_Plan.PCP_Leve_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Leve))
{
idb.AddParameter("@PCP_Leve", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Leve", pC_Plan.PCP_Leve);
}
}
if(pC_Plan.PCP_Impervious_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Impervious))
{
idb.AddParameter("@PCP_Impervious", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Impervious", pC_Plan.PCP_Impervious);
}
}
if(pC_Plan.PCP_SPC_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_SPC))
{
idb.AddParameter("@PCP_SPC", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_SPC", pC_Plan.PCP_SPC);
}
}
if(pC_Plan.PCP_Special1_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Special1))
{
idb.AddParameter("@PCP_Special1", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special1", pC_Plan.PCP_Special1);
}
}
if(pC_Plan.PCP_Special2_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Special2))
{
idb.AddParameter("@PCP_Special2", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special2", pC_Plan.PCP_Special2);
}
}
if(pC_Plan.PCP_Special3_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Special3))
{
idb.AddParameter("@PCP_Special3", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special3", pC_Plan.PCP_Special3);
}
}
if(pC_Plan.PCP_Special4_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Special4))
{
idb.AddParameter("@PCP_Special4", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special4", pC_Plan.PCP_Special4);
}
}
if(pC_Plan.PCP_Special5_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Special5))
{
idb.AddParameter("@PCP_Special5", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Special5", pC_Plan.PCP_Special5);
}
}
if(pC_Plan.PCP_PDate_IsChanged)
{
if (pC_Plan.PCP_PDate == DateTime.MinValue)
{
idb.AddParameter("@PCP_PDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PDate", pC_Plan.PCP_PDate);
}
}
if(pC_Plan.PCP_RDate_IsChanged)
{
if (pC_Plan.PCP_RDate == DateTime.MinValue)
{
idb.AddParameter("@PCP_RDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_RDate", pC_Plan.PCP_RDate);
}
}
if(pC_Plan.PCP_POwner_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_POwner))
{
idb.AddParameter("@PCP_POwner", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_POwner", pC_Plan.PCP_POwner);
}
}
if(pC_Plan.PCP_POwnerName_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_POwnerName))
{
idb.AddParameter("@PCP_POwnerName", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_POwnerName", pC_Plan.PCP_POwnerName);
}
}
if(pC_Plan.PCP_Date_IsChanged)
{
if (pC_Plan.PCP_Date == DateTime.MinValue)
{
idb.AddParameter("@PCP_Date", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Date", pC_Plan.PCP_Date);
}
}
if(pC_Plan.PCP_CureStep_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_CureStep))
{
idb.AddParameter("@PCP_CureStep", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_CureStep", pC_Plan.PCP_CureStep);
}
}
if(pC_Plan.PCP_NextStep_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_NextStep))
{
idb.AddParameter("@PCP_NextStep", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_NextStep", pC_Plan.PCP_NextStep);
}
}
if(pC_Plan.PCP_IsTech_IsChanged)
{
if (pC_Plan.PCP_IsTech == 0)
{
idb.AddParameter("@PCP_IsTech", 0);
}
else
{
idb.AddParameter("@PCP_IsTech", pC_Plan.PCP_IsTech);
}
}
if(pC_Plan.PCP_IsStart_IsChanged)
{
if (pC_Plan.PCP_IsStart == 0)
{
idb.AddParameter("@PCP_IsStart", 0);
}
else
{
idb.AddParameter("@PCP_IsStart", pC_Plan.PCP_IsStart);
}
}
if(pC_Plan.PCP_PMNum_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PMNum))
{
idb.AddParameter("@PCP_PMNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PMNum", pC_Plan.PCP_PMNum);
}
}
if(pC_Plan.PCP_PUNum_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PUNum))
{
idb.AddParameter("@PCP_PUNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PUNum", pC_Plan.PCP_PUNum);
}
}
if(pC_Plan.PCP_PINum_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PINum))
{
idb.AddParameter("@PCP_PINum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PINum", pC_Plan.PCP_PINum);
}
}
if(pC_Plan.PCP_PJNum_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PJNum))
{
idb.AddParameter("@PCP_PJNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PJNum", pC_Plan.PCP_PJNum);
}
}
if(pC_Plan.PCP_PTNum_IsChanged)
{
if (pC_Plan.PCP_PTNum == 0)
{
idb.AddParameter("@PCP_PTNum", 0);
}
else
{
idb.AddParameter("@PCP_PTNum", pC_Plan.PCP_PTNum);
}
}
if(pC_Plan.PCP_PWNum_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_PWNum))
{
idb.AddParameter("@PCP_PWNum", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_PWNum", pC_Plan.PCP_PWNum);
}
}
if(pC_Plan.PCP_PPNum_IsChanged)
{
if (pC_Plan.PCP_PPNum == 0)
{
idb.AddParameter("@PCP_PPNum", 0);
}
else
{
idb.AddParameter("@PCP_PPNum", pC_Plan.PCP_PPNum);
}
}
if(pC_Plan.PCP_PRNum_IsChanged)
{
if (pC_Plan.PCP_PRNum == 0)
{
idb.AddParameter("@PCP_PRNum", 0);
}
else
{
idb.AddParameter("@PCP_PRNum", pC_Plan.PCP_PRNum);
}
}
if(pC_Plan.PCP_PTRNum_IsChanged)
{
if (pC_Plan.PCP_PTRNum == 0)
{
idb.AddParameter("@PCP_PTRNum", 0);
}
else
{
idb.AddParameter("@PCP_PTRNum", pC_Plan.PCP_PTRNum);
}
}
if(pC_Plan.PCP_PPRNum_IsChanged)
{
if (pC_Plan.PCP_PPRNum == 0)
{
idb.AddParameter("@PCP_PPRNum", 0);
}
else
{
idb.AddParameter("@PCP_PPRNum", pC_Plan.PCP_PPRNum);
}
}
if(pC_Plan.PCP_PPMNum_IsChanged)
{
if (pC_Plan.PCP_PPMNum == 0)
{
idb.AddParameter("@PCP_PPMNum", 0);
}
else
{
idb.AddParameter("@PCP_PPMNum", pC_Plan.PCP_PPMNum);
}
}
if(pC_Plan.PCP_PTMNum_IsChanged)
{
if (pC_Plan.PCP_PTMNum == 0)
{
idb.AddParameter("@PCP_PTMNum", 0);
}
else
{
idb.AddParameter("@PCP_PTMNum", pC_Plan.PCP_PTMNum);
}
}
if(pC_Plan.PCP_TechType_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_TechType))
{
idb.AddParameter("@PCP_TechType", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_TechType", pC_Plan.PCP_TechType);
}
}
if(pC_Plan.PCP_Limit_IsChanged)
{
if (pC_Plan.PCP_Limit == 0)
{
idb.AddParameter("@PCP_Limit", 0);
}
else
{
idb.AddParameter("@PCP_Limit", pC_Plan.PCP_Limit);
}
}
if(pC_Plan.PCP_Frequence_IsChanged)
{
if (pC_Plan.PCP_Frequence == 0)
{
idb.AddParameter("@PCP_Frequence", 0);
}
else
{
idb.AddParameter("@PCP_Frequence", pC_Plan.PCP_Frequence);
}
}
if(pC_Plan.PCP_LastDate_IsChanged)
{
if (pC_Plan.PCP_LastDate == DateTime.MinValue)
{
idb.AddParameter("@PCP_LastDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_LastDate", pC_Plan.PCP_LastDate);
}
}
if(pC_Plan.PCP_LastNo_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_LastNo))
{
idb.AddParameter("@PCP_LastNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_LastNo", pC_Plan.PCP_LastNo);
}
}
if(pC_Plan.PCP_Transpot_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Transpot))
{
idb.AddParameter("@PCP_Transpot", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Transpot", pC_Plan.PCP_Transpot);
}
}
if(pC_Plan.PCP_Order_IsChanged)
{
if (pC_Plan.PCP_Order == 0)
{
idb.AddParameter("@PCP_Order", 0);
}
else
{
idb.AddParameter("@PCP_Order", pC_Plan.PCP_Order);
}
}
if(pC_Plan.PCP_DBack_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_DBack))
{
idb.AddParameter("@PCP_DBack", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_DBack", pC_Plan.PCP_DBack);
}
}
if(pC_Plan.PCP_Status_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Status))
{
idb.AddParameter("@PCP_Status", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Status", pC_Plan.PCP_Status);
}
}
if(pC_Plan.PCP_Bak_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Bak))
{
idb.AddParameter("@PCP_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Bak", pC_Plan.PCP_Bak);
}
}
if(pC_Plan.Stat_IsChanged)
{
if (pC_Plan.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pC_Plan.Stat);
}
}
if(pC_Plan.CreateDate_IsChanged)
{
if (pC_Plan.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pC_Plan.CreateDate);
}
}
if(pC_Plan.UpdateDate_IsChanged)
{
if (pC_Plan.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pC_Plan.UpdateDate);
}
}
if(pC_Plan.DeleteDate_IsChanged)
{
if (pC_Plan.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pC_Plan.DeleteDate);
}
}
if(pC_Plan.PCP_Udef1_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef1))
{
idb.AddParameter("@PCP_Udef1", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef1", pC_Plan.PCP_Udef1);
}
}
if(pC_Plan.PCP_Udef2_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef2))
{
idb.AddParameter("@PCP_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef2", pC_Plan.PCP_Udef2);
}
}
if(pC_Plan.PCP_Udef3_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef3))
{
idb.AddParameter("@PCP_Udef3", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef3", pC_Plan.PCP_Udef3);
}
}
if(pC_Plan.PCP_Udef4_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef4))
{
idb.AddParameter("@PCP_Udef4", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef4", pC_Plan.PCP_Udef4);
}
}
if(pC_Plan.PCP_Udef5_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef5))
{
idb.AddParameter("@PCP_Udef5", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef5", pC_Plan.PCP_Udef5);
}
}
if(pC_Plan.PCP_Udef6_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef6))
{
idb.AddParameter("@PCP_Udef6", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef6", pC_Plan.PCP_Udef6);
}
}
if(pC_Plan.PCP_Udef7_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Udef7))
{
idb.AddParameter("@PCP_Udef7", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Udef7", pC_Plan.PCP_Udef7);
}
}
if(pC_Plan.AuditCurAudit_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", pC_Plan.AuditCurAudit);
}
}
if(pC_Plan.AuditStat_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", pC_Plan.AuditStat);
}
}
if(pC_Plan.PCP_LNum_IsChanged)
{
if (pC_Plan.PCP_LNum == 0)
{
idb.AddParameter("@PCP_LNum", 0);
}
else
{
idb.AddParameter("@PCP_LNum", pC_Plan.PCP_LNum);
}
}
if(pC_Plan.PCP_ANum_IsChanged)
{
if (pC_Plan.PCP_ANum == 0)
{
idb.AddParameter("@PCP_ANum", 0);
}
else
{
idb.AddParameter("@PCP_ANum", pC_Plan.PCP_ANum);
}
}
if(pC_Plan.PCP_Price_IsChanged)
{
if (pC_Plan.PCP_Price == 0)
{
idb.AddParameter("@PCP_Price", 0);
}
else
{
idb.AddParameter("@PCP_Price", pC_Plan.PCP_Price);
}
}
if(pC_Plan.PCP_Sum_IsChanged)
{
if (pC_Plan.PCP_Sum == 0)
{
idb.AddParameter("@PCP_Sum", 0);
}
else
{
idb.AddParameter("@PCP_Sum", pC_Plan.PCP_Sum);
}
}
if(pC_Plan.PCP_TankerFee_IsChanged)
{
if (pC_Plan.PCP_TankerFee == 0)
{
idb.AddParameter("@PCP_TankerFee", 0);
}
else
{
idb.AddParameter("@PCP_TankerFee", pC_Plan.PCP_TankerFee);
}
}
if(pC_Plan.PCP_PumpFee_IsChanged)
{
if (pC_Plan.PCP_PumpFee == 0)
{
idb.AddParameter("@PCP_PumpFee", 0);
}
else
{
idb.AddParameter("@PCP_PumpFee", pC_Plan.PCP_PumpFee);
}
}
if(pC_Plan.PCP_Operator_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Operator))
{
idb.AddParameter("@PCP_Operator", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Operator", pC_Plan.PCP_Operator);
}
}
if(pC_Plan.PCP_Schdule_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Schdule))
{
idb.AddParameter("@PCP_Schdule", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Schdule", pC_Plan.PCP_Schdule);
}
}
if(pC_Plan.PCP_Station_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_Station))
{
idb.AddParameter("@PCP_Station", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_Station", pC_Plan.PCP_Station);
}
}
if(pC_Plan.PCP_StatonName_IsChanged)
{
if (string.IsNullOrEmpty(pC_Plan.PCP_StatonName))
{
idb.AddParameter("@PCP_StatonName", DBNull.Value);
}
else
{
idb.AddParameter("@PCP_StatonName", pC_Plan.PCP_StatonName);
}
}
idb.AddParameter("@PCP_ID", pC_Plan.PCP_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_Plan对象集合
/// </summary>
public List<PC_Plan> GetListByWhere(string strCondition)
{
List<PC_Plan> ret = new List<PC_Plan>();
string sql = "SELECT PCP_ID,PCP_PCode,PCP_SCode,PCP_Name,PCP_CPCode,PCP_PRCode,PCP_CCode,PCP_Part,PCP_Slump,PCP_Addr,PCP_IsPipe,PCP_PLCode,PCP_Leve,PCP_Impervious,PCP_SPC,PCP_Special1,PCP_Special2,PCP_Special3,PCP_Special4,PCP_Special5,PCP_PDate,PCP_RDate,PCP_POwner,PCP_POwnerName,PCP_Date,PCP_CureStep,PCP_NextStep,PCP_IsTech,PCP_IsStart,PCP_PMNum,PCP_PUNum,PCP_PINum,PCP_PJNum,PCP_PTNum,PCP_PWNum,PCP_PPNum,PCP_PRNum,PCP_PTRNum,PCP_PPRNum,PCP_PPMNum,PCP_PTMNum,PCP_TechType,PCP_Limit,PCP_Frequence,PCP_LastDate,PCP_LastNo,PCP_Transpot,PCP_Order,PCP_DBack,PCP_Status,PCP_Bak,Stat,CreateDate,UpdateDate,DeleteDate,PCP_Udef1,PCP_Udef2,PCP_Udef3,PCP_Udef4,PCP_Udef5,PCP_Udef6,PCP_Udef7,AuditCurAudit,AuditStat,PCP_LNum,PCP_ANum,PCP_Price,PCP_Sum,PCP_TankerFee,PCP_PumpFee,PCP_Operator,PCP_Schdule,PCP_Station,PCP_StatonName FROM PC_Plan 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())
{
PC_Plan pC_Plan = new PC_Plan();
if (dr["PCP_ID"] != DBNull.Value) pC_Plan.PCP_ID = Convert.ToDecimal(dr["PCP_ID"]);
if (dr["PCP_PCode"] != DBNull.Value) pC_Plan.PCP_PCode = Convert.ToString(dr["PCP_PCode"]);
if (dr["PCP_SCode"] != DBNull.Value) pC_Plan.PCP_SCode = Convert.ToString(dr["PCP_SCode"]);
if (dr["PCP_Name"] != DBNull.Value) pC_Plan.PCP_Name = Convert.ToString(dr["PCP_Name"]);
if (dr["PCP_CPCode"] != DBNull.Value) pC_Plan.PCP_CPCode = Convert.ToString(dr["PCP_CPCode"]);
if (dr["PCP_PRCode"] != DBNull.Value) pC_Plan.PCP_PRCode = Convert.ToString(dr["PCP_PRCode"]);
if (dr["PCP_CCode"] != DBNull.Value) pC_Plan.PCP_CCode = Convert.ToString(dr["PCP_CCode"]);
if (dr["PCP_Part"] != DBNull.Value) pC_Plan.PCP_Part = Convert.ToString(dr["PCP_Part"]);
if (dr["PCP_Slump"] != DBNull.Value) pC_Plan.PCP_Slump = Convert.ToString(dr["PCP_Slump"]);
if (dr["PCP_Addr"] != DBNull.Value) pC_Plan.PCP_Addr = Convert.ToString(dr["PCP_Addr"]);
if (dr["PCP_IsPipe"] != DBNull.Value) pC_Plan.PCP_IsPipe = Convert.ToString(dr["PCP_IsPipe"]);
if (dr["PCP_PLCode"] != DBNull.Value) pC_Plan.PCP_PLCode = Convert.ToString(dr["PCP_PLCode"]);
if (dr["PCP_Leve"] != DBNull.Value) pC_Plan.PCP_Leve = Convert.ToString(dr["PCP_Leve"]);
if (dr["PCP_Impervious"] != DBNull.Value) pC_Plan.PCP_Impervious = Convert.ToString(dr["PCP_Impervious"]);
if (dr["PCP_SPC"] != DBNull.Value) pC_Plan.PCP_SPC = Convert.ToString(dr["PCP_SPC"]);
if (dr["PCP_Special1"] != DBNull.Value) pC_Plan.PCP_Special1 = Convert.ToString(dr["PCP_Special1"]);
if (dr["PCP_Special2"] != DBNull.Value) pC_Plan.PCP_Special2 = Convert.ToString(dr["PCP_Special2"]);
if (dr["PCP_Special3"] != DBNull.Value) pC_Plan.PCP_Special3 = Convert.ToString(dr["PCP_Special3"]);
if (dr["PCP_Special4"] != DBNull.Value) pC_Plan.PCP_Special4 = Convert.ToString(dr["PCP_Special4"]);
if (dr["PCP_Special5"] != DBNull.Value) pC_Plan.PCP_Special5 = Convert.ToString(dr["PCP_Special5"]);
if (dr["PCP_PDate"] != DBNull.Value) pC_Plan.PCP_PDate = Convert.ToDateTime(dr["PCP_PDate"]);
if (dr["PCP_RDate"] != DBNull.Value) pC_Plan.PCP_RDate = Convert.ToDateTime(dr["PCP_RDate"]);
if (dr["PCP_POwner"] != DBNull.Value) pC_Plan.PCP_POwner = Convert.ToString(dr["PCP_POwner"]);
if (dr["PCP_POwnerName"] != DBNull.Value) pC_Plan.PCP_POwnerName = Convert.ToString(dr["PCP_POwnerName"]);
if (dr["PCP_Date"] != DBNull.Value) pC_Plan.PCP_Date = Convert.ToDateTime(dr["PCP_Date"]);
if (dr["PCP_CureStep"] != DBNull.Value) pC_Plan.PCP_CureStep = Convert.ToString(dr["PCP_CureStep"]);
if (dr["PCP_NextStep"] != DBNull.Value) pC_Plan.PCP_NextStep = Convert.ToString(dr["PCP_NextStep"]);
if (dr["PCP_IsTech"] != DBNull.Value) pC_Plan.PCP_IsTech = Convert.ToInt32(dr["PCP_IsTech"]);
if (dr["PCP_IsStart"] != DBNull.Value) pC_Plan.PCP_IsStart = Convert.ToInt32(dr["PCP_IsStart"]);
if (dr["PCP_PMNum"] != DBNull.Value) pC_Plan.PCP_PMNum = Convert.ToString(dr["PCP_PMNum"]);
if (dr["PCP_PUNum"] != DBNull.Value) pC_Plan.PCP_PUNum = Convert.ToString(dr["PCP_PUNum"]);
if (dr["PCP_PINum"] != DBNull.Value) pC_Plan.PCP_PINum = Convert.ToString(dr["PCP_PINum"]);
if (dr["PCP_PJNum"] != DBNull.Value) pC_Plan.PCP_PJNum = Convert.ToString(dr["PCP_PJNum"]);
if (dr["PCP_PTNum"] != DBNull.Value) pC_Plan.PCP_PTNum = Convert.ToInt32(dr["PCP_PTNum"]);
if (dr["PCP_PWNum"] != DBNull.Value) pC_Plan.PCP_PWNum = Convert.ToString(dr["PCP_PWNum"]);
if (dr["PCP_PPNum"] != DBNull.Value) pC_Plan.PCP_PPNum = Convert.ToDecimal(dr["PCP_PPNum"]);
if (dr["PCP_PRNum"] != DBNull.Value) pC_Plan.PCP_PRNum = Convert.ToDecimal(dr["PCP_PRNum"]);
if (dr["PCP_PTRNum"] != DBNull.Value) pC_Plan.PCP_PTRNum = Convert.ToInt32(dr["PCP_PTRNum"]);
if (dr["PCP_PPRNum"] != DBNull.Value) pC_Plan.PCP_PPRNum = Convert.ToDecimal(dr["PCP_PPRNum"]);
if (dr["PCP_PPMNum"] != DBNull.Value) pC_Plan.PCP_PPMNum = Convert.ToDecimal(dr["PCP_PPMNum"]);
if (dr["PCP_PTMNum"] != DBNull.Value) pC_Plan.PCP_PTMNum = Convert.ToDecimal(dr["PCP_PTMNum"]);
if (dr["PCP_TechType"] != DBNull.Value) pC_Plan.PCP_TechType = Convert.ToString(dr["PCP_TechType"]);
if (dr["PCP_Limit"] != DBNull.Value) pC_Plan.PCP_Limit = Convert.ToDecimal(dr["PCP_Limit"]);
if (dr["PCP_Frequence"] != DBNull.Value) pC_Plan.PCP_Frequence = Convert.ToInt32(dr["PCP_Frequence"]);
if (dr["PCP_LastDate"] != DBNull.Value) pC_Plan.PCP_LastDate = Convert.ToDateTime(dr["PCP_LastDate"]);
if (dr["PCP_LastNo"] != DBNull.Value) pC_Plan.PCP_LastNo = Convert.ToString(dr["PCP_LastNo"]);
if (dr["PCP_Transpot"] != DBNull.Value) pC_Plan.PCP_Transpot = Convert.ToString(dr["PCP_Transpot"]);
if (dr["PCP_Order"] != DBNull.Value) pC_Plan.PCP_Order = Convert.ToInt32(dr["PCP_Order"]);
if (dr["PCP_DBack"] != DBNull.Value) pC_Plan.PCP_DBack = Convert.ToString(dr["PCP_DBack"]);
if (dr["PCP_Status"] != DBNull.Value) pC_Plan.PCP_Status = Convert.ToString(dr["PCP_Status"]);
if (dr["PCP_Bak"] != DBNull.Value) pC_Plan.PCP_Bak = Convert.ToString(dr["PCP_Bak"]);
if (dr["Stat"] != DBNull.Value) pC_Plan.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["CreateDate"] != DBNull.Value) pC_Plan.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["UpdateDate"] != DBNull.Value) pC_Plan.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
if (dr["DeleteDate"] != DBNull.Value) pC_Plan.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
if (dr["PCP_Udef1"] != DBNull.Value) pC_Plan.PCP_Udef1 = Convert.ToString(dr["PCP_Udef1"]);
if (dr["PCP_Udef2"] != DBNull.Value) pC_Plan.PCP_Udef2 = Convert.ToString(dr["PCP_Udef2"]);
if (dr["PCP_Udef3"] != DBNull.Value) pC_Plan.PCP_Udef3 = Convert.ToString(dr["PCP_Udef3"]);
if (dr["PCP_Udef4"] != DBNull.Value) pC_Plan.PCP_Udef4 = Convert.ToString(dr["PCP_Udef4"]);
if (dr["PCP_Udef5"] != DBNull.Value) pC_Plan.PCP_Udef5 = Convert.ToString(dr["PCP_Udef5"]);
if (dr["PCP_Udef6"] != DBNull.Value) pC_Plan.PCP_Udef6 = Convert.ToString(dr["PCP_Udef6"]);
if (dr["PCP_Udef7"] != DBNull.Value) pC_Plan.PCP_Udef7 = Convert.ToString(dr["PCP_Udef7"]);
if (dr["AuditCurAudit"] != DBNull.Value) pC_Plan.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
if (dr["AuditStat"] != DBNull.Value) pC_Plan.AuditStat = Convert.ToString(dr["AuditStat"]);
if (dr["PCP_LNum"] != DBNull.Value) pC_Plan.PCP_LNum = Convert.ToDecimal(dr["PCP_LNum"]);
if (dr["PCP_ANum"] != DBNull.Value) pC_Plan.PCP_ANum = Convert.ToDecimal(dr["PCP_ANum"]);
if (dr["PCP_Price"] != DBNull.Value) pC_Plan.PCP_Price = Convert.ToDecimal(dr["PCP_Price"]);
if (dr["PCP_Sum"] != DBNull.Value) pC_Plan.PCP_Sum = Convert.ToDecimal(dr["PCP_Sum"]);
if (dr["PCP_TankerFee"] != DBNull.Value) pC_Plan.PCP_TankerFee = Convert.ToDecimal(dr["PCP_TankerFee"]);
if (dr["PCP_PumpFee"] != DBNull.Value) pC_Plan.PCP_PumpFee = Convert.ToDecimal(dr["PCP_PumpFee"]);
if (dr["PCP_Operator"] != DBNull.Value) pC_Plan.PCP_Operator = Convert.ToString(dr["PCP_Operator"]);
if (dr["PCP_Schdule"] != DBNull.Value) pC_Plan.PCP_Schdule = Convert.ToString(dr["PCP_Schdule"]);
if (dr["PCP_Station"] != DBNull.Value) pC_Plan.PCP_Station = Convert.ToString(dr["PCP_Station"]);
if (dr["PCP_StatonName"] != DBNull.Value) pC_Plan.PCP_StatonName = Convert.ToString(dr["PCP_StatonName"]);
ret.Add(pC_Plan);
}
}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(PC_Plan 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(PC_Plan 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(PC_Plan model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
