/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public PU_Main GetModel(string strCondition) { List<PU_Main> list = instance.GetListByWhere(strCondition); PU_Main model = new PU_Main(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return model; }
/// <summary> /// 转换实体 /// </summary> /// <param name="whIOMain"></param> /// <returns></returns> public static RefData ChangePUMainToRefData(PU_Main p) { return new RefData { PUM_TypeDescription = "采购相关单据", PUM_TechType = "PU", PUM_Type = p.PUM_RType, PUM_BOwner = p.PUM_BOwner, PUM_Discount = p.PUM_Discount , PUM_DisSum = p.PUM_DisSum, PUM_IDate = p.PUM_IDate , PUM_Owner = p.PUM_Owner, PUM_Payable = p.PUM_Payable , PUM_PDate = p.PUM_PDate, PUM_Code = p.PUM_RCode , PUM_RDate = p.PUM_RDate , PUM_SCode = p.PUM_SCode, PUM_SContact = p.PUM_SContact , PUM_SName = p.PUM_SName, PUM_STel = p.PUM_STel , PUM_Tax = p.PUM_Tax, PUM_Tranfee = p.PUM_Tranfee, PUM_RefCode = p.PUM_RefCode, PUM_RefType = p.PUM_RefType, PUM_Title=p.PUM_Title, PUM_UDEF1=p.PUM_UDEF1, PUM_UDEF2 = p.PUM_UDEF2, PUM_UDEF3 = p.PUM_UDEF3, PUM_UDEF4 = p.PUM_UDEF4, }; }
/// <summary> /// 获取指定的供应商往来主表 PU_Main对象(即:一条记录 /// </summary> public PU_Main GetByKey(decimal pUM_ID) { PU_Main pU_Main = new PU_Main(); string sql = "SELECT PUM_ID,PUM_RType,PUM_RCode,PUM_Title,PUM_SCode,PUM_SName,PUM_SContact,PUM_STel,PUM_State,PUM_PDate,PUM_IDate,PUM_RDate,PUM_Owner,PUM_Tranfee,PUM_Discount,PUM_DisSum,PUM_Tax,PUM_Payable,PUM_Bak,PUM_BOwner,PUM_RefType,PUM_RefCode,AuditStat,AuditCurAudit,PUM_Company,PUM_Dept,PUM_User,PUM_UseType,Stat,CreateDate,UpdateDate,DeleteDate,PUM_CompanyCode,PUM_DeptCode,PUM_Type,PUM_Operator,PUM_OCode,PUM_OpDate,PUM_UDEF1,PUM_UDEF2,PUM_UDEF3,PUM_UDEF4,PUM_UDEF5,PUM_UDEF6,PUM_UDEF7,PUM_UDEF8,PUM_UDEF9,PUM_UDEF10,PUM_OwnerCode FROM PU_Main WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND PUM_ID=@PUM_ID "; idb.AddParameter("@PUM_ID", pUM_ID); SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { if (dr["PUM_ID"] != DBNull.Value) pU_Main.PUM_ID = Convert.ToDecimal(dr["PUM_ID"]); if (dr["PUM_RType"] != DBNull.Value) pU_Main.PUM_RType = Convert.ToString(dr["PUM_RType"]); if (dr["PUM_RCode"] != DBNull.Value) pU_Main.PUM_RCode = Convert.ToString(dr["PUM_RCode"]); if (dr["PUM_Title"] != DBNull.Value) pU_Main.PUM_Title = Convert.ToString(dr["PUM_Title"]); if (dr["PUM_SCode"] != DBNull.Value) pU_Main.PUM_SCode = Convert.ToString(dr["PUM_SCode"]); if (dr["PUM_SName"] != DBNull.Value) pU_Main.PUM_SName = Convert.ToString(dr["PUM_SName"]); if (dr["PUM_SContact"] != DBNull.Value) pU_Main.PUM_SContact = Convert.ToString(dr["PUM_SContact"]); if (dr["PUM_STel"] != DBNull.Value) pU_Main.PUM_STel = Convert.ToString(dr["PUM_STel"]); if (dr["PUM_State"] != DBNull.Value) pU_Main.PUM_State = Convert.ToString(dr["PUM_State"]); if (dr["PUM_PDate"] != DBNull.Value) pU_Main.PUM_PDate = Convert.ToDateTime(dr["PUM_PDate"]); if (dr["PUM_IDate"] != DBNull.Value) pU_Main.PUM_IDate = Convert.ToDateTime(dr["PUM_IDate"]); if (dr["PUM_RDate"] != DBNull.Value) pU_Main.PUM_RDate = Convert.ToDateTime(dr["PUM_RDate"]); if (dr["PUM_Owner"] != DBNull.Value) pU_Main.PUM_Owner = Convert.ToString(dr["PUM_Owner"]); if (dr["PUM_Tranfee"] != DBNull.Value) pU_Main.PUM_Tranfee = Convert.ToDecimal(dr["PUM_Tranfee"]); if (dr["PUM_Discount"] != DBNull.Value) pU_Main.PUM_Discount = Convert.ToDecimal(dr["PUM_Discount"]); if (dr["PUM_DisSum"] != DBNull.Value) pU_Main.PUM_DisSum = Convert.ToDecimal(dr["PUM_DisSum"]); if (dr["PUM_Tax"] != DBNull.Value) pU_Main.PUM_Tax = Convert.ToDecimal(dr["PUM_Tax"]); if (dr["PUM_Payable"] != DBNull.Value) pU_Main.PUM_Payable = Convert.ToDecimal(dr["PUM_Payable"]); if (dr["PUM_Bak"] != DBNull.Value) pU_Main.PUM_Bak = Convert.ToString(dr["PUM_Bak"]); if (dr["PUM_BOwner"] != DBNull.Value) pU_Main.PUM_BOwner = Convert.ToString(dr["PUM_BOwner"]); if (dr["PUM_RefType"] != DBNull.Value) pU_Main.PUM_RefType = Convert.ToString(dr["PUM_RefType"]); if (dr["PUM_RefCode"] != DBNull.Value) pU_Main.PUM_RefCode = Convert.ToString(dr["PUM_RefCode"]); if (dr["AuditStat"] != DBNull.Value) pU_Main.AuditStat = Convert.ToString(dr["AuditStat"]); if (dr["AuditCurAudit"] != DBNull.Value) pU_Main.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]); if (dr["PUM_Company"] != DBNull.Value) pU_Main.PUM_Company = Convert.ToString(dr["PUM_Company"]); if (dr["PUM_Dept"] != DBNull.Value) pU_Main.PUM_Dept = Convert.ToString(dr["PUM_Dept"]); if (dr["PUM_User"] != DBNull.Value) pU_Main.PUM_User = Convert.ToString(dr["PUM_User"]); if (dr["PUM_UseType"] != DBNull.Value) pU_Main.PUM_UseType = Convert.ToString(dr["PUM_UseType"]); if (dr["Stat"] != DBNull.Value) pU_Main.Stat = Convert.ToInt32(dr["Stat"]); if (dr["CreateDate"] != DBNull.Value) pU_Main.CreateDate = Convert.ToDateTime(dr["CreateDate"]); if (dr["UpdateDate"] != DBNull.Value) pU_Main.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); if (dr["DeleteDate"] != DBNull.Value) pU_Main.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); if (dr["PUM_CompanyCode"] != DBNull.Value) pU_Main.PUM_CompanyCode = Convert.ToString(dr["PUM_CompanyCode"]); if (dr["PUM_DeptCode"] != DBNull.Value) pU_Main.PUM_DeptCode = Convert.ToString(dr["PUM_DeptCode"]); if (dr["PUM_Type"] != DBNull.Value) pU_Main.PUM_Type = Convert.ToString(dr["PUM_Type"]); if (dr["PUM_Operator"] != DBNull.Value) pU_Main.PUM_Operator = Convert.ToString(dr["PUM_Operator"]); if (dr["PUM_OCode"] != DBNull.Value) pU_Main.PUM_OCode = Convert.ToString(dr["PUM_OCode"]); if (dr["PUM_OpDate"] != DBNull.Value) pU_Main.PUM_OpDate = Convert.ToDateTime(dr["PUM_OpDate"]); if (dr["PUM_UDEF1"] != DBNull.Value) pU_Main.PUM_UDEF1 = Convert.ToString(dr["PUM_UDEF1"]); if (dr["PUM_UDEF2"] != DBNull.Value) pU_Main.PUM_UDEF2 = Convert.ToString(dr["PUM_UDEF2"]); if (dr["PUM_UDEF3"] != DBNull.Value) pU_Main.PUM_UDEF3 = Convert.ToString(dr["PUM_UDEF3"]); if (dr["PUM_UDEF4"] != DBNull.Value) pU_Main.PUM_UDEF4 = Convert.ToString(dr["PUM_UDEF4"]); if (dr["PUM_UDEF5"] != DBNull.Value) pU_Main.PUM_UDEF5 = Convert.ToString(dr["PUM_UDEF5"]); if (dr["PUM_UDEF6"] != DBNull.Value) pU_Main.PUM_UDEF6 = Convert.ToString(dr["PUM_UDEF6"]); if (dr["PUM_UDEF7"] != DBNull.Value) pU_Main.PUM_UDEF7 = Convert.ToString(dr["PUM_UDEF7"]); if (dr["PUM_UDEF8"] != DBNull.Value) pU_Main.PUM_UDEF8 = Convert.ToString(dr["PUM_UDEF8"]); if (dr["PUM_UDEF9"] != DBNull.Value) pU_Main.PUM_UDEF9 = Convert.ToString(dr["PUM_UDEF9"]); if (dr["PUM_UDEF10"] != DBNull.Value) pU_Main.PUM_UDEF10 = Convert.ToString(dr["PUM_UDEF10"]); if (dr["PUM_OwnerCode"] != DBNull.Value) pU_Main.PUM_OwnerCode = Convert.ToString(dr["PUM_OwnerCode"]); } }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 pU_Main; }
/// <summary> /// 添加供应商往来主表 PU_Main对象(即:一条记录) /// </summary> public object AddWithReturn(PU_Main pU_Main) { string sql = "INSERT INTO PU_Main (PUM_RType,PUM_RCode,PUM_Title,PUM_SCode,PUM_SName,PUM_SContact,PUM_STel,PUM_State,PUM_PDate,PUM_IDate,PUM_RDate,PUM_Owner,PUM_Tranfee,PUM_Discount,PUM_DisSum,PUM_Tax,PUM_Payable,PUM_Bak,PUM_BOwner,PUM_RefType,PUM_RefCode,AuditStat,AuditCurAudit,PUM_Company,PUM_Dept,PUM_User,PUM_UseType,Stat,CreateDate,UpdateDate,DeleteDate,PUM_CompanyCode,PUM_DeptCode,PUM_Type,PUM_Operator,PUM_OCode,PUM_OpDate,PUM_UDEF1,PUM_UDEF2,PUM_UDEF3,PUM_UDEF4,PUM_UDEF5,PUM_UDEF6,PUM_UDEF7,PUM_UDEF8,PUM_UDEF9,PUM_UDEF10,PUM_OwnerCode) VALUES (@PUM_RType,@PUM_RCode,@PUM_Title,@PUM_SCode,@PUM_SName,@PUM_SContact,@PUM_STel,@PUM_State,@PUM_PDate,@PUM_IDate,@PUM_RDate,@PUM_Owner,@PUM_Tranfee,@PUM_Discount,@PUM_DisSum,@PUM_Tax,@PUM_Payable,@PUM_Bak,@PUM_BOwner,@PUM_RefType,@PUM_RefCode,@AuditStat,@AuditCurAudit,@PUM_Company,@PUM_Dept,@PUM_User,@PUM_UseType,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@PUM_CompanyCode,@PUM_DeptCode,@PUM_Type,@PUM_Operator,@PUM_OCode,@PUM_OpDate,@PUM_UDEF1,@PUM_UDEF2,@PUM_UDEF3,@PUM_UDEF4,@PUM_UDEF5,@PUM_UDEF6,@PUM_UDEF7,@PUM_UDEF8,@PUM_UDEF9,@PUM_UDEF10,@PUM_OwnerCode);SELECT @@IDENTITY AS ReturnID;"; if (string.IsNullOrEmpty(pU_Main.PUM_RType)) { idb.AddParameter("@PUM_RType", DBNull.Value); } else { idb.AddParameter("@PUM_RType", pU_Main.PUM_RType); } if (string.IsNullOrEmpty(pU_Main.PUM_RCode)) { idb.AddParameter("@PUM_RCode", DBNull.Value); } else { idb.AddParameter("@PUM_RCode", pU_Main.PUM_RCode); } if (string.IsNullOrEmpty(pU_Main.PUM_Title)) { idb.AddParameter("@PUM_Title", DBNull.Value); } else { idb.AddParameter("@PUM_Title", pU_Main.PUM_Title); } if (string.IsNullOrEmpty(pU_Main.PUM_SCode)) { idb.AddParameter("@PUM_SCode", DBNull.Value); } else { idb.AddParameter("@PUM_SCode", pU_Main.PUM_SCode); } if (string.IsNullOrEmpty(pU_Main.PUM_SName)) { idb.AddParameter("@PUM_SName", DBNull.Value); } else { idb.AddParameter("@PUM_SName", pU_Main.PUM_SName); } if (string.IsNullOrEmpty(pU_Main.PUM_SContact)) { idb.AddParameter("@PUM_SContact", DBNull.Value); } else { idb.AddParameter("@PUM_SContact", pU_Main.PUM_SContact); } if (string.IsNullOrEmpty(pU_Main.PUM_STel)) { idb.AddParameter("@PUM_STel", DBNull.Value); } else { idb.AddParameter("@PUM_STel", pU_Main.PUM_STel); } if (string.IsNullOrEmpty(pU_Main.PUM_State)) { idb.AddParameter("@PUM_State", DBNull.Value); } else { idb.AddParameter("@PUM_State", pU_Main.PUM_State); } if (pU_Main.PUM_PDate == DateTime.MinValue) { idb.AddParameter("@PUM_PDate", DBNull.Value); } else { idb.AddParameter("@PUM_PDate", pU_Main.PUM_PDate); } if (pU_Main.PUM_IDate == DateTime.MinValue) { idb.AddParameter("@PUM_IDate", DBNull.Value); } else { idb.AddParameter("@PUM_IDate", pU_Main.PUM_IDate); } if (pU_Main.PUM_RDate == DateTime.MinValue) { idb.AddParameter("@PUM_RDate", DBNull.Value); } else { idb.AddParameter("@PUM_RDate", pU_Main.PUM_RDate); } if (string.IsNullOrEmpty(pU_Main.PUM_Owner)) { idb.AddParameter("@PUM_Owner", DBNull.Value); } else { idb.AddParameter("@PUM_Owner", pU_Main.PUM_Owner); } if (pU_Main.PUM_Tranfee == 0) { idb.AddParameter("@PUM_Tranfee", 0); } else { idb.AddParameter("@PUM_Tranfee", pU_Main.PUM_Tranfee); } if (pU_Main.PUM_Discount == 0) { idb.AddParameter("@PUM_Discount", 0); } else { idb.AddParameter("@PUM_Discount", pU_Main.PUM_Discount); } if (pU_Main.PUM_DisSum == 0) { idb.AddParameter("@PUM_DisSum", 0); } else { idb.AddParameter("@PUM_DisSum", pU_Main.PUM_DisSum); } if (pU_Main.PUM_Tax == 0) { idb.AddParameter("@PUM_Tax", 0); } else { idb.AddParameter("@PUM_Tax", pU_Main.PUM_Tax); } if (pU_Main.PUM_Payable == 0) { idb.AddParameter("@PUM_Payable", 0); } else { idb.AddParameter("@PUM_Payable", pU_Main.PUM_Payable); } if (string.IsNullOrEmpty(pU_Main.PUM_Bak)) { idb.AddParameter("@PUM_Bak", DBNull.Value); } else { idb.AddParameter("@PUM_Bak", pU_Main.PUM_Bak); } if (string.IsNullOrEmpty(pU_Main.PUM_BOwner)) { idb.AddParameter("@PUM_BOwner", DBNull.Value); } else { idb.AddParameter("@PUM_BOwner", pU_Main.PUM_BOwner); } if (string.IsNullOrEmpty(pU_Main.PUM_RefType)) { idb.AddParameter("@PUM_RefType", DBNull.Value); } else { idb.AddParameter("@PUM_RefType", pU_Main.PUM_RefType); } if (string.IsNullOrEmpty(pU_Main.PUM_RefCode)) { idb.AddParameter("@PUM_RefCode", DBNull.Value); } else { idb.AddParameter("@PUM_RefCode", pU_Main.PUM_RefCode); } if (string.IsNullOrEmpty(pU_Main.AuditStat)) { idb.AddParameter("@AuditStat", DBNull.Value); } else { idb.AddParameter("@AuditStat", pU_Main.AuditStat); } if (string.IsNullOrEmpty(pU_Main.AuditCurAudit)) { idb.AddParameter("@AuditCurAudit", DBNull.Value); } else { idb.AddParameter("@AuditCurAudit", pU_Main.AuditCurAudit); } if (string.IsNullOrEmpty(pU_Main.PUM_Company)) { idb.AddParameter("@PUM_Company", DBNull.Value); } else { idb.AddParameter("@PUM_Company", pU_Main.PUM_Company); } if (string.IsNullOrEmpty(pU_Main.PUM_Dept)) { idb.AddParameter("@PUM_Dept", DBNull.Value); } else { idb.AddParameter("@PUM_Dept", pU_Main.PUM_Dept); } if (string.IsNullOrEmpty(pU_Main.PUM_User)) { idb.AddParameter("@PUM_User", DBNull.Value); } else { idb.AddParameter("@PUM_User", pU_Main.PUM_User); } if (string.IsNullOrEmpty(pU_Main.PUM_UseType)) { idb.AddParameter("@PUM_UseType", DBNull.Value); } else { idb.AddParameter("@PUM_UseType", pU_Main.PUM_UseType); } if (pU_Main.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", pU_Main.Stat); } if (pU_Main.CreateDate == DateTime.MinValue) { idb.AddParameter("@CreateDate", DBNull.Value); } else { idb.AddParameter("@CreateDate", pU_Main.CreateDate); } if (pU_Main.UpdateDate == DateTime.MinValue) { idb.AddParameter("@UpdateDate", DBNull.Value); } else { idb.AddParameter("@UpdateDate", pU_Main.UpdateDate); } if (pU_Main.DeleteDate == DateTime.MinValue) { idb.AddParameter("@DeleteDate", DBNull.Value); } else { idb.AddParameter("@DeleteDate", pU_Main.DeleteDate); } if (string.IsNullOrEmpty(pU_Main.PUM_CompanyCode)) { idb.AddParameter("@PUM_CompanyCode", DBNull.Value); } else { idb.AddParameter("@PUM_CompanyCode", pU_Main.PUM_CompanyCode); } if (string.IsNullOrEmpty(pU_Main.PUM_DeptCode)) { idb.AddParameter("@PUM_DeptCode", DBNull.Value); } else { idb.AddParameter("@PUM_DeptCode", pU_Main.PUM_DeptCode); } if (string.IsNullOrEmpty(pU_Main.PUM_Type)) { idb.AddParameter("@PUM_Type", DBNull.Value); } else { idb.AddParameter("@PUM_Type", pU_Main.PUM_Type); } if (string.IsNullOrEmpty(pU_Main.PUM_Operator)) { idb.AddParameter("@PUM_Operator", DBNull.Value); } else { idb.AddParameter("@PUM_Operator", pU_Main.PUM_Operator); } if (string.IsNullOrEmpty(pU_Main.PUM_OCode)) { idb.AddParameter("@PUM_OCode", DBNull.Value); } else { idb.AddParameter("@PUM_OCode", pU_Main.PUM_OCode); } if (pU_Main.PUM_OpDate == DateTime.MinValue) { idb.AddParameter("@PUM_OpDate", DBNull.Value); } else { idb.AddParameter("@PUM_OpDate", pU_Main.PUM_OpDate); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF1)) { idb.AddParameter("@PUM_UDEF1", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF1", pU_Main.PUM_UDEF1); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF2)) { idb.AddParameter("@PUM_UDEF2", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF2", pU_Main.PUM_UDEF2); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF3)) { idb.AddParameter("@PUM_UDEF3", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF3", pU_Main.PUM_UDEF3); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF4)) { idb.AddParameter("@PUM_UDEF4", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF4", pU_Main.PUM_UDEF4); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF5)) { idb.AddParameter("@PUM_UDEF5", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF5", pU_Main.PUM_UDEF5); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF6)) { idb.AddParameter("@PUM_UDEF6", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF6", pU_Main.PUM_UDEF6); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF7)) { idb.AddParameter("@PUM_UDEF7", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF7", pU_Main.PUM_UDEF7); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF8)) { idb.AddParameter("@PUM_UDEF8", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF8", pU_Main.PUM_UDEF8); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF9)) { idb.AddParameter("@PUM_UDEF9", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF9", pU_Main.PUM_UDEF9); } if (string.IsNullOrEmpty(pU_Main.PUM_UDEF10)) { idb.AddParameter("@PUM_UDEF10", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF10", pU_Main.PUM_UDEF10); } if (string.IsNullOrEmpty(pU_Main.PUM_OwnerCode)) { idb.AddParameter("@PUM_OwnerCode", DBNull.Value); } else { idb.AddParameter("@PUM_OwnerCode", pU_Main.PUM_OwnerCode); } 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> /// 更新供应商往来主表 PU_Main对象(即:一条记录 /// </summary> public int Update(PU_Main pU_Main) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE PU_Main SET "); if(pU_Main.PUM_RType_IsChanged){sbParameter.Append("PUM_RType=@PUM_RType, ");} if(pU_Main.PUM_RCode_IsChanged){sbParameter.Append("PUM_RCode=@PUM_RCode, ");} if(pU_Main.PUM_Title_IsChanged){sbParameter.Append("PUM_Title=@PUM_Title, ");} if(pU_Main.PUM_SCode_IsChanged){sbParameter.Append("PUM_SCode=@PUM_SCode, ");} if(pU_Main.PUM_SName_IsChanged){sbParameter.Append("PUM_SName=@PUM_SName, ");} if(pU_Main.PUM_SContact_IsChanged){sbParameter.Append("PUM_SContact=@PUM_SContact, ");} if(pU_Main.PUM_STel_IsChanged){sbParameter.Append("PUM_STel=@PUM_STel, ");} if(pU_Main.PUM_State_IsChanged){sbParameter.Append("PUM_State=@PUM_State, ");} if(pU_Main.PUM_PDate_IsChanged){sbParameter.Append("PUM_PDate=@PUM_PDate, ");} if(pU_Main.PUM_IDate_IsChanged){sbParameter.Append("PUM_IDate=@PUM_IDate, ");} if(pU_Main.PUM_RDate_IsChanged){sbParameter.Append("PUM_RDate=@PUM_RDate, ");} if(pU_Main.PUM_Owner_IsChanged){sbParameter.Append("PUM_Owner=@PUM_Owner, ");} if(pU_Main.PUM_Tranfee_IsChanged){sbParameter.Append("PUM_Tranfee=@PUM_Tranfee, ");} if(pU_Main.PUM_Discount_IsChanged){sbParameter.Append("PUM_Discount=@PUM_Discount, ");} if(pU_Main.PUM_DisSum_IsChanged){sbParameter.Append("PUM_DisSum=@PUM_DisSum, ");} if(pU_Main.PUM_Tax_IsChanged){sbParameter.Append("PUM_Tax=@PUM_Tax, ");} if(pU_Main.PUM_Payable_IsChanged){sbParameter.Append("PUM_Payable=@PUM_Payable, ");} if(pU_Main.PUM_Bak_IsChanged){sbParameter.Append("PUM_Bak=@PUM_Bak, ");} if(pU_Main.PUM_BOwner_IsChanged){sbParameter.Append("PUM_BOwner=@PUM_BOwner, ");} if(pU_Main.PUM_RefType_IsChanged){sbParameter.Append("PUM_RefType=@PUM_RefType, ");} if(pU_Main.PUM_RefCode_IsChanged){sbParameter.Append("PUM_RefCode=@PUM_RefCode, ");} if(pU_Main.AuditStat_IsChanged){sbParameter.Append("AuditStat=@AuditStat, ");} if(pU_Main.AuditCurAudit_IsChanged){sbParameter.Append("AuditCurAudit=@AuditCurAudit, ");} if(pU_Main.PUM_Company_IsChanged){sbParameter.Append("PUM_Company=@PUM_Company, ");} if(pU_Main.PUM_Dept_IsChanged){sbParameter.Append("PUM_Dept=@PUM_Dept, ");} if(pU_Main.PUM_User_IsChanged){sbParameter.Append("PUM_User=@PUM_User, ");} if(pU_Main.PUM_UseType_IsChanged){sbParameter.Append("PUM_UseType=@PUM_UseType, ");} if(pU_Main.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(pU_Main.CreateDate_IsChanged){sbParameter.Append("CreateDate=@CreateDate, ");} if(pU_Main.UpdateDate_IsChanged){sbParameter.Append("UpdateDate=@UpdateDate, ");} if(pU_Main.DeleteDate_IsChanged){sbParameter.Append("DeleteDate=@DeleteDate, ");} if(pU_Main.PUM_CompanyCode_IsChanged){sbParameter.Append("PUM_CompanyCode=@PUM_CompanyCode, ");} if(pU_Main.PUM_DeptCode_IsChanged){sbParameter.Append("PUM_DeptCode=@PUM_DeptCode, ");} if(pU_Main.PUM_Type_IsChanged){sbParameter.Append("PUM_Type=@PUM_Type, ");} if(pU_Main.PUM_Operator_IsChanged){sbParameter.Append("PUM_Operator=@PUM_Operator, ");} if(pU_Main.PUM_OCode_IsChanged){sbParameter.Append("PUM_OCode=@PUM_OCode, ");} if(pU_Main.PUM_OpDate_IsChanged){sbParameter.Append("PUM_OpDate=@PUM_OpDate, ");} if(pU_Main.PUM_UDEF1_IsChanged){sbParameter.Append("PUM_UDEF1=@PUM_UDEF1, ");} if(pU_Main.PUM_UDEF2_IsChanged){sbParameter.Append("PUM_UDEF2=@PUM_UDEF2, ");} if(pU_Main.PUM_UDEF3_IsChanged){sbParameter.Append("PUM_UDEF3=@PUM_UDEF3, ");} if(pU_Main.PUM_UDEF4_IsChanged){sbParameter.Append("PUM_UDEF4=@PUM_UDEF4, ");} if(pU_Main.PUM_UDEF5_IsChanged){sbParameter.Append("PUM_UDEF5=@PUM_UDEF5, ");} if(pU_Main.PUM_UDEF6_IsChanged){sbParameter.Append("PUM_UDEF6=@PUM_UDEF6, ");} if(pU_Main.PUM_UDEF7_IsChanged){sbParameter.Append("PUM_UDEF7=@PUM_UDEF7, ");} if(pU_Main.PUM_UDEF8_IsChanged){sbParameter.Append("PUM_UDEF8=@PUM_UDEF8, ");} if(pU_Main.PUM_UDEF9_IsChanged){sbParameter.Append("PUM_UDEF9=@PUM_UDEF9, ");} if(pU_Main.PUM_UDEF10_IsChanged){sbParameter.Append("PUM_UDEF10=@PUM_UDEF10, ");} if(pU_Main.PUM_OwnerCode_IsChanged){sbParameter.Append("PUM_OwnerCode=@PUM_OwnerCode ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PUM_ID=@PUM_ID; " ); string sql=sb.ToString(); if(pU_Main.PUM_RType_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_RType)) { idb.AddParameter("@PUM_RType", DBNull.Value); } else { idb.AddParameter("@PUM_RType", pU_Main.PUM_RType); } } if(pU_Main.PUM_RCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_RCode)) { idb.AddParameter("@PUM_RCode", DBNull.Value); } else { idb.AddParameter("@PUM_RCode", pU_Main.PUM_RCode); } } if(pU_Main.PUM_Title_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Title)) { idb.AddParameter("@PUM_Title", DBNull.Value); } else { idb.AddParameter("@PUM_Title", pU_Main.PUM_Title); } } if(pU_Main.PUM_SCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_SCode)) { idb.AddParameter("@PUM_SCode", DBNull.Value); } else { idb.AddParameter("@PUM_SCode", pU_Main.PUM_SCode); } } if(pU_Main.PUM_SName_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_SName)) { idb.AddParameter("@PUM_SName", DBNull.Value); } else { idb.AddParameter("@PUM_SName", pU_Main.PUM_SName); } } if(pU_Main.PUM_SContact_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_SContact)) { idb.AddParameter("@PUM_SContact", DBNull.Value); } else { idb.AddParameter("@PUM_SContact", pU_Main.PUM_SContact); } } if(pU_Main.PUM_STel_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_STel)) { idb.AddParameter("@PUM_STel", DBNull.Value); } else { idb.AddParameter("@PUM_STel", pU_Main.PUM_STel); } } if(pU_Main.PUM_State_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_State)) { idb.AddParameter("@PUM_State", DBNull.Value); } else { idb.AddParameter("@PUM_State", pU_Main.PUM_State); } } if(pU_Main.PUM_PDate_IsChanged) { if (pU_Main.PUM_PDate == DateTime.MinValue) { idb.AddParameter("@PUM_PDate", DBNull.Value); } else { idb.AddParameter("@PUM_PDate", pU_Main.PUM_PDate); } } if(pU_Main.PUM_IDate_IsChanged) { if (pU_Main.PUM_IDate == DateTime.MinValue) { idb.AddParameter("@PUM_IDate", DBNull.Value); } else { idb.AddParameter("@PUM_IDate", pU_Main.PUM_IDate); } } if(pU_Main.PUM_RDate_IsChanged) { if (pU_Main.PUM_RDate == DateTime.MinValue) { idb.AddParameter("@PUM_RDate", DBNull.Value); } else { idb.AddParameter("@PUM_RDate", pU_Main.PUM_RDate); } } if(pU_Main.PUM_Owner_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Owner)) { idb.AddParameter("@PUM_Owner", DBNull.Value); } else { idb.AddParameter("@PUM_Owner", pU_Main.PUM_Owner); } } if(pU_Main.PUM_Tranfee_IsChanged) { if (pU_Main.PUM_Tranfee == 0) { idb.AddParameter("@PUM_Tranfee", 0); } else { idb.AddParameter("@PUM_Tranfee", pU_Main.PUM_Tranfee); } } if(pU_Main.PUM_Discount_IsChanged) { if (pU_Main.PUM_Discount == 0) { idb.AddParameter("@PUM_Discount", 0); } else { idb.AddParameter("@PUM_Discount", pU_Main.PUM_Discount); } } if(pU_Main.PUM_DisSum_IsChanged) { if (pU_Main.PUM_DisSum == 0) { idb.AddParameter("@PUM_DisSum", 0); } else { idb.AddParameter("@PUM_DisSum", pU_Main.PUM_DisSum); } } if(pU_Main.PUM_Tax_IsChanged) { if (pU_Main.PUM_Tax == 0) { idb.AddParameter("@PUM_Tax", 0); } else { idb.AddParameter("@PUM_Tax", pU_Main.PUM_Tax); } } if(pU_Main.PUM_Payable_IsChanged) { if (pU_Main.PUM_Payable == 0) { idb.AddParameter("@PUM_Payable", 0); } else { idb.AddParameter("@PUM_Payable", pU_Main.PUM_Payable); } } if(pU_Main.PUM_Bak_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Bak)) { idb.AddParameter("@PUM_Bak", DBNull.Value); } else { idb.AddParameter("@PUM_Bak", pU_Main.PUM_Bak); } } if(pU_Main.PUM_BOwner_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_BOwner)) { idb.AddParameter("@PUM_BOwner", DBNull.Value); } else { idb.AddParameter("@PUM_BOwner", pU_Main.PUM_BOwner); } } if(pU_Main.PUM_RefType_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_RefType)) { idb.AddParameter("@PUM_RefType", DBNull.Value); } else { idb.AddParameter("@PUM_RefType", pU_Main.PUM_RefType); } } if(pU_Main.PUM_RefCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_RefCode)) { idb.AddParameter("@PUM_RefCode", DBNull.Value); } else { idb.AddParameter("@PUM_RefCode", pU_Main.PUM_RefCode); } } if(pU_Main.AuditStat_IsChanged) { if (string.IsNullOrEmpty(pU_Main.AuditStat)) { idb.AddParameter("@AuditStat", DBNull.Value); } else { idb.AddParameter("@AuditStat", pU_Main.AuditStat); } } if(pU_Main.AuditCurAudit_IsChanged) { if (string.IsNullOrEmpty(pU_Main.AuditCurAudit)) { idb.AddParameter("@AuditCurAudit", DBNull.Value); } else { idb.AddParameter("@AuditCurAudit", pU_Main.AuditCurAudit); } } if(pU_Main.PUM_Company_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Company)) { idb.AddParameter("@PUM_Company", DBNull.Value); } else { idb.AddParameter("@PUM_Company", pU_Main.PUM_Company); } } if(pU_Main.PUM_Dept_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Dept)) { idb.AddParameter("@PUM_Dept", DBNull.Value); } else { idb.AddParameter("@PUM_Dept", pU_Main.PUM_Dept); } } if(pU_Main.PUM_User_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_User)) { idb.AddParameter("@PUM_User", DBNull.Value); } else { idb.AddParameter("@PUM_User", pU_Main.PUM_User); } } if(pU_Main.PUM_UseType_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UseType)) { idb.AddParameter("@PUM_UseType", DBNull.Value); } else { idb.AddParameter("@PUM_UseType", pU_Main.PUM_UseType); } } if(pU_Main.Stat_IsChanged) { if (pU_Main.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", pU_Main.Stat); } } if(pU_Main.CreateDate_IsChanged) { if (pU_Main.CreateDate == DateTime.MinValue) { idb.AddParameter("@CreateDate", DBNull.Value); } else { idb.AddParameter("@CreateDate", pU_Main.CreateDate); } } if(pU_Main.UpdateDate_IsChanged) { if (pU_Main.UpdateDate == DateTime.MinValue) { idb.AddParameter("@UpdateDate", DBNull.Value); } else { idb.AddParameter("@UpdateDate", pU_Main.UpdateDate); } } if(pU_Main.DeleteDate_IsChanged) { if (pU_Main.DeleteDate == DateTime.MinValue) { idb.AddParameter("@DeleteDate", DBNull.Value); } else { idb.AddParameter("@DeleteDate", pU_Main.DeleteDate); } } if(pU_Main.PUM_CompanyCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_CompanyCode)) { idb.AddParameter("@PUM_CompanyCode", DBNull.Value); } else { idb.AddParameter("@PUM_CompanyCode", pU_Main.PUM_CompanyCode); } } if(pU_Main.PUM_DeptCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_DeptCode)) { idb.AddParameter("@PUM_DeptCode", DBNull.Value); } else { idb.AddParameter("@PUM_DeptCode", pU_Main.PUM_DeptCode); } } if(pU_Main.PUM_Type_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Type)) { idb.AddParameter("@PUM_Type", DBNull.Value); } else { idb.AddParameter("@PUM_Type", pU_Main.PUM_Type); } } if(pU_Main.PUM_Operator_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_Operator)) { idb.AddParameter("@PUM_Operator", DBNull.Value); } else { idb.AddParameter("@PUM_Operator", pU_Main.PUM_Operator); } } if(pU_Main.PUM_OCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_OCode)) { idb.AddParameter("@PUM_OCode", DBNull.Value); } else { idb.AddParameter("@PUM_OCode", pU_Main.PUM_OCode); } } if(pU_Main.PUM_OpDate_IsChanged) { if (pU_Main.PUM_OpDate == DateTime.MinValue) { idb.AddParameter("@PUM_OpDate", DBNull.Value); } else { idb.AddParameter("@PUM_OpDate", pU_Main.PUM_OpDate); } } if(pU_Main.PUM_UDEF1_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF1)) { idb.AddParameter("@PUM_UDEF1", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF1", pU_Main.PUM_UDEF1); } } if(pU_Main.PUM_UDEF2_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF2)) { idb.AddParameter("@PUM_UDEF2", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF2", pU_Main.PUM_UDEF2); } } if(pU_Main.PUM_UDEF3_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF3)) { idb.AddParameter("@PUM_UDEF3", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF3", pU_Main.PUM_UDEF3); } } if(pU_Main.PUM_UDEF4_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF4)) { idb.AddParameter("@PUM_UDEF4", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF4", pU_Main.PUM_UDEF4); } } if(pU_Main.PUM_UDEF5_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF5)) { idb.AddParameter("@PUM_UDEF5", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF5", pU_Main.PUM_UDEF5); } } if(pU_Main.PUM_UDEF6_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF6)) { idb.AddParameter("@PUM_UDEF6", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF6", pU_Main.PUM_UDEF6); } } if(pU_Main.PUM_UDEF7_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF7)) { idb.AddParameter("@PUM_UDEF7", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF7", pU_Main.PUM_UDEF7); } } if(pU_Main.PUM_UDEF8_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF8)) { idb.AddParameter("@PUM_UDEF8", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF8", pU_Main.PUM_UDEF8); } } if(pU_Main.PUM_UDEF9_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF9)) { idb.AddParameter("@PUM_UDEF9", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF9", pU_Main.PUM_UDEF9); } } if(pU_Main.PUM_UDEF10_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_UDEF10)) { idb.AddParameter("@PUM_UDEF10", DBNull.Value); } else { idb.AddParameter("@PUM_UDEF10", pU_Main.PUM_UDEF10); } } if(pU_Main.PUM_OwnerCode_IsChanged) { if (string.IsNullOrEmpty(pU_Main.PUM_OwnerCode)) { idb.AddParameter("@PUM_OwnerCode", DBNull.Value); } else { idb.AddParameter("@PUM_OwnerCode", pU_Main.PUM_OwnerCode); } } idb.AddParameter("@PUM_ID", pU_Main.PUM_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> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(PU_Main 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(PU_Main 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(PU_Main model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }