/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public PU_SMain GetModel(string strCondition) { List<PU_SMain> list = instance.GetListByWhere(strCondition); PU_SMain model = new PU_SMain(); 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(PU_SMain 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(PU_SMain 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(PU_SMain model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }
/// <summary> /// 更新PU_SMain对象(即:一条记录 /// </summary> public int Update(PU_SMain pU_SMain) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE PU_SMain SET "); if(pU_SMain.PUS_Type_IsChanged){sbParameter.Append("PUS_Type=@PUS_Type, ");} if(pU_SMain.PUS_RCode_IsChanged){sbParameter.Append("PUS_RCode=@PUS_RCode, ");} if(pU_SMain.PUS_Company_IsChanged){sbParameter.Append("PUS_Company=@PUS_Company, ");} if(pU_SMain.PUS_CompanyName_IsChanged){sbParameter.Append("PUS_CompanyName=@PUS_CompanyName, ");} if(pU_SMain.PUS_Dept_IsChanged){sbParameter.Append("PUS_Dept=@PUS_Dept, ");} if(pU_SMain.PUS_MCode_IsChanged){sbParameter.Append("PUS_MCode=@PUS_MCode, ");} if(pU_SMain.PUS_MName_IsChanged){sbParameter.Append("PUS_MName=@PUS_MName, ");} if(pU_SMain.PUS_Owner_IsChanged){sbParameter.Append("PUS_Owner=@PUS_Owner, ");} if(pU_SMain.PUS_Num_IsChanged){sbParameter.Append("PUS_Num=@PUS_Num, ");} if(pU_SMain.PUS_Unit_IsChanged){sbParameter.Append("PUS_Unit=@PUS_Unit, ");} if(pU_SMain.PUS_Units_IsChanged){sbParameter.Append("PUS_Units=@PUS_Units, ");} if(pU_SMain.PUS_Stat_IsChanged){sbParameter.Append("PUS_Stat=@PUS_Stat, ");} if(pU_SMain.PUS_Spec_IsChanged){sbParameter.Append("PUS_Spec=@PUS_Spec, ");} if(pU_SMain.PUS_PDate_IsChanged){sbParameter.Append("PUS_PDate=@PUS_PDate, ");} if(pU_SMain.PUS_IDate_IsChanged){sbParameter.Append("PUS_IDate=@PUS_IDate, ");} if(pU_SMain.PUS_RDate_IsChanged){sbParameter.Append("PUS_RDate=@PUS_RDate, ");} if(pU_SMain.PUS_WOwner_IsChanged){sbParameter.Append("PUS_WOwner=@PUS_WOwner, ");} if(pU_SMain.PUS_BOwner_IsChanged){sbParameter.Append("PUS_BOwner=@PUS_BOwner, ");} if(pU_SMain.PUS_TranFee_IsChanged){sbParameter.Append("PUS_TranFee=@PUS_TranFee, ");} if(pU_SMain.PUS_Price_IsChanged){sbParameter.Append("PUS_Price=@PUS_Price, ");} if(pU_SMain.PUS_Sum_IsChanged){sbParameter.Append("PUS_Sum=@PUS_Sum, ");} if(pU_SMain.PUS_RefType_IsChanged){sbParameter.Append("PUS_RefType=@PUS_RefType, ");} if(pU_SMain.PUS_RefCode_IsChanged){sbParameter.Append("PUS_RefCode=@PUS_RefCode, ");} if(pU_SMain.PUS_SupType_IsChanged){sbParameter.Append("PUS_SupType=@PUS_SupType, ");} if(pU_SMain.PUS_UDef1_IsChanged){sbParameter.Append("PUS_UDef1=@PUS_UDef1, ");} if(pU_SMain.PUS_UDef2_IsChanged){sbParameter.Append("PUS_UDef2=@PUS_UDef2, ");} if(pU_SMain.PUS_UDef3_IsChanged){sbParameter.Append("PUS_UDef3=@PUS_UDef3, ");} if(pU_SMain.PUS_UDef4_IsChanged){sbParameter.Append("PUS_UDef4=@PUS_UDef4, ");} if(pU_SMain.PUS_UDef5_IsChanged){sbParameter.Append("PUS_UDef5=@PUS_UDef5, ");} if(pU_SMain.PUS_UDef6_IsChanged){sbParameter.Append("PUS_UDef6=@PUS_UDef6, ");} if(pU_SMain.PUS_UDef7_IsChanged){sbParameter.Append("PUS_UDef7=@PUS_UDef7, ");} if(pU_SMain.PUS_Remark_IsChanged){sbParameter.Append("PUS_Remark=@PUS_Remark, ");} if(pU_SMain.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(pU_SMain.CreateDate_IsChanged){sbParameter.Append("CreateDate=@CreateDate, ");} if(pU_SMain.UpdateDate_IsChanged){sbParameter.Append("UpdateDate=@UpdateDate, ");} if(pU_SMain.DeleteDate_IsChanged){sbParameter.Append("DeleteDate=@DeleteDate, ");} if(pU_SMain.AuditStat_IsChanged){sbParameter.Append("AuditStat=@AuditStat, ");} if(pU_SMain.AuditCurAudit_IsChanged){sbParameter.Append("AuditCurAudit=@AuditCurAudit ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and PUS_ID=@PUS_ID; " ); string sql=sb.ToString(); if(pU_SMain.PUS_Type_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Type)) { idb.AddParameter("@PUS_Type", DBNull.Value); } else { idb.AddParameter("@PUS_Type", pU_SMain.PUS_Type); } } if(pU_SMain.PUS_RCode_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_RCode)) { idb.AddParameter("@PUS_RCode", DBNull.Value); } else { idb.AddParameter("@PUS_RCode", pU_SMain.PUS_RCode); } } if(pU_SMain.PUS_Company_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Company)) { idb.AddParameter("@PUS_Company", DBNull.Value); } else { idb.AddParameter("@PUS_Company", pU_SMain.PUS_Company); } } if(pU_SMain.PUS_CompanyName_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_CompanyName)) { idb.AddParameter("@PUS_CompanyName", DBNull.Value); } else { idb.AddParameter("@PUS_CompanyName", pU_SMain.PUS_CompanyName); } } if(pU_SMain.PUS_Dept_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Dept)) { idb.AddParameter("@PUS_Dept", DBNull.Value); } else { idb.AddParameter("@PUS_Dept", pU_SMain.PUS_Dept); } } if(pU_SMain.PUS_MCode_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_MCode)) { idb.AddParameter("@PUS_MCode", DBNull.Value); } else { idb.AddParameter("@PUS_MCode", pU_SMain.PUS_MCode); } } if(pU_SMain.PUS_MName_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_MName)) { idb.AddParameter("@PUS_MName", DBNull.Value); } else { idb.AddParameter("@PUS_MName", pU_SMain.PUS_MName); } } if(pU_SMain.PUS_Owner_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Owner)) { idb.AddParameter("@PUS_Owner", DBNull.Value); } else { idb.AddParameter("@PUS_Owner", pU_SMain.PUS_Owner); } } if(pU_SMain.PUS_Num_IsChanged) { if (pU_SMain.PUS_Num == 0) { idb.AddParameter("@PUS_Num", 0); } else { idb.AddParameter("@PUS_Num", pU_SMain.PUS_Num); } } if(pU_SMain.PUS_Unit_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Unit)) { idb.AddParameter("@PUS_Unit", DBNull.Value); } else { idb.AddParameter("@PUS_Unit", pU_SMain.PUS_Unit); } } if(pU_SMain.PUS_Units_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Units)) { idb.AddParameter("@PUS_Units", DBNull.Value); } else { idb.AddParameter("@PUS_Units", pU_SMain.PUS_Units); } } if(pU_SMain.PUS_Stat_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Stat)) { idb.AddParameter("@PUS_Stat", DBNull.Value); } else { idb.AddParameter("@PUS_Stat", pU_SMain.PUS_Stat); } } if(pU_SMain.PUS_Spec_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Spec)) { idb.AddParameter("@PUS_Spec", DBNull.Value); } else { idb.AddParameter("@PUS_Spec", pU_SMain.PUS_Spec); } } if(pU_SMain.PUS_PDate_IsChanged) { if (pU_SMain.PUS_PDate == DateTime.MinValue) { idb.AddParameter("@PUS_PDate", DBNull.Value); } else { idb.AddParameter("@PUS_PDate", pU_SMain.PUS_PDate); } } if(pU_SMain.PUS_IDate_IsChanged) { if (pU_SMain.PUS_IDate == DateTime.MinValue) { idb.AddParameter("@PUS_IDate", DBNull.Value); } else { idb.AddParameter("@PUS_IDate", pU_SMain.PUS_IDate); } } if(pU_SMain.PUS_RDate_IsChanged) { if (pU_SMain.PUS_RDate == DateTime.MinValue) { idb.AddParameter("@PUS_RDate", DBNull.Value); } else { idb.AddParameter("@PUS_RDate", pU_SMain.PUS_RDate); } } if(pU_SMain.PUS_WOwner_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_WOwner)) { idb.AddParameter("@PUS_WOwner", DBNull.Value); } else { idb.AddParameter("@PUS_WOwner", pU_SMain.PUS_WOwner); } } if(pU_SMain.PUS_BOwner_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_BOwner)) { idb.AddParameter("@PUS_BOwner", DBNull.Value); } else { idb.AddParameter("@PUS_BOwner", pU_SMain.PUS_BOwner); } } if(pU_SMain.PUS_TranFee_IsChanged) { if (pU_SMain.PUS_TranFee == 0) { idb.AddParameter("@PUS_TranFee", 0); } else { idb.AddParameter("@PUS_TranFee", pU_SMain.PUS_TranFee); } } if(pU_SMain.PUS_Price_IsChanged) { if (pU_SMain.PUS_Price == 0) { idb.AddParameter("@PUS_Price", 0); } else { idb.AddParameter("@PUS_Price", pU_SMain.PUS_Price); } } if(pU_SMain.PUS_Sum_IsChanged) { if (pU_SMain.PUS_Sum == 0) { idb.AddParameter("@PUS_Sum", 0); } else { idb.AddParameter("@PUS_Sum", pU_SMain.PUS_Sum); } } if(pU_SMain.PUS_RefType_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_RefType)) { idb.AddParameter("@PUS_RefType", DBNull.Value); } else { idb.AddParameter("@PUS_RefType", pU_SMain.PUS_RefType); } } if(pU_SMain.PUS_RefCode_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_RefCode)) { idb.AddParameter("@PUS_RefCode", DBNull.Value); } else { idb.AddParameter("@PUS_RefCode", pU_SMain.PUS_RefCode); } } if(pU_SMain.PUS_SupType_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_SupType)) { idb.AddParameter("@PUS_SupType", DBNull.Value); } else { idb.AddParameter("@PUS_SupType", pU_SMain.PUS_SupType); } } if(pU_SMain.PUS_UDef1_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef1)) { idb.AddParameter("@PUS_UDef1", DBNull.Value); } else { idb.AddParameter("@PUS_UDef1", pU_SMain.PUS_UDef1); } } if(pU_SMain.PUS_UDef2_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef2)) { idb.AddParameter("@PUS_UDef2", DBNull.Value); } else { idb.AddParameter("@PUS_UDef2", pU_SMain.PUS_UDef2); } } if(pU_SMain.PUS_UDef3_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef3)) { idb.AddParameter("@PUS_UDef3", DBNull.Value); } else { idb.AddParameter("@PUS_UDef3", pU_SMain.PUS_UDef3); } } if(pU_SMain.PUS_UDef4_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef4)) { idb.AddParameter("@PUS_UDef4", DBNull.Value); } else { idb.AddParameter("@PUS_UDef4", pU_SMain.PUS_UDef4); } } if(pU_SMain.PUS_UDef5_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef5)) { idb.AddParameter("@PUS_UDef5", DBNull.Value); } else { idb.AddParameter("@PUS_UDef5", pU_SMain.PUS_UDef5); } } if(pU_SMain.PUS_UDef6_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef6)) { idb.AddParameter("@PUS_UDef6", DBNull.Value); } else { idb.AddParameter("@PUS_UDef6", pU_SMain.PUS_UDef6); } } if(pU_SMain.PUS_UDef7_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_UDef7)) { idb.AddParameter("@PUS_UDef7", DBNull.Value); } else { idb.AddParameter("@PUS_UDef7", pU_SMain.PUS_UDef7); } } if(pU_SMain.PUS_Remark_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.PUS_Remark)) { idb.AddParameter("@PUS_Remark", DBNull.Value); } else { idb.AddParameter("@PUS_Remark", pU_SMain.PUS_Remark); } } if(pU_SMain.Stat_IsChanged) { if (pU_SMain.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", pU_SMain.Stat); } } if(pU_SMain.CreateDate_IsChanged) { if (pU_SMain.CreateDate == DateTime.MinValue) { idb.AddParameter("@CreateDate", DBNull.Value); } else { idb.AddParameter("@CreateDate", pU_SMain.CreateDate); } } if(pU_SMain.UpdateDate_IsChanged) { if (pU_SMain.UpdateDate == DateTime.MinValue) { idb.AddParameter("@UpdateDate", DBNull.Value); } else { idb.AddParameter("@UpdateDate", pU_SMain.UpdateDate); } } if(pU_SMain.DeleteDate_IsChanged) { if (pU_SMain.DeleteDate == DateTime.MinValue) { idb.AddParameter("@DeleteDate", DBNull.Value); } else { idb.AddParameter("@DeleteDate", pU_SMain.DeleteDate); } } if(pU_SMain.AuditStat_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.AuditStat)) { idb.AddParameter("@AuditStat", DBNull.Value); } else { idb.AddParameter("@AuditStat", pU_SMain.AuditStat); } } if(pU_SMain.AuditCurAudit_IsChanged) { if (string.IsNullOrEmpty(pU_SMain.AuditCurAudit)) { idb.AddParameter("@AuditCurAudit", DBNull.Value); } else { idb.AddParameter("@AuditCurAudit", pU_SMain.AuditCurAudit); } } idb.AddParameter("@PUS_ID", pU_SMain.PUS_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> /// 获取指定的PU_SMain对象集合 /// </summary> public List<PU_SMain> GetListByWhere(string strCondition) { List<PU_SMain> ret = new List<PU_SMain>(); string sql = "SELECT PUS_ID,PUS_Type,PUS_RCode,PUS_Company,PUS_CompanyName,PUS_Dept,PUS_MCode,PUS_MName,PUS_Owner,PUS_Num,PUS_Unit,PUS_Units,PUS_Stat,PUS_Spec,PUS_PDate,PUS_IDate,PUS_RDate,PUS_WOwner,PUS_BOwner,PUS_TranFee,PUS_Price,PUS_Sum,PUS_RefType,PUS_RefCode,PUS_SupType,PUS_UDef1,PUS_UDef2,PUS_UDef3,PUS_UDef4,PUS_UDef5,PUS_UDef6,PUS_UDef7,PUS_Remark,Stat,CreateDate,UpdateDate,DeleteDate,AuditStat,AuditCurAudit FROM PU_SMain 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()) { PU_SMain pU_SMain = new PU_SMain(); if (dr["PUS_ID"] != DBNull.Value) pU_SMain.PUS_ID = Convert.ToDecimal(dr["PUS_ID"]); if (dr["PUS_Type"] != DBNull.Value) pU_SMain.PUS_Type = Convert.ToString(dr["PUS_Type"]); if (dr["PUS_RCode"] != DBNull.Value) pU_SMain.PUS_RCode = Convert.ToString(dr["PUS_RCode"]); if (dr["PUS_Company"] != DBNull.Value) pU_SMain.PUS_Company = Convert.ToString(dr["PUS_Company"]); if (dr["PUS_CompanyName"] != DBNull.Value) pU_SMain.PUS_CompanyName = Convert.ToString(dr["PUS_CompanyName"]); if (dr["PUS_Dept"] != DBNull.Value) pU_SMain.PUS_Dept = Convert.ToString(dr["PUS_Dept"]); if (dr["PUS_MCode"] != DBNull.Value) pU_SMain.PUS_MCode = Convert.ToString(dr["PUS_MCode"]); if (dr["PUS_MName"] != DBNull.Value) pU_SMain.PUS_MName = Convert.ToString(dr["PUS_MName"]); if (dr["PUS_Owner"] != DBNull.Value) pU_SMain.PUS_Owner = Convert.ToString(dr["PUS_Owner"]); if (dr["PUS_Num"] != DBNull.Value) pU_SMain.PUS_Num = Convert.ToDecimal(dr["PUS_Num"]); if (dr["PUS_Unit"] != DBNull.Value) pU_SMain.PUS_Unit = Convert.ToString(dr["PUS_Unit"]); if (dr["PUS_Units"] != DBNull.Value) pU_SMain.PUS_Units = Convert.ToString(dr["PUS_Units"]); if (dr["PUS_Stat"] != DBNull.Value) pU_SMain.PUS_Stat = Convert.ToString(dr["PUS_Stat"]); if (dr["PUS_Spec"] != DBNull.Value) pU_SMain.PUS_Spec = Convert.ToString(dr["PUS_Spec"]); if (dr["PUS_PDate"] != DBNull.Value) pU_SMain.PUS_PDate = Convert.ToDateTime(dr["PUS_PDate"]); if (dr["PUS_IDate"] != DBNull.Value) pU_SMain.PUS_IDate = Convert.ToDateTime(dr["PUS_IDate"]); if (dr["PUS_RDate"] != DBNull.Value) pU_SMain.PUS_RDate = Convert.ToDateTime(dr["PUS_RDate"]); if (dr["PUS_WOwner"] != DBNull.Value) pU_SMain.PUS_WOwner = Convert.ToString(dr["PUS_WOwner"]); if (dr["PUS_BOwner"] != DBNull.Value) pU_SMain.PUS_BOwner = Convert.ToString(dr["PUS_BOwner"]); if (dr["PUS_TranFee"] != DBNull.Value) pU_SMain.PUS_TranFee = Convert.ToDecimal(dr["PUS_TranFee"]); if (dr["PUS_Price"] != DBNull.Value) pU_SMain.PUS_Price = Convert.ToDecimal(dr["PUS_Price"]); if (dr["PUS_Sum"] != DBNull.Value) pU_SMain.PUS_Sum = Convert.ToDecimal(dr["PUS_Sum"]); if (dr["PUS_RefType"] != DBNull.Value) pU_SMain.PUS_RefType = Convert.ToString(dr["PUS_RefType"]); if (dr["PUS_RefCode"] != DBNull.Value) pU_SMain.PUS_RefCode = Convert.ToString(dr["PUS_RefCode"]); if (dr["PUS_SupType"] != DBNull.Value) pU_SMain.PUS_SupType = Convert.ToString(dr["PUS_SupType"]); if (dr["PUS_UDef1"] != DBNull.Value) pU_SMain.PUS_UDef1 = Convert.ToString(dr["PUS_UDef1"]); if (dr["PUS_UDef2"] != DBNull.Value) pU_SMain.PUS_UDef2 = Convert.ToString(dr["PUS_UDef2"]); if (dr["PUS_UDef3"] != DBNull.Value) pU_SMain.PUS_UDef3 = Convert.ToString(dr["PUS_UDef3"]); if (dr["PUS_UDef4"] != DBNull.Value) pU_SMain.PUS_UDef4 = Convert.ToString(dr["PUS_UDef4"]); if (dr["PUS_UDef5"] != DBNull.Value) pU_SMain.PUS_UDef5 = Convert.ToString(dr["PUS_UDef5"]); if (dr["PUS_UDef6"] != DBNull.Value) pU_SMain.PUS_UDef6 = Convert.ToString(dr["PUS_UDef6"]); if (dr["PUS_UDef7"] != DBNull.Value) pU_SMain.PUS_UDef7 = Convert.ToString(dr["PUS_UDef7"]); if (dr["PUS_Remark"] != DBNull.Value) pU_SMain.PUS_Remark = Convert.ToString(dr["PUS_Remark"]); if (dr["Stat"] != DBNull.Value) pU_SMain.Stat = Convert.ToInt32(dr["Stat"]); if (dr["CreateDate"] != DBNull.Value) pU_SMain.CreateDate = Convert.ToDateTime(dr["CreateDate"]); if (dr["UpdateDate"] != DBNull.Value) pU_SMain.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); if (dr["DeleteDate"] != DBNull.Value) pU_SMain.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); if (dr["AuditStat"] != DBNull.Value) pU_SMain.AuditStat = Convert.ToString(dr["AuditStat"]); if (dr["AuditCurAudit"] != DBNull.Value) pU_SMain.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]); ret.Add(pU_SMain); } }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> /// 获取指定的PU_SMain对象(即:一条记录 /// </summary> public PU_SMain GetByKey(decimal pUS_ID) { PU_SMain pU_SMain = new PU_SMain(); string sql = "SELECT PUS_ID,PUS_Type,PUS_RCode,PUS_Company,PUS_CompanyName,PUS_Dept,PUS_MCode,PUS_MName,PUS_Owner,PUS_Num,PUS_Unit,PUS_Units,PUS_Stat,PUS_Spec,PUS_PDate,PUS_IDate,PUS_RDate,PUS_WOwner,PUS_BOwner,PUS_TranFee,PUS_Price,PUS_Sum,PUS_RefType,PUS_RefCode,PUS_SupType,PUS_UDef1,PUS_UDef2,PUS_UDef3,PUS_UDef4,PUS_UDef5,PUS_UDef6,PUS_UDef7,PUS_Remark,Stat,CreateDate,UpdateDate,DeleteDate,AuditStat,AuditCurAudit FROM PU_SMain WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND PUS_ID=@PUS_ID "; idb.AddParameter("@PUS_ID", pUS_ID); SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { if (dr["PUS_ID"] != DBNull.Value) pU_SMain.PUS_ID = Convert.ToDecimal(dr["PUS_ID"]); if (dr["PUS_Type"] != DBNull.Value) pU_SMain.PUS_Type = Convert.ToString(dr["PUS_Type"]); if (dr["PUS_RCode"] != DBNull.Value) pU_SMain.PUS_RCode = Convert.ToString(dr["PUS_RCode"]); if (dr["PUS_Company"] != DBNull.Value) pU_SMain.PUS_Company = Convert.ToString(dr["PUS_Company"]); if (dr["PUS_CompanyName"] != DBNull.Value) pU_SMain.PUS_CompanyName = Convert.ToString(dr["PUS_CompanyName"]); if (dr["PUS_Dept"] != DBNull.Value) pU_SMain.PUS_Dept = Convert.ToString(dr["PUS_Dept"]); if (dr["PUS_MCode"] != DBNull.Value) pU_SMain.PUS_MCode = Convert.ToString(dr["PUS_MCode"]); if (dr["PUS_MName"] != DBNull.Value) pU_SMain.PUS_MName = Convert.ToString(dr["PUS_MName"]); if (dr["PUS_Owner"] != DBNull.Value) pU_SMain.PUS_Owner = Convert.ToString(dr["PUS_Owner"]); if (dr["PUS_Num"] != DBNull.Value) pU_SMain.PUS_Num = Convert.ToDecimal(dr["PUS_Num"]); if (dr["PUS_Unit"] != DBNull.Value) pU_SMain.PUS_Unit = Convert.ToString(dr["PUS_Unit"]); if (dr["PUS_Units"] != DBNull.Value) pU_SMain.PUS_Units = Convert.ToString(dr["PUS_Units"]); if (dr["PUS_Stat"] != DBNull.Value) pU_SMain.PUS_Stat = Convert.ToString(dr["PUS_Stat"]); if (dr["PUS_Spec"] != DBNull.Value) pU_SMain.PUS_Spec = Convert.ToString(dr["PUS_Spec"]); if (dr["PUS_PDate"] != DBNull.Value) pU_SMain.PUS_PDate = Convert.ToDateTime(dr["PUS_PDate"]); if (dr["PUS_IDate"] != DBNull.Value) pU_SMain.PUS_IDate = Convert.ToDateTime(dr["PUS_IDate"]); if (dr["PUS_RDate"] != DBNull.Value) pU_SMain.PUS_RDate = Convert.ToDateTime(dr["PUS_RDate"]); if (dr["PUS_WOwner"] != DBNull.Value) pU_SMain.PUS_WOwner = Convert.ToString(dr["PUS_WOwner"]); if (dr["PUS_BOwner"] != DBNull.Value) pU_SMain.PUS_BOwner = Convert.ToString(dr["PUS_BOwner"]); if (dr["PUS_TranFee"] != DBNull.Value) pU_SMain.PUS_TranFee = Convert.ToDecimal(dr["PUS_TranFee"]); if (dr["PUS_Price"] != DBNull.Value) pU_SMain.PUS_Price = Convert.ToDecimal(dr["PUS_Price"]); if (dr["PUS_Sum"] != DBNull.Value) pU_SMain.PUS_Sum = Convert.ToDecimal(dr["PUS_Sum"]); if (dr["PUS_RefType"] != DBNull.Value) pU_SMain.PUS_RefType = Convert.ToString(dr["PUS_RefType"]); if (dr["PUS_RefCode"] != DBNull.Value) pU_SMain.PUS_RefCode = Convert.ToString(dr["PUS_RefCode"]); if (dr["PUS_SupType"] != DBNull.Value) pU_SMain.PUS_SupType = Convert.ToString(dr["PUS_SupType"]); if (dr["PUS_UDef1"] != DBNull.Value) pU_SMain.PUS_UDef1 = Convert.ToString(dr["PUS_UDef1"]); if (dr["PUS_UDef2"] != DBNull.Value) pU_SMain.PUS_UDef2 = Convert.ToString(dr["PUS_UDef2"]); if (dr["PUS_UDef3"] != DBNull.Value) pU_SMain.PUS_UDef3 = Convert.ToString(dr["PUS_UDef3"]); if (dr["PUS_UDef4"] != DBNull.Value) pU_SMain.PUS_UDef4 = Convert.ToString(dr["PUS_UDef4"]); if (dr["PUS_UDef5"] != DBNull.Value) pU_SMain.PUS_UDef5 = Convert.ToString(dr["PUS_UDef5"]); if (dr["PUS_UDef6"] != DBNull.Value) pU_SMain.PUS_UDef6 = Convert.ToString(dr["PUS_UDef6"]); if (dr["PUS_UDef7"] != DBNull.Value) pU_SMain.PUS_UDef7 = Convert.ToString(dr["PUS_UDef7"]); if (dr["PUS_Remark"] != DBNull.Value) pU_SMain.PUS_Remark = Convert.ToString(dr["PUS_Remark"]); if (dr["Stat"] != DBNull.Value) pU_SMain.Stat = Convert.ToInt32(dr["Stat"]); if (dr["CreateDate"] != DBNull.Value) pU_SMain.CreateDate = Convert.ToDateTime(dr["CreateDate"]); if (dr["UpdateDate"] != DBNull.Value) pU_SMain.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); if (dr["DeleteDate"] != DBNull.Value) pU_SMain.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); if (dr["AuditStat"] != DBNull.Value) pU_SMain.AuditStat = Convert.ToString(dr["AuditStat"]); if (dr["AuditCurAudit"] != DBNull.Value) pU_SMain.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]); } }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_SMain; }
/// <summary> /// 添加PU_SMain对象(即:一条记录) /// </summary> public object AddWithReturn(PU_SMain pU_SMain) { string sql = "INSERT INTO PU_SMain (PUS_Type,PUS_RCode,PUS_Company,PUS_CompanyName,PUS_Dept,PUS_MCode,PUS_MName,PUS_Owner,PUS_Num,PUS_Unit,PUS_Units,PUS_Stat,PUS_Spec,PUS_PDate,PUS_IDate,PUS_RDate,PUS_WOwner,PUS_BOwner,PUS_TranFee,PUS_Price,PUS_Sum,PUS_RefType,PUS_RefCode,PUS_SupType,PUS_UDef1,PUS_UDef2,PUS_UDef3,PUS_UDef4,PUS_UDef5,PUS_UDef6,PUS_UDef7,PUS_Remark,Stat,CreateDate,UpdateDate,DeleteDate,AuditStat,AuditCurAudit) VALUES (@PUS_Type,@PUS_RCode,@PUS_Company,@PUS_CompanyName,@PUS_Dept,@PUS_MCode,@PUS_MName,@PUS_Owner,@PUS_Num,@PUS_Unit,@PUS_Units,@PUS_Stat,@PUS_Spec,@PUS_PDate,@PUS_IDate,@PUS_RDate,@PUS_WOwner,@PUS_BOwner,@PUS_TranFee,@PUS_Price,@PUS_Sum,@PUS_RefType,@PUS_RefCode,@PUS_SupType,@PUS_UDef1,@PUS_UDef2,@PUS_UDef3,@PUS_UDef4,@PUS_UDef5,@PUS_UDef6,@PUS_UDef7,@PUS_Remark,@Stat,@CreateDate,@UpdateDate,@DeleteDate,@AuditStat,@AuditCurAudit);SELECT @@IDENTITY AS ReturnID;"; if (string.IsNullOrEmpty(pU_SMain.PUS_Type)) { idb.AddParameter("@PUS_Type", DBNull.Value); } else { idb.AddParameter("@PUS_Type", pU_SMain.PUS_Type); } if (string.IsNullOrEmpty(pU_SMain.PUS_RCode)) { idb.AddParameter("@PUS_RCode", DBNull.Value); } else { idb.AddParameter("@PUS_RCode", pU_SMain.PUS_RCode); } if (string.IsNullOrEmpty(pU_SMain.PUS_Company)) { idb.AddParameter("@PUS_Company", DBNull.Value); } else { idb.AddParameter("@PUS_Company", pU_SMain.PUS_Company); } if (string.IsNullOrEmpty(pU_SMain.PUS_CompanyName)) { idb.AddParameter("@PUS_CompanyName", DBNull.Value); } else { idb.AddParameter("@PUS_CompanyName", pU_SMain.PUS_CompanyName); } if (string.IsNullOrEmpty(pU_SMain.PUS_Dept)) { idb.AddParameter("@PUS_Dept", DBNull.Value); } else { idb.AddParameter("@PUS_Dept", pU_SMain.PUS_Dept); } if (string.IsNullOrEmpty(pU_SMain.PUS_MCode)) { idb.AddParameter("@PUS_MCode", DBNull.Value); } else { idb.AddParameter("@PUS_MCode", pU_SMain.PUS_MCode); } if (string.IsNullOrEmpty(pU_SMain.PUS_MName)) { idb.AddParameter("@PUS_MName", DBNull.Value); } else { idb.AddParameter("@PUS_MName", pU_SMain.PUS_MName); } if (string.IsNullOrEmpty(pU_SMain.PUS_Owner)) { idb.AddParameter("@PUS_Owner", DBNull.Value); } else { idb.AddParameter("@PUS_Owner", pU_SMain.PUS_Owner); } if (pU_SMain.PUS_Num == 0) { idb.AddParameter("@PUS_Num", 0); } else { idb.AddParameter("@PUS_Num", pU_SMain.PUS_Num); } if (string.IsNullOrEmpty(pU_SMain.PUS_Unit)) { idb.AddParameter("@PUS_Unit", DBNull.Value); } else { idb.AddParameter("@PUS_Unit", pU_SMain.PUS_Unit); } if (string.IsNullOrEmpty(pU_SMain.PUS_Units)) { idb.AddParameter("@PUS_Units", DBNull.Value); } else { idb.AddParameter("@PUS_Units", pU_SMain.PUS_Units); } if (string.IsNullOrEmpty(pU_SMain.PUS_Stat)) { idb.AddParameter("@PUS_Stat", DBNull.Value); } else { idb.AddParameter("@PUS_Stat", pU_SMain.PUS_Stat); } if (string.IsNullOrEmpty(pU_SMain.PUS_Spec)) { idb.AddParameter("@PUS_Spec", DBNull.Value); } else { idb.AddParameter("@PUS_Spec", pU_SMain.PUS_Spec); } if (pU_SMain.PUS_PDate == DateTime.MinValue) { idb.AddParameter("@PUS_PDate", DBNull.Value); } else { idb.AddParameter("@PUS_PDate", pU_SMain.PUS_PDate); } if (pU_SMain.PUS_IDate == DateTime.MinValue) { idb.AddParameter("@PUS_IDate", DBNull.Value); } else { idb.AddParameter("@PUS_IDate", pU_SMain.PUS_IDate); } if (pU_SMain.PUS_RDate == DateTime.MinValue) { idb.AddParameter("@PUS_RDate", DBNull.Value); } else { idb.AddParameter("@PUS_RDate", pU_SMain.PUS_RDate); } if (string.IsNullOrEmpty(pU_SMain.PUS_WOwner)) { idb.AddParameter("@PUS_WOwner", DBNull.Value); } else { idb.AddParameter("@PUS_WOwner", pU_SMain.PUS_WOwner); } if (string.IsNullOrEmpty(pU_SMain.PUS_BOwner)) { idb.AddParameter("@PUS_BOwner", DBNull.Value); } else { idb.AddParameter("@PUS_BOwner", pU_SMain.PUS_BOwner); } if (pU_SMain.PUS_TranFee == 0) { idb.AddParameter("@PUS_TranFee", 0); } else { idb.AddParameter("@PUS_TranFee", pU_SMain.PUS_TranFee); } if (pU_SMain.PUS_Price == 0) { idb.AddParameter("@PUS_Price", 0); } else { idb.AddParameter("@PUS_Price", pU_SMain.PUS_Price); } if (pU_SMain.PUS_Sum == 0) { idb.AddParameter("@PUS_Sum", 0); } else { idb.AddParameter("@PUS_Sum", pU_SMain.PUS_Sum); } if (string.IsNullOrEmpty(pU_SMain.PUS_RefType)) { idb.AddParameter("@PUS_RefType", DBNull.Value); } else { idb.AddParameter("@PUS_RefType", pU_SMain.PUS_RefType); } if (string.IsNullOrEmpty(pU_SMain.PUS_RefCode)) { idb.AddParameter("@PUS_RefCode", DBNull.Value); } else { idb.AddParameter("@PUS_RefCode", pU_SMain.PUS_RefCode); } if (string.IsNullOrEmpty(pU_SMain.PUS_SupType)) { idb.AddParameter("@PUS_SupType", DBNull.Value); } else { idb.AddParameter("@PUS_SupType", pU_SMain.PUS_SupType); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef1)) { idb.AddParameter("@PUS_UDef1", DBNull.Value); } else { idb.AddParameter("@PUS_UDef1", pU_SMain.PUS_UDef1); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef2)) { idb.AddParameter("@PUS_UDef2", DBNull.Value); } else { idb.AddParameter("@PUS_UDef2", pU_SMain.PUS_UDef2); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef3)) { idb.AddParameter("@PUS_UDef3", DBNull.Value); } else { idb.AddParameter("@PUS_UDef3", pU_SMain.PUS_UDef3); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef4)) { idb.AddParameter("@PUS_UDef4", DBNull.Value); } else { idb.AddParameter("@PUS_UDef4", pU_SMain.PUS_UDef4); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef5)) { idb.AddParameter("@PUS_UDef5", DBNull.Value); } else { idb.AddParameter("@PUS_UDef5", pU_SMain.PUS_UDef5); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef6)) { idb.AddParameter("@PUS_UDef6", DBNull.Value); } else { idb.AddParameter("@PUS_UDef6", pU_SMain.PUS_UDef6); } if (string.IsNullOrEmpty(pU_SMain.PUS_UDef7)) { idb.AddParameter("@PUS_UDef7", DBNull.Value); } else { idb.AddParameter("@PUS_UDef7", pU_SMain.PUS_UDef7); } if (string.IsNullOrEmpty(pU_SMain.PUS_Remark)) { idb.AddParameter("@PUS_Remark", DBNull.Value); } else { idb.AddParameter("@PUS_Remark", pU_SMain.PUS_Remark); } if (pU_SMain.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", pU_SMain.Stat); } if (pU_SMain.CreateDate == DateTime.MinValue) { idb.AddParameter("@CreateDate", DBNull.Value); } else { idb.AddParameter("@CreateDate", pU_SMain.CreateDate); } if (pU_SMain.UpdateDate == DateTime.MinValue) { idb.AddParameter("@UpdateDate", DBNull.Value); } else { idb.AddParameter("@UpdateDate", pU_SMain.UpdateDate); } if (pU_SMain.DeleteDate == DateTime.MinValue) { idb.AddParameter("@DeleteDate", DBNull.Value); } else { idb.AddParameter("@DeleteDate", pU_SMain.DeleteDate); } if (string.IsNullOrEmpty(pU_SMain.AuditStat)) { idb.AddParameter("@AuditStat", DBNull.Value); } else { idb.AddParameter("@AuditStat", pU_SMain.AuditStat); } if (string.IsNullOrEmpty(pU_SMain.AuditCurAudit)) { idb.AddParameter("@AuditCurAudit", DBNull.Value); } else { idb.AddParameter("@AuditCurAudit", pU_SMain.AuditCurAudit); } 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; }