/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public PCD_NRecord GetModel(string strCondition)
{
List<PCD_NRecord> list = instance.GetListByWhere(strCondition);
PCD_NRecord model = new PCD_NRecord();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(PCD_NRecord 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 Update(PCD_NRecord 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>
/// <returns>bool</returns>
public bool Insert(PCD_NRecord model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
/// <summary>
/// 获取所有的发货记录 PCD_NRecord对象(即:一条记录
/// </summary>
public List<PCD_NRecord> GetAll()
{
List<PCD_NRecord> ret = new List<PCD_NRecord>();
string sql = "SELECT PCDN_ID,PCDN_Code,PCDN_CCode,PCDN_PRCode,PCDN_PCode,PCDN_PDCode,PCDN_PSCode,PCDN_Part,PCDN_Slump,PCDN_Spec1,PCDN_Spec2,PCDN_TType,PCDN_TEqu,PCDN_SOwner,PCDN_SDate,PCDN_TBSta,PCDN_TBLine,PCDN_OOwner,PCDN_ODate,PCDN_ForeMan,PCDN_PPLimit,PCDN_DIType,PCDN_DINum,PCDN_PNum,PCDN_PCNum,PCDN_PTOrd,PCDN_PCDrv,PCDN_Comp,PCDN_PCCode,PCDN_PCNo,PCDN_DDate,PCDN_RDate,PCDN_JBegin,PCDN_JEnd,PCDN_LDate,PCDN_BDate,PCDN_PPNum,PCDN_TDNum,PCDN_TTNum,PCDN_RTNum,PCDN_CTNum,PCDN_RRNum,PCDN_MoreNum,PCDN_PRNum,PCDN_BStatus,PCDN_TRNum,PCDN_TBNum,PCDN_TBBak,PCDN_Stat,PCDN_iType,Stat,CreateDate,UpdateDate,DeleteDate,PCDN_SourceCode FROM PCD_NRecord where 1=1 AND ((Stat is null) or (Stat=0) ) order by PCDN_ID desc ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
PCD_NRecord pCD_NRecord = new PCD_NRecord();
if (dr["PCDN_ID"] != DBNull.Value) pCD_NRecord.PCDN_ID = Convert.ToDecimal(dr["PCDN_ID"]);
if (dr["PCDN_Code"] != DBNull.Value) pCD_NRecord.PCDN_Code = Convert.ToString(dr["PCDN_Code"]);
if (dr["PCDN_CCode"] != DBNull.Value) pCD_NRecord.PCDN_CCode = Convert.ToString(dr["PCDN_CCode"]);
if (dr["PCDN_PRCode"] != DBNull.Value) pCD_NRecord.PCDN_PRCode = Convert.ToString(dr["PCDN_PRCode"]);
if (dr["PCDN_PCode"] != DBNull.Value) pCD_NRecord.PCDN_PCode = Convert.ToString(dr["PCDN_PCode"]);
if (dr["PCDN_PDCode"] != DBNull.Value) pCD_NRecord.PCDN_PDCode = Convert.ToString(dr["PCDN_PDCode"]);
if (dr["PCDN_PSCode"] != DBNull.Value) pCD_NRecord.PCDN_PSCode = Convert.ToString(dr["PCDN_PSCode"]);
if (dr["PCDN_Part"] != DBNull.Value) pCD_NRecord.PCDN_Part = Convert.ToString(dr["PCDN_Part"]);
if (dr["PCDN_Slump"] != DBNull.Value) pCD_NRecord.PCDN_Slump = Convert.ToString(dr["PCDN_Slump"]);
if (dr["PCDN_Spec1"] != DBNull.Value) pCD_NRecord.PCDN_Spec1 = Convert.ToString(dr["PCDN_Spec1"]);
if (dr["PCDN_Spec2"] != DBNull.Value) pCD_NRecord.PCDN_Spec2 = Convert.ToString(dr["PCDN_Spec2"]);
if (dr["PCDN_TType"] != DBNull.Value) pCD_NRecord.PCDN_TType = Convert.ToString(dr["PCDN_TType"]);
if (dr["PCDN_TEqu"] != DBNull.Value) pCD_NRecord.PCDN_TEqu = Convert.ToString(dr["PCDN_TEqu"]);
if (dr["PCDN_SOwner"] != DBNull.Value) pCD_NRecord.PCDN_SOwner = Convert.ToString(dr["PCDN_SOwner"]);
if (dr["PCDN_SDate"] != DBNull.Value) pCD_NRecord.PCDN_SDate = Convert.ToDateTime(dr["PCDN_SDate"]);
if (dr["PCDN_TBSta"] != DBNull.Value) pCD_NRecord.PCDN_TBSta = Convert.ToString(dr["PCDN_TBSta"]);
if (dr["PCDN_TBLine"] != DBNull.Value) pCD_NRecord.PCDN_TBLine = Convert.ToString(dr["PCDN_TBLine"]);
if (dr["PCDN_OOwner"] != DBNull.Value) pCD_NRecord.PCDN_OOwner = Convert.ToString(dr["PCDN_OOwner"]);
if (dr["PCDN_ODate"] != DBNull.Value) pCD_NRecord.PCDN_ODate = Convert.ToDateTime(dr["PCDN_ODate"]);
if (dr["PCDN_ForeMan"] != DBNull.Value) pCD_NRecord.PCDN_ForeMan = Convert.ToString(dr["PCDN_ForeMan"]);
if (dr["PCDN_PPLimit"] != DBNull.Value) pCD_NRecord.PCDN_PPLimit = Convert.ToDecimal(dr["PCDN_PPLimit"]);
if (dr["PCDN_DIType"] != DBNull.Value) pCD_NRecord.PCDN_DIType = Convert.ToString(dr["PCDN_DIType"]);
if (dr["PCDN_DINum"] != DBNull.Value) pCD_NRecord.PCDN_DINum = Convert.ToDecimal(dr["PCDN_DINum"]);
if (dr["PCDN_PNum"] != DBNull.Value) pCD_NRecord.PCDN_PNum = Convert.ToDecimal(dr["PCDN_PNum"]);
if (dr["PCDN_PCNum"] != DBNull.Value) pCD_NRecord.PCDN_PCNum = Convert.ToDecimal(dr["PCDN_PCNum"]);
if (dr["PCDN_PTOrd"] != DBNull.Value) pCD_NRecord.PCDN_PTOrd = Convert.ToInt32(dr["PCDN_PTOrd"]);
if (dr["PCDN_PCDrv"] != DBNull.Value) pCD_NRecord.PCDN_PCDrv = Convert.ToString(dr["PCDN_PCDrv"]);
if (dr["PCDN_Comp"] != DBNull.Value) pCD_NRecord.PCDN_Comp = Convert.ToString(dr["PCDN_Comp"]);
if (dr["PCDN_PCCode"] != DBNull.Value) pCD_NRecord.PCDN_PCCode = Convert.ToString(dr["PCDN_PCCode"]);
if (dr["PCDN_PCNo"] != DBNull.Value) pCD_NRecord.PCDN_PCNo = Convert.ToString(dr["PCDN_PCNo"]);
if (dr["PCDN_DDate"] != DBNull.Value) pCD_NRecord.PCDN_DDate = Convert.ToDateTime(dr["PCDN_DDate"]);
if (dr["PCDN_RDate"] != DBNull.Value) pCD_NRecord.PCDN_RDate = Convert.ToDateTime(dr["PCDN_RDate"]);
if (dr["PCDN_JBegin"] != DBNull.Value) pCD_NRecord.PCDN_JBegin = Convert.ToDateTime(dr["PCDN_JBegin"]);
if (dr["PCDN_JEnd"] != DBNull.Value) pCD_NRecord.PCDN_JEnd = Convert.ToDateTime(dr["PCDN_JEnd"]);
if (dr["PCDN_LDate"] != DBNull.Value) pCD_NRecord.PCDN_LDate = Convert.ToDateTime(dr["PCDN_LDate"]);
if (dr["PCDN_BDate"] != DBNull.Value) pCD_NRecord.PCDN_BDate = Convert.ToDateTime(dr["PCDN_BDate"]);
if (dr["PCDN_PPNum"] != DBNull.Value) pCD_NRecord.PCDN_PPNum = Convert.ToDecimal(dr["PCDN_PPNum"]);
if (dr["PCDN_TDNum"] != DBNull.Value) pCD_NRecord.PCDN_TDNum = Convert.ToDecimal(dr["PCDN_TDNum"]);
if (dr["PCDN_TTNum"] != DBNull.Value) pCD_NRecord.PCDN_TTNum = Convert.ToInt32(dr["PCDN_TTNum"]);
if (dr["PCDN_RTNum"] != DBNull.Value) pCD_NRecord.PCDN_RTNum = Convert.ToDecimal(dr["PCDN_RTNum"]);
if (dr["PCDN_CTNum"] != DBNull.Value) pCD_NRecord.PCDN_CTNum = Convert.ToDecimal(dr["PCDN_CTNum"]);
if (dr["PCDN_RRNum"] != DBNull.Value) pCD_NRecord.PCDN_RRNum = Convert.ToDecimal(dr["PCDN_RRNum"]);
if (dr["PCDN_MoreNum"] != DBNull.Value) pCD_NRecord.PCDN_MoreNum = Convert.ToDecimal(dr["PCDN_MoreNum"]);
if (dr["PCDN_PRNum"] != DBNull.Value) pCD_NRecord.PCDN_PRNum = Convert.ToDecimal(dr["PCDN_PRNum"]);
if (dr["PCDN_BStatus"] != DBNull.Value) pCD_NRecord.PCDN_BStatus = Convert.ToString(dr["PCDN_BStatus"]);
if (dr["PCDN_TRNum"] != DBNull.Value) pCD_NRecord.PCDN_TRNum = Convert.ToDecimal(dr["PCDN_TRNum"]);
if (dr["PCDN_TBNum"] != DBNull.Value) pCD_NRecord.PCDN_TBNum = Convert.ToDecimal(dr["PCDN_TBNum"]);
if (dr["PCDN_TBBak"] != DBNull.Value) pCD_NRecord.PCDN_TBBak = Convert.ToString(dr["PCDN_TBBak"]);
if (dr["PCDN_Stat"] != DBNull.Value) pCD_NRecord.PCDN_Stat = Convert.ToString(dr["PCDN_Stat"]);
if (dr["PCDN_iType"] != DBNull.Value) pCD_NRecord.PCDN_iType = Convert.ToString(dr["PCDN_iType"]);
if (dr["Stat"] != DBNull.Value) pCD_NRecord.Stat = Convert.ToInt32(dr["Stat"]);
if (dr["CreateDate"] != DBNull.Value) pCD_NRecord.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["UpdateDate"] != DBNull.Value) pCD_NRecord.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
if (dr["DeleteDate"] != DBNull.Value) pCD_NRecord.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
if (dr["PCDN_SourceCode"] != DBNull.Value) pCD_NRecord.PCDN_SourceCode = Convert.ToString(dr["PCDN_SourceCode"]);
ret.Add(pCD_NRecord);
}
}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>
/// 添加发货记录 PCD_NRecord对象(即:一条记录)
/// </summary>
public object AddWithReturn(PCD_NRecord pCD_NRecord)
{
string sql = "INSERT INTO PCD_NRecord (PCDN_Code,PCDN_CCode,PCDN_PRCode,PCDN_PCode,PCDN_PDCode,PCDN_PSCode,PCDN_Part,PCDN_Slump,PCDN_Spec1,PCDN_Spec2,PCDN_TType,PCDN_TEqu,PCDN_SOwner,PCDN_SDate,PCDN_TBSta,PCDN_TBLine,PCDN_OOwner,PCDN_ODate,PCDN_ForeMan,PCDN_PPLimit,PCDN_DIType,PCDN_DINum,PCDN_PNum,PCDN_PCNum,PCDN_PTOrd,PCDN_PCDrv,PCDN_Comp,PCDN_PCCode,PCDN_PCNo,PCDN_DDate,PCDN_RDate,PCDN_JBegin,PCDN_JEnd,PCDN_LDate,PCDN_BDate,PCDN_PPNum,PCDN_TDNum,PCDN_TTNum,PCDN_RTNum,PCDN_CTNum,PCDN_RRNum,PCDN_MoreNum,PCDN_PRNum,PCDN_BStatus,PCDN_TRNum,PCDN_TBNum,PCDN_TBBak,PCDN_Stat,PCDN_iType,Stat,CreateDate,UpdateDate,DeleteDate,PCDN_SourceCode) VALUES (@PCDN_Code,@PCDN_CCode,@PCDN_PRCode,@PCDN_PCode,@PCDN_PDCode,@PCDN_PSCode,@PCDN_Part,@PCDN_Slump,@PCDN_Spec1,@PCDN_Spec2,@PCDN_TType,@PCDN_TEqu,@PCDN_SOwner,@PCDN_SDate,@PCDN_TBSta,@PCDN_TBLine,@PCDN_OOwner,@PCDN_ODate,@PCDN_ForeMan,@PCDN_PPLimit,@PCDN_DIType,@PCDN_DINum,@PCDN_PNum,@PCDN_PCNum,@PCDN_PTOrd,@PCDN_PCDrv,@PCDN_Comp,@PCDN_PCCode,@PCDN_PCNo,@PCDN_DDate,@PCDN_RDate,@PCDN_JBegin,@PCDN_JEnd,@PCDN_LDate,@PCDN_BDate,@PCDN_PPNum,@PCDN_TDNum,@PCDN_TTNum,@PCDN_RTNum,@PCDN_CTNum,@PCDN_RRNum,@PCDN_MoreNum,@PCDN_PRNum,@PCDN_BStatus,@PCDN_TRNum,@PCDN_TBNum,@PCDN_TBBak,@PCDN_Stat,@PCDN_iType,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@PCDN_SourceCode);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Code))
{
idb.AddParameter("@PCDN_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Code", pCD_NRecord.PCDN_Code);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_CCode))
{
idb.AddParameter("@PCDN_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_CCode", pCD_NRecord.PCDN_CCode);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PRCode))
{
idb.AddParameter("@PCDN_PRCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PRCode", pCD_NRecord.PCDN_PRCode);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCode))
{
idb.AddParameter("@PCDN_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCode", pCD_NRecord.PCDN_PCode);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PDCode))
{
idb.AddParameter("@PCDN_PDCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PDCode", pCD_NRecord.PCDN_PDCode);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PSCode))
{
idb.AddParameter("@PCDN_PSCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PSCode", pCD_NRecord.PCDN_PSCode);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Part))
{
idb.AddParameter("@PCDN_Part", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Part", pCD_NRecord.PCDN_Part);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Slump))
{
idb.AddParameter("@PCDN_Slump", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Slump", pCD_NRecord.PCDN_Slump);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Spec1))
{
idb.AddParameter("@PCDN_Spec1", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Spec1", pCD_NRecord.PCDN_Spec1);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Spec2))
{
idb.AddParameter("@PCDN_Spec2", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Spec2", pCD_NRecord.PCDN_Spec2);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TType))
{
idb.AddParameter("@PCDN_TType", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TType", pCD_NRecord.PCDN_TType);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TEqu))
{
idb.AddParameter("@PCDN_TEqu", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TEqu", pCD_NRecord.PCDN_TEqu);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_SOwner))
{
idb.AddParameter("@PCDN_SOwner", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_SOwner", pCD_NRecord.PCDN_SOwner);
}
if (pCD_NRecord.PCDN_SDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_SDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_SDate", pCD_NRecord.PCDN_SDate);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TBSta))
{
idb.AddParameter("@PCDN_TBSta", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TBSta", pCD_NRecord.PCDN_TBSta);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TBLine))
{
idb.AddParameter("@PCDN_TBLine", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TBLine", pCD_NRecord.PCDN_TBLine);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_OOwner))
{
idb.AddParameter("@PCDN_OOwner", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_OOwner", pCD_NRecord.PCDN_OOwner);
}
if (pCD_NRecord.PCDN_ODate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_ODate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_ODate", pCD_NRecord.PCDN_ODate);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_ForeMan))
{
idb.AddParameter("@PCDN_ForeMan", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_ForeMan", pCD_NRecord.PCDN_ForeMan);
}
if (pCD_NRecord.PCDN_PPLimit == 0)
{
idb.AddParameter("@PCDN_PPLimit", 0);
}
else
{
idb.AddParameter("@PCDN_PPLimit", pCD_NRecord.PCDN_PPLimit);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_DIType))
{
idb.AddParameter("@PCDN_DIType", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_DIType", pCD_NRecord.PCDN_DIType);
}
if (pCD_NRecord.PCDN_DINum == 0)
{
idb.AddParameter("@PCDN_DINum", 0);
}
else
{
idb.AddParameter("@PCDN_DINum", pCD_NRecord.PCDN_DINum);
}
if (pCD_NRecord.PCDN_PNum == 0)
{
idb.AddParameter("@PCDN_PNum", 0);
}
else
{
idb.AddParameter("@PCDN_PNum", pCD_NRecord.PCDN_PNum);
}
if (pCD_NRecord.PCDN_PCNum == 0)
{
idb.AddParameter("@PCDN_PCNum", 0);
}
else
{
idb.AddParameter("@PCDN_PCNum", pCD_NRecord.PCDN_PCNum);
}
if (pCD_NRecord.PCDN_PTOrd == 0)
{
idb.AddParameter("@PCDN_PTOrd", 0);
}
else
{
idb.AddParameter("@PCDN_PTOrd", pCD_NRecord.PCDN_PTOrd);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCDrv))
{
idb.AddParameter("@PCDN_PCDrv", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCDrv", pCD_NRecord.PCDN_PCDrv);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Comp))
{
idb.AddParameter("@PCDN_Comp", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Comp", pCD_NRecord.PCDN_Comp);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCCode))
{
idb.AddParameter("@PCDN_PCCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCCode", pCD_NRecord.PCDN_PCCode);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCNo))
{
idb.AddParameter("@PCDN_PCNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCNo", pCD_NRecord.PCDN_PCNo);
}
if (pCD_NRecord.PCDN_DDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_DDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_DDate", pCD_NRecord.PCDN_DDate);
}
if (pCD_NRecord.PCDN_RDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_RDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_RDate", pCD_NRecord.PCDN_RDate);
}
if (pCD_NRecord.PCDN_JBegin == DateTime.MinValue)
{
idb.AddParameter("@PCDN_JBegin", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_JBegin", pCD_NRecord.PCDN_JBegin);
}
if (pCD_NRecord.PCDN_JEnd == DateTime.MinValue)
{
idb.AddParameter("@PCDN_JEnd", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_JEnd", pCD_NRecord.PCDN_JEnd);
}
if (pCD_NRecord.PCDN_LDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_LDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_LDate", pCD_NRecord.PCDN_LDate);
}
if (pCD_NRecord.PCDN_BDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_BDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_BDate", pCD_NRecord.PCDN_BDate);
}
if (pCD_NRecord.PCDN_PPNum == 0)
{
idb.AddParameter("@PCDN_PPNum", 0);
}
else
{
idb.AddParameter("@PCDN_PPNum", pCD_NRecord.PCDN_PPNum);
}
if (pCD_NRecord.PCDN_TDNum == 0)
{
idb.AddParameter("@PCDN_TDNum", 0);
}
else
{
idb.AddParameter("@PCDN_TDNum", pCD_NRecord.PCDN_TDNum);
}
if (pCD_NRecord.PCDN_TTNum == 0)
{
idb.AddParameter("@PCDN_TTNum", 0);
}
else
{
idb.AddParameter("@PCDN_TTNum", pCD_NRecord.PCDN_TTNum);
}
if (pCD_NRecord.PCDN_RTNum == 0)
{
idb.AddParameter("@PCDN_RTNum", 0);
}
else
{
idb.AddParameter("@PCDN_RTNum", pCD_NRecord.PCDN_RTNum);
}
if (pCD_NRecord.PCDN_CTNum == 0)
{
idb.AddParameter("@PCDN_CTNum", 0);
}
else
{
idb.AddParameter("@PCDN_CTNum", pCD_NRecord.PCDN_CTNum);
}
if (pCD_NRecord.PCDN_RRNum == 0)
{
idb.AddParameter("@PCDN_RRNum", 0);
}
else
{
idb.AddParameter("@PCDN_RRNum", pCD_NRecord.PCDN_RRNum);
}
if (pCD_NRecord.PCDN_MoreNum == 0)
{
idb.AddParameter("@PCDN_MoreNum", 0);
}
else
{
idb.AddParameter("@PCDN_MoreNum", pCD_NRecord.PCDN_MoreNum);
}
if (pCD_NRecord.PCDN_PRNum == 0)
{
idb.AddParameter("@PCDN_PRNum", 0);
}
else
{
idb.AddParameter("@PCDN_PRNum", pCD_NRecord.PCDN_PRNum);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_BStatus))
{
idb.AddParameter("@PCDN_BStatus", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_BStatus", pCD_NRecord.PCDN_BStatus);
}
if (pCD_NRecord.PCDN_TRNum == 0)
{
idb.AddParameter("@PCDN_TRNum", 0);
}
else
{
idb.AddParameter("@PCDN_TRNum", pCD_NRecord.PCDN_TRNum);
}
if (pCD_NRecord.PCDN_TBNum == 0)
{
idb.AddParameter("@PCDN_TBNum", 0);
}
else
{
idb.AddParameter("@PCDN_TBNum", pCD_NRecord.PCDN_TBNum);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TBBak))
{
idb.AddParameter("@PCDN_TBBak", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TBBak", pCD_NRecord.PCDN_TBBak);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Stat))
{
idb.AddParameter("@PCDN_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Stat", pCD_NRecord.PCDN_Stat);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_iType))
{
idb.AddParameter("@PCDN_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_iType", pCD_NRecord.PCDN_iType);
}
if (pCD_NRecord.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pCD_NRecord.Stat);
}
if (pCD_NRecord.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pCD_NRecord.CreateDate);
}
if (pCD_NRecord.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pCD_NRecord.UpdateDate);
}
if (pCD_NRecord.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pCD_NRecord.DeleteDate);
}
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_SourceCode))
{
idb.AddParameter("@PCDN_SourceCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_SourceCode", pCD_NRecord.PCDN_SourceCode);
}
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>
/// 更新发货记录 PCD_NRecord对象(即:一条记录
/// </summary>
public int Update(PCD_NRecord pCD_NRecord)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE PCD_NRecord SET ");
if(pCD_NRecord.PCDN_Code_IsChanged){sbParameter.Append("PCDN_Code=@PCDN_Code, ");}
if(pCD_NRecord.PCDN_CCode_IsChanged){sbParameter.Append("PCDN_CCode=@PCDN_CCode, ");}
if(pCD_NRecord.PCDN_PRCode_IsChanged){sbParameter.Append("PCDN_PRCode=@PCDN_PRCode, ");}
if(pCD_NRecord.PCDN_PCode_IsChanged){sbParameter.Append("PCDN_PCode=@PCDN_PCode, ");}
if(pCD_NRecord.PCDN_PDCode_IsChanged){sbParameter.Append("PCDN_PDCode=@PCDN_PDCode, ");}
if(pCD_NRecord.PCDN_PSCode_IsChanged){sbParameter.Append("PCDN_PSCode=@PCDN_PSCode, ");}
if(pCD_NRecord.PCDN_Part_IsChanged){sbParameter.Append("PCDN_Part=@PCDN_Part, ");}
if(pCD_NRecord.PCDN_Slump_IsChanged){sbParameter.Append("PCDN_Slump=@PCDN_Slump, ");}
if(pCD_NRecord.PCDN_Spec1_IsChanged){sbParameter.Append("PCDN_Spec1=@PCDN_Spec1, ");}
if(pCD_NRecord.PCDN_Spec2_IsChanged){sbParameter.Append("PCDN_Spec2=@PCDN_Spec2, ");}
if(pCD_NRecord.PCDN_TType_IsChanged){sbParameter.Append("PCDN_TType=@PCDN_TType, ");}
if(pCD_NRecord.PCDN_TEqu_IsChanged){sbParameter.Append("PCDN_TEqu=@PCDN_TEqu, ");}
if(pCD_NRecord.PCDN_SOwner_IsChanged){sbParameter.Append("PCDN_SOwner=@PCDN_SOwner, ");}
if(pCD_NRecord.PCDN_SDate_IsChanged){sbParameter.Append("PCDN_SDate=@PCDN_SDate, ");}
if(pCD_NRecord.PCDN_TBSta_IsChanged){sbParameter.Append("PCDN_TBSta=@PCDN_TBSta, ");}
if(pCD_NRecord.PCDN_TBLine_IsChanged){sbParameter.Append("PCDN_TBLine=@PCDN_TBLine, ");}
if(pCD_NRecord.PCDN_OOwner_IsChanged){sbParameter.Append("PCDN_OOwner=@PCDN_OOwner, ");}
if(pCD_NRecord.PCDN_ODate_IsChanged){sbParameter.Append("PCDN_ODate=@PCDN_ODate, ");}
if(pCD_NRecord.PCDN_ForeMan_IsChanged){sbParameter.Append("PCDN_ForeMan=@PCDN_ForeMan, ");}
if(pCD_NRecord.PCDN_PPLimit_IsChanged){sbParameter.Append("PCDN_PPLimit=@PCDN_PPLimit, ");}
if(pCD_NRecord.PCDN_DIType_IsChanged){sbParameter.Append("PCDN_DIType=@PCDN_DIType, ");}
if(pCD_NRecord.PCDN_DINum_IsChanged){sbParameter.Append("PCDN_DINum=@PCDN_DINum, ");}
if(pCD_NRecord.PCDN_PNum_IsChanged){sbParameter.Append("PCDN_PNum=@PCDN_PNum, ");}
if(pCD_NRecord.PCDN_PCNum_IsChanged){sbParameter.Append("PCDN_PCNum=@PCDN_PCNum, ");}
if(pCD_NRecord.PCDN_PTOrd_IsChanged){sbParameter.Append("PCDN_PTOrd=@PCDN_PTOrd, ");}
if(pCD_NRecord.PCDN_PCDrv_IsChanged){sbParameter.Append("PCDN_PCDrv=@PCDN_PCDrv, ");}
if(pCD_NRecord.PCDN_Comp_IsChanged){sbParameter.Append("PCDN_Comp=@PCDN_Comp, ");}
if(pCD_NRecord.PCDN_PCCode_IsChanged){sbParameter.Append("PCDN_PCCode=@PCDN_PCCode, ");}
if(pCD_NRecord.PCDN_PCNo_IsChanged){sbParameter.Append("PCDN_PCNo=@PCDN_PCNo, ");}
if(pCD_NRecord.PCDN_DDate_IsChanged){sbParameter.Append("PCDN_DDate=@PCDN_DDate, ");}
if(pCD_NRecord.PCDN_RDate_IsChanged){sbParameter.Append("PCDN_RDate=@PCDN_RDate, ");}
if(pCD_NRecord.PCDN_JBegin_IsChanged){sbParameter.Append("PCDN_JBegin=@PCDN_JBegin, ");}
if(pCD_NRecord.PCDN_JEnd_IsChanged){sbParameter.Append("PCDN_JEnd=@PCDN_JEnd, ");}
if(pCD_NRecord.PCDN_LDate_IsChanged){sbParameter.Append("PCDN_LDate=@PCDN_LDate, ");}
if(pCD_NRecord.PCDN_BDate_IsChanged){sbParameter.Append("PCDN_BDate=@PCDN_BDate, ");}
if(pCD_NRecord.PCDN_PPNum_IsChanged){sbParameter.Append("PCDN_PPNum=@PCDN_PPNum, ");}
if(pCD_NRecord.PCDN_TDNum_IsChanged){sbParameter.Append("PCDN_TDNum=@PCDN_TDNum, ");}
if(pCD_NRecord.PCDN_TTNum_IsChanged){sbParameter.Append("PCDN_TTNum=@PCDN_TTNum, ");}
if(pCD_NRecord.PCDN_RTNum_IsChanged){sbParameter.Append("PCDN_RTNum=@PCDN_RTNum, ");}
if(pCD_NRecord.PCDN_CTNum_IsChanged){sbParameter.Append("PCDN_CTNum=@PCDN_CTNum, ");}
if(pCD_NRecord.PCDN_RRNum_IsChanged){sbParameter.Append("PCDN_RRNum=@PCDN_RRNum, ");}
if(pCD_NRecord.PCDN_MoreNum_IsChanged){sbParameter.Append("PCDN_MoreNum=@PCDN_MoreNum, ");}
if(pCD_NRecord.PCDN_PRNum_IsChanged){sbParameter.Append("PCDN_PRNum=@PCDN_PRNum, ");}
if(pCD_NRecord.PCDN_BStatus_IsChanged){sbParameter.Append("PCDN_BStatus=@PCDN_BStatus, ");}
if(pCD_NRecord.PCDN_TRNum_IsChanged){sbParameter.Append("PCDN_TRNum=@PCDN_TRNum, ");}
if(pCD_NRecord.PCDN_TBNum_IsChanged){sbParameter.Append("PCDN_TBNum=@PCDN_TBNum, ");}
if(pCD_NRecord.PCDN_TBBak_IsChanged){sbParameter.Append("PCDN_TBBak=@PCDN_TBBak, ");}
if(pCD_NRecord.PCDN_Stat_IsChanged){sbParameter.Append("PCDN_Stat=@PCDN_Stat, ");}
if(pCD_NRecord.PCDN_iType_IsChanged){sbParameter.Append("PCDN_iType=@PCDN_iType, ");}
if(pCD_NRecord.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
if(pCD_NRecord.CreateDate_IsChanged){sbParameter.Append("CreateDate=@CreateDate, ");}
if(pCD_NRecord.UpdateDate_IsChanged){sbParameter.Append("UpdateDate=@UpdateDate, ");}
if(pCD_NRecord.DeleteDate_IsChanged){sbParameter.Append("DeleteDate=@DeleteDate, ");}
if(pCD_NRecord.PCDN_SourceCode_IsChanged){sbParameter.Append("PCDN_SourceCode=@PCDN_SourceCode ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PCDN_ID=@PCDN_ID; " );
string sql=sb.ToString();
if(pCD_NRecord.PCDN_Code_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Code))
{
idb.AddParameter("@PCDN_Code", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Code", pCD_NRecord.PCDN_Code);
}
}
if(pCD_NRecord.PCDN_CCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_CCode))
{
idb.AddParameter("@PCDN_CCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_CCode", pCD_NRecord.PCDN_CCode);
}
}
if(pCD_NRecord.PCDN_PRCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PRCode))
{
idb.AddParameter("@PCDN_PRCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PRCode", pCD_NRecord.PCDN_PRCode);
}
}
if(pCD_NRecord.PCDN_PCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCode))
{
idb.AddParameter("@PCDN_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCode", pCD_NRecord.PCDN_PCode);
}
}
if(pCD_NRecord.PCDN_PDCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PDCode))
{
idb.AddParameter("@PCDN_PDCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PDCode", pCD_NRecord.PCDN_PDCode);
}
}
if(pCD_NRecord.PCDN_PSCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PSCode))
{
idb.AddParameter("@PCDN_PSCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PSCode", pCD_NRecord.PCDN_PSCode);
}
}
if(pCD_NRecord.PCDN_Part_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Part))
{
idb.AddParameter("@PCDN_Part", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Part", pCD_NRecord.PCDN_Part);
}
}
if(pCD_NRecord.PCDN_Slump_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Slump))
{
idb.AddParameter("@PCDN_Slump", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Slump", pCD_NRecord.PCDN_Slump);
}
}
if(pCD_NRecord.PCDN_Spec1_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Spec1))
{
idb.AddParameter("@PCDN_Spec1", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Spec1", pCD_NRecord.PCDN_Spec1);
}
}
if(pCD_NRecord.PCDN_Spec2_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Spec2))
{
idb.AddParameter("@PCDN_Spec2", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Spec2", pCD_NRecord.PCDN_Spec2);
}
}
if(pCD_NRecord.PCDN_TType_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TType))
{
idb.AddParameter("@PCDN_TType", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TType", pCD_NRecord.PCDN_TType);
}
}
if(pCD_NRecord.PCDN_TEqu_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TEqu))
{
idb.AddParameter("@PCDN_TEqu", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TEqu", pCD_NRecord.PCDN_TEqu);
}
}
if(pCD_NRecord.PCDN_SOwner_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_SOwner))
{
idb.AddParameter("@PCDN_SOwner", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_SOwner", pCD_NRecord.PCDN_SOwner);
}
}
if(pCD_NRecord.PCDN_SDate_IsChanged)
{
if (pCD_NRecord.PCDN_SDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_SDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_SDate", pCD_NRecord.PCDN_SDate);
}
}
if(pCD_NRecord.PCDN_TBSta_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TBSta))
{
idb.AddParameter("@PCDN_TBSta", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TBSta", pCD_NRecord.PCDN_TBSta);
}
}
if(pCD_NRecord.PCDN_TBLine_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TBLine))
{
idb.AddParameter("@PCDN_TBLine", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TBLine", pCD_NRecord.PCDN_TBLine);
}
}
if(pCD_NRecord.PCDN_OOwner_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_OOwner))
{
idb.AddParameter("@PCDN_OOwner", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_OOwner", pCD_NRecord.PCDN_OOwner);
}
}
if(pCD_NRecord.PCDN_ODate_IsChanged)
{
if (pCD_NRecord.PCDN_ODate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_ODate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_ODate", pCD_NRecord.PCDN_ODate);
}
}
if(pCD_NRecord.PCDN_ForeMan_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_ForeMan))
{
idb.AddParameter("@PCDN_ForeMan", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_ForeMan", pCD_NRecord.PCDN_ForeMan);
}
}
if(pCD_NRecord.PCDN_PPLimit_IsChanged)
{
if (pCD_NRecord.PCDN_PPLimit == 0)
{
idb.AddParameter("@PCDN_PPLimit", 0);
}
else
{
idb.AddParameter("@PCDN_PPLimit", pCD_NRecord.PCDN_PPLimit);
}
}
if(pCD_NRecord.PCDN_DIType_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_DIType))
{
idb.AddParameter("@PCDN_DIType", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_DIType", pCD_NRecord.PCDN_DIType);
}
}
if(pCD_NRecord.PCDN_DINum_IsChanged)
{
if (pCD_NRecord.PCDN_DINum == 0)
{
idb.AddParameter("@PCDN_DINum", 0);
}
else
{
idb.AddParameter("@PCDN_DINum", pCD_NRecord.PCDN_DINum);
}
}
if(pCD_NRecord.PCDN_PNum_IsChanged)
{
if (pCD_NRecord.PCDN_PNum == 0)
{
idb.AddParameter("@PCDN_PNum", 0);
}
else
{
idb.AddParameter("@PCDN_PNum", pCD_NRecord.PCDN_PNum);
}
}
if(pCD_NRecord.PCDN_PCNum_IsChanged)
{
if (pCD_NRecord.PCDN_PCNum == 0)
{
idb.AddParameter("@PCDN_PCNum", 0);
}
else
{
idb.AddParameter("@PCDN_PCNum", pCD_NRecord.PCDN_PCNum);
}
}
if(pCD_NRecord.PCDN_PTOrd_IsChanged)
{
if (pCD_NRecord.PCDN_PTOrd == 0)
{
idb.AddParameter("@PCDN_PTOrd", 0);
}
else
{
idb.AddParameter("@PCDN_PTOrd", pCD_NRecord.PCDN_PTOrd);
}
}
if(pCD_NRecord.PCDN_PCDrv_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCDrv))
{
idb.AddParameter("@PCDN_PCDrv", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCDrv", pCD_NRecord.PCDN_PCDrv);
}
}
if(pCD_NRecord.PCDN_Comp_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Comp))
{
idb.AddParameter("@PCDN_Comp", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Comp", pCD_NRecord.PCDN_Comp);
}
}
if(pCD_NRecord.PCDN_PCCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCCode))
{
idb.AddParameter("@PCDN_PCCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCCode", pCD_NRecord.PCDN_PCCode);
}
}
if(pCD_NRecord.PCDN_PCNo_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_PCNo))
{
idb.AddParameter("@PCDN_PCNo", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_PCNo", pCD_NRecord.PCDN_PCNo);
}
}
if(pCD_NRecord.PCDN_DDate_IsChanged)
{
if (pCD_NRecord.PCDN_DDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_DDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_DDate", pCD_NRecord.PCDN_DDate);
}
}
if(pCD_NRecord.PCDN_RDate_IsChanged)
{
if (pCD_NRecord.PCDN_RDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_RDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_RDate", pCD_NRecord.PCDN_RDate);
}
}
if(pCD_NRecord.PCDN_JBegin_IsChanged)
{
if (pCD_NRecord.PCDN_JBegin == DateTime.MinValue)
{
idb.AddParameter("@PCDN_JBegin", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_JBegin", pCD_NRecord.PCDN_JBegin);
}
}
if(pCD_NRecord.PCDN_JEnd_IsChanged)
{
if (pCD_NRecord.PCDN_JEnd == DateTime.MinValue)
{
idb.AddParameter("@PCDN_JEnd", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_JEnd", pCD_NRecord.PCDN_JEnd);
}
}
if(pCD_NRecord.PCDN_LDate_IsChanged)
{
if (pCD_NRecord.PCDN_LDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_LDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_LDate", pCD_NRecord.PCDN_LDate);
}
}
if(pCD_NRecord.PCDN_BDate_IsChanged)
{
if (pCD_NRecord.PCDN_BDate == DateTime.MinValue)
{
idb.AddParameter("@PCDN_BDate", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_BDate", pCD_NRecord.PCDN_BDate);
}
}
if(pCD_NRecord.PCDN_PPNum_IsChanged)
{
if (pCD_NRecord.PCDN_PPNum == 0)
{
idb.AddParameter("@PCDN_PPNum", 0);
}
else
{
idb.AddParameter("@PCDN_PPNum", pCD_NRecord.PCDN_PPNum);
}
}
if(pCD_NRecord.PCDN_TDNum_IsChanged)
{
if (pCD_NRecord.PCDN_TDNum == 0)
{
idb.AddParameter("@PCDN_TDNum", 0);
}
else
{
idb.AddParameter("@PCDN_TDNum", pCD_NRecord.PCDN_TDNum);
}
}
if(pCD_NRecord.PCDN_TTNum_IsChanged)
{
if (pCD_NRecord.PCDN_TTNum == 0)
{
idb.AddParameter("@PCDN_TTNum", 0);
}
else
{
idb.AddParameter("@PCDN_TTNum", pCD_NRecord.PCDN_TTNum);
}
}
if(pCD_NRecord.PCDN_RTNum_IsChanged)
{
if (pCD_NRecord.PCDN_RTNum == 0)
{
idb.AddParameter("@PCDN_RTNum", 0);
}
else
{
idb.AddParameter("@PCDN_RTNum", pCD_NRecord.PCDN_RTNum);
}
}
if(pCD_NRecord.PCDN_CTNum_IsChanged)
{
if (pCD_NRecord.PCDN_CTNum == 0)
{
idb.AddParameter("@PCDN_CTNum", 0);
}
else
{
idb.AddParameter("@PCDN_CTNum", pCD_NRecord.PCDN_CTNum);
}
}
if(pCD_NRecord.PCDN_RRNum_IsChanged)
{
if (pCD_NRecord.PCDN_RRNum == 0)
{
idb.AddParameter("@PCDN_RRNum", 0);
}
else
{
idb.AddParameter("@PCDN_RRNum", pCD_NRecord.PCDN_RRNum);
}
}
if(pCD_NRecord.PCDN_MoreNum_IsChanged)
{
if (pCD_NRecord.PCDN_MoreNum == 0)
{
idb.AddParameter("@PCDN_MoreNum", 0);
}
else
{
idb.AddParameter("@PCDN_MoreNum", pCD_NRecord.PCDN_MoreNum);
}
}
if(pCD_NRecord.PCDN_PRNum_IsChanged)
{
if (pCD_NRecord.PCDN_PRNum == 0)
{
idb.AddParameter("@PCDN_PRNum", 0);
}
else
{
idb.AddParameter("@PCDN_PRNum", pCD_NRecord.PCDN_PRNum);
}
}
if(pCD_NRecord.PCDN_BStatus_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_BStatus))
{
idb.AddParameter("@PCDN_BStatus", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_BStatus", pCD_NRecord.PCDN_BStatus);
}
}
if(pCD_NRecord.PCDN_TRNum_IsChanged)
{
if (pCD_NRecord.PCDN_TRNum == 0)
{
idb.AddParameter("@PCDN_TRNum", 0);
}
else
{
idb.AddParameter("@PCDN_TRNum", pCD_NRecord.PCDN_TRNum);
}
}
if(pCD_NRecord.PCDN_TBNum_IsChanged)
{
if (pCD_NRecord.PCDN_TBNum == 0)
{
idb.AddParameter("@PCDN_TBNum", 0);
}
else
{
idb.AddParameter("@PCDN_TBNum", pCD_NRecord.PCDN_TBNum);
}
}
if(pCD_NRecord.PCDN_TBBak_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_TBBak))
{
idb.AddParameter("@PCDN_TBBak", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_TBBak", pCD_NRecord.PCDN_TBBak);
}
}
if(pCD_NRecord.PCDN_Stat_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_Stat))
{
idb.AddParameter("@PCDN_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_Stat", pCD_NRecord.PCDN_Stat);
}
}
if(pCD_NRecord.PCDN_iType_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_iType))
{
idb.AddParameter("@PCDN_iType", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_iType", pCD_NRecord.PCDN_iType);
}
}
if(pCD_NRecord.Stat_IsChanged)
{
if (pCD_NRecord.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", pCD_NRecord.Stat);
}
}
if(pCD_NRecord.CreateDate_IsChanged)
{
if (pCD_NRecord.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", pCD_NRecord.CreateDate);
}
}
if(pCD_NRecord.UpdateDate_IsChanged)
{
if (pCD_NRecord.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", pCD_NRecord.UpdateDate);
}
}
if(pCD_NRecord.DeleteDate_IsChanged)
{
if (pCD_NRecord.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", pCD_NRecord.DeleteDate);
}
}
if(pCD_NRecord.PCDN_SourceCode_IsChanged)
{
if (string.IsNullOrEmpty(pCD_NRecord.PCDN_SourceCode))
{
idb.AddParameter("@PCDN_SourceCode", DBNull.Value);
}
else
{
idb.AddParameter("@PCDN_SourceCode", pCD_NRecord.PCDN_SourceCode);
}
}
idb.AddParameter("@PCDN_ID", pCD_NRecord.PCDN_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_NRecord对象集合
/// </summary>
public List<PCD_NRecord> GetListByWhere(string strCondition,string select)
{
List<PCD_NRecord> ret = new List<PCD_NRecord>();
string sql = "select * from PCD_NRecord a JOIN WH_Supplier b ON a.pcdn_ccode=b.whs_custcode JOIN SD_Project c ON a.pcdn_prcode=c.sdi_code where (a.Stat is null or a.Stat=0 ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY PCDN_ID DESC ";
SqlDataReader dr = null;
try
{
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
PCD_NRecord pCD_NRecord = new PCD_NRecord();
if (dr["PCDN_ID"] != DBNull.Value) pCD_NRecord.PCDN_ID = Convert.ToDecimal(dr["PCDN_ID"]);
if (dr["PCDN_Code"] != DBNull.Value) pCD_NRecord.PCDN_Code = Convert.ToString(dr["PCDN_Code"]);
if (dr["PCDN_CCode"] != DBNull.Value) pCD_NRecord.PCDN_CCode = Convert.ToString(dr["PCDN_CCode"]);
if (dr["PCDN_PRCode"] != DBNull.Value) pCD_NRecord.PCDN_PRCode = Convert.ToString(dr["PCDN_PRCode"]);
if (dr["PCDN_PCode"] != DBNull.Value) pCD_NRecord.PCDN_PCode = Convert.ToString(dr["PCDN_PCode"]);
if (dr["PCDN_PDCode"] != DBNull.Value) pCD_NRecord.PCDN_PDCode = Convert.ToString(dr["PCDN_PDCode"]);
if (dr["PCDN_PSCode"] != DBNull.Value) pCD_NRecord.PCDN_PSCode = Convert.ToString(dr["PCDN_PSCode"]);
if (dr["PCDN_Part"] != DBNull.Value) pCD_NRecord.PCDN_Part = Convert.ToString(dr["PCDN_Part"]);
if (dr["PCDN_Slump"] != DBNull.Value) pCD_NRecord.PCDN_Slump = Convert.ToString(dr["PCDN_Slump"]);
if (dr["PCDN_Spec1"] != DBNull.Value) pCD_NRecord.PCDN_Spec1 = Convert.ToString(dr["PCDN_Spec1"]);
if (dr["PCDN_Spec2"] != DBNull.Value) pCD_NRecord.PCDN_Spec2 = Convert.ToString(dr["PCDN_Spec2"]);
if (dr["PCDN_TType"] != DBNull.Value) pCD_NRecord.PCDN_TType = Convert.ToString(dr["PCDN_TType"]);
if (dr["PCDN_TEqu"] != DBNull.Value) pCD_NRecord.PCDN_TEqu = Convert.ToString(dr["PCDN_TEqu"]);
if (dr["PCDN_SOwner"] != DBNull.Value) pCD_NRecord.PCDN_SOwner = Convert.ToString(dr["PCDN_SOwner"]);
if (dr["PCDN_SDate"] != DBNull.Value) pCD_NRecord.PCDN_SDate = Convert.ToDateTime(dr["PCDN_SDate"]);
if (dr["PCDN_TBSta"] != DBNull.Value) pCD_NRecord.PCDN_TBSta = Convert.ToString(dr["PCDN_TBSta"]);
if (dr["PCDN_TBLine"] != DBNull.Value) pCD_NRecord.PCDN_TBLine = Convert.ToString(dr["PCDN_TBLine"]);
if (dr["PCDN_OOwner"] != DBNull.Value) pCD_NRecord.PCDN_OOwner = Convert.ToString(dr["PCDN_OOwner"]);
if (dr["PCDN_ODate"] != DBNull.Value) pCD_NRecord.PCDN_ODate = Convert.ToDateTime(dr["PCDN_ODate"]);
if (dr["PCDN_PPLimit"] != DBNull.Value) pCD_NRecord.PCDN_PPLimit = Convert.ToDecimal(dr["PCDN_PPLimit"]);
if (dr["PCDN_DIType"] != DBNull.Value) pCD_NRecord.PCDN_DIType = Convert.ToString(dr["PCDN_DIType"]);
if (dr["PCDN_DINum"] != DBNull.Value) pCD_NRecord.PCDN_DINum = Convert.ToDecimal(dr["PCDN_DINum"]);
if (dr["PCDN_PNum"] != DBNull.Value) pCD_NRecord.PCDN_PNum = Convert.ToDecimal(dr["PCDN_PNum"]);
if (dr["PCDN_PCNum"] != DBNull.Value) pCD_NRecord.PCDN_PCNum = Convert.ToDecimal(dr["PCDN_PCNum"]);
if (dr["PCDN_PTOrd"] != DBNull.Value) pCD_NRecord.PCDN_PTOrd = Convert.ToInt32(dr["PCDN_PTOrd"]);
if (dr["PCDN_PCDrv"] != DBNull.Value) pCD_NRecord.PCDN_PCDrv = Convert.ToString(dr["PCDN_PCDrv"]);
if (dr["PCDN_PCCode"] != DBNull.Value) pCD_NRecord.PCDN_PCCode = Convert.ToString(dr["PCDN_PCCode"]);
if (dr["PCDN_PCNo"] != DBNull.Value) pCD_NRecord.PCDN_PCNo = Convert.ToString(dr["PCDN_PCNo"]);
if (dr["PCDN_DDate"] != DBNull.Value) pCD_NRecord.PCDN_DDate = Convert.ToDateTime(dr["PCDN_DDate"]);
if (dr["PCDN_RDate"] != DBNull.Value) pCD_NRecord.PCDN_RDate = Convert.ToDateTime(dr["PCDN_RDate"]);
if (dr["PCDN_JBegin"] != DBNull.Value) pCD_NRecord.PCDN_JBegin = Convert.ToDateTime(dr["PCDN_JBegin"]);
if (dr["PCDN_JEnd"] != DBNull.Value) pCD_NRecord.PCDN_JEnd = Convert.ToDateTime(dr["PCDN_JEnd"]);
if (dr["PCDN_LDate"] != DBNull.Value) pCD_NRecord.PCDN_LDate = Convert.ToDateTime(dr["PCDN_LDate"]);
if (dr["PCDN_BDate"] != DBNull.Value) pCD_NRecord.PCDN_BDate = Convert.ToDateTime(dr["PCDN_BDate"]);
if (dr["PCDN_PPNum"] != DBNull.Value) pCD_NRecord.PCDN_PPNum = Convert.ToDecimal(dr["PCDN_PPNum"]);
if (dr["PCDN_TDNum"] != DBNull.Value) pCD_NRecord.PCDN_TDNum = Convert.ToDecimal(dr["PCDN_TDNum"]);
if (dr["PCDN_TTNum"] != DBNull.Value) pCD_NRecord.PCDN_TTNum = Convert.ToInt32(dr["PCDN_TTNum"]);
if (dr["PCDN_RTNum"] != DBNull.Value) pCD_NRecord.PCDN_RTNum = Convert.ToDecimal(dr["PCDN_RTNum"]);
if (dr["PCDN_CTNum"] != DBNull.Value) pCD_NRecord.PCDN_CTNum = Convert.ToDecimal(dr["PCDN_CTNum"]);
if (dr["PCDN_RRNum"] != DBNull.Value) pCD_NRecord.PCDN_RRNum = Convert.ToDecimal(dr["PCDN_RRNum"]);
if (dr["PCDN_MoreNum"] != DBNull.Value) pCD_NRecord.PCDN_MoreNum = Convert.ToDecimal(dr["PCDN_MoreNum"]);
if (dr["PCDN_PRNum"] != DBNull.Value) pCD_NRecord.PCDN_PRNum = Convert.ToDecimal(dr["PCDN_PRNum"]);
if (dr["PCDN_BStatus"] != DBNull.Value) pCD_NRecord.PCDN_BStatus = Convert.ToString(dr["PCDN_BStatus"]);
if (dr["PCDN_TRNum"] != DBNull.Value) pCD_NRecord.PCDN_TRNum = Convert.ToDecimal(dr["PCDN_TRNum"]);
if (dr["PCDN_TBNum"] != DBNull.Value) pCD_NRecord.PCDN_TBNum = Convert.ToDecimal(dr["PCDN_TBNum"]);
if (dr["PCDN_TBBak"] != DBNull.Value) pCD_NRecord.PCDN_TBBak = Convert.ToString(dr["PCDN_TBBak"]);
if (dr["PCDN_Stat"] != DBNull.Value) pCD_NRecord.PCDN_Stat = Convert.ToString(dr["PCDN_Stat"]);
if (dr["CreateDate"] != DBNull.Value) pCD_NRecord.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["UpdateDate"] != DBNull.Value) pCD_NRecord.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
if (dr["DeleteDate"] != DBNull.Value) pCD_NRecord.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
ret.Add(pCD_NRecord);
}
}
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;
}