/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(PCD_NRecord model)
{
bool result = false;
var e = new ModelExceptions();
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return result;
}
/// <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'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List<PCD_NRecord> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
PCD_NRecord model = list[0];
model.Stat = 1;
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>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public PCD_NRecord GetModel(int id)
{
PCD_NRecord model = instance.GetByKey(id);
return model;
}
/// <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);
}
