/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public BSE_Activities GetModel(string strCondition) { List<BSE_Activities> list = instance.GetListByWhere(strCondition); BSE_Activities model = new BSE_Activities(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return model; }
/// <summary> /// 更新活动情况 BSE_Activities对象(即:一条记录 /// </summary> public int Update(BSE_Activities bSE_Activities) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE BSE_Activities SET "); if(bSE_Activities.BAA_Code_IsChanged){sbParameter.Append("BAA_Code=@BAA_Code, ");} if(bSE_Activities.BAA_Type_IsChanged){sbParameter.Append("BAA_Type=@BAA_Type, ");} if(bSE_Activities.BAA_Category_IsChanged){sbParameter.Append("BAA_Category=@BAA_Category, ");} if(bSE_Activities.BAA_CName_IsChanged){sbParameter.Append("BAA_CName=@BAA_CName, ");} if(bSE_Activities.BAA_CCode_IsChanged){sbParameter.Append("BAA_CCode=@BAA_CCode, ");} if(bSE_Activities.BAA_Owner_IsChanged){sbParameter.Append("BAA_Owner=@BAA_Owner, ");} if(bSE_Activities.BAA_Member_IsChanged){sbParameter.Append("BAA_Member=@BAA_Member, ");} if(bSE_Activities.BAA_Contract_IsChanged){sbParameter.Append("BAA_Contract=@BAA_Contract, ");} if(bSE_Activities.BAA_Tel_IsChanged){sbParameter.Append("BAA_Tel=@BAA_Tel, ");} if(bSE_Activities.BAA_Begin_IsChanged){sbParameter.Append("BAA_Begin=@BAA_Begin, ");} if(bSE_Activities.BAA_End_IsChanged){sbParameter.Append("BAA_End=@BAA_End, ");} if(bSE_Activities.BAA_Period_IsChanged){sbParameter.Append("BAA_Period=@BAA_Period, ");} if(bSE_Activities.BAA_Priority_IsChanged){sbParameter.Append("BAA_Priority=@BAA_Priority, ");} if(bSE_Activities.BAA_Addr_IsChanged){sbParameter.Append("BAA_Addr=@BAA_Addr, ");} if(bSE_Activities.BAA_Reminder_IsChanged){sbParameter.Append("BAA_Reminder=@BAA_Reminder, ");} if(bSE_Activities.BAA_Content_IsChanged){sbParameter.Append("BAA_Content=@BAA_Content, ");} if(bSE_Activities.BAA_Stat_IsChanged){sbParameter.Append("BAA_Stat=@BAA_Stat, ");} if(bSE_Activities.BAA_iType_IsChanged){sbParameter.Append("BAA_iType=@BAA_iType, ");} if(bSE_Activities.BAA_Remark_IsChanged){sbParameter.Append("BAA_Remark=@BAA_Remark, ");} if(bSE_Activities.BAA_RefType_IsChanged){sbParameter.Append("BAA_RefType=@BAA_RefType, ");} if(bSE_Activities.BAA_RefCode_IsChanged){sbParameter.Append("BAA_RefCode=@BAA_RefCode ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and BAA_ID=@BAA_ID; " ); string sql=sb.ToString(); if(bSE_Activities.BAA_Code_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Code)) { idb.AddParameter("@BAA_Code", DBNull.Value); } else { idb.AddParameter("@BAA_Code", bSE_Activities.BAA_Code); } } if(bSE_Activities.BAA_Type_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Type)) { idb.AddParameter("@BAA_Type", DBNull.Value); } else { idb.AddParameter("@BAA_Type", bSE_Activities.BAA_Type); } } if(bSE_Activities.BAA_Category_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Category)) { idb.AddParameter("@BAA_Category", DBNull.Value); } else { idb.AddParameter("@BAA_Category", bSE_Activities.BAA_Category); } } if(bSE_Activities.BAA_CName_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_CName)) { idb.AddParameter("@BAA_CName", DBNull.Value); } else { idb.AddParameter("@BAA_CName", bSE_Activities.BAA_CName); } } if(bSE_Activities.BAA_CCode_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_CCode)) { idb.AddParameter("@BAA_CCode", DBNull.Value); } else { idb.AddParameter("@BAA_CCode", bSE_Activities.BAA_CCode); } } if(bSE_Activities.BAA_Owner_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Owner)) { idb.AddParameter("@BAA_Owner", DBNull.Value); } else { idb.AddParameter("@BAA_Owner", bSE_Activities.BAA_Owner); } } if(bSE_Activities.BAA_Member_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Member)) { idb.AddParameter("@BAA_Member", DBNull.Value); } else { idb.AddParameter("@BAA_Member", bSE_Activities.BAA_Member); } } if(bSE_Activities.BAA_Contract_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Contract)) { idb.AddParameter("@BAA_Contract", DBNull.Value); } else { idb.AddParameter("@BAA_Contract", bSE_Activities.BAA_Contract); } } if(bSE_Activities.BAA_Tel_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Tel)) { idb.AddParameter("@BAA_Tel", DBNull.Value); } else { idb.AddParameter("@BAA_Tel", bSE_Activities.BAA_Tel); } } if(bSE_Activities.BAA_Begin_IsChanged) { if (bSE_Activities.BAA_Begin == DateTime.MinValue) { idb.AddParameter("@BAA_Begin", DBNull.Value); } else { idb.AddParameter("@BAA_Begin", bSE_Activities.BAA_Begin); } } if(bSE_Activities.BAA_End_IsChanged) { if (bSE_Activities.BAA_End == DateTime.MinValue) { idb.AddParameter("@BAA_End", DBNull.Value); } else { idb.AddParameter("@BAA_End", bSE_Activities.BAA_End); } } if(bSE_Activities.BAA_Period_IsChanged) { if (bSE_Activities.BAA_Period == 0) { idb.AddParameter("@BAA_Period", 0); } else { idb.AddParameter("@BAA_Period", bSE_Activities.BAA_Period); } } if(bSE_Activities.BAA_Priority_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Priority)) { idb.AddParameter("@BAA_Priority", DBNull.Value); } else { idb.AddParameter("@BAA_Priority", bSE_Activities.BAA_Priority); } } if(bSE_Activities.BAA_Addr_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Addr)) { idb.AddParameter("@BAA_Addr", DBNull.Value); } else { idb.AddParameter("@BAA_Addr", bSE_Activities.BAA_Addr); } } if(bSE_Activities.BAA_Reminder_IsChanged) { if (bSE_Activities.BAA_Reminder == DateTime.MinValue) { idb.AddParameter("@BAA_Reminder", DBNull.Value); } else { idb.AddParameter("@BAA_Reminder", bSE_Activities.BAA_Reminder); } } if(bSE_Activities.BAA_Content_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Content)) { idb.AddParameter("@BAA_Content", DBNull.Value); } else { idb.AddParameter("@BAA_Content", bSE_Activities.BAA_Content); } } if(bSE_Activities.BAA_Stat_IsChanged) { if (bSE_Activities.BAA_Stat == 0) { idb.AddParameter("@BAA_Stat", 0); } else { idb.AddParameter("@BAA_Stat", bSE_Activities.BAA_Stat); } } if(bSE_Activities.BAA_iType_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_iType)) { idb.AddParameter("@BAA_iType", DBNull.Value); } else { idb.AddParameter("@BAA_iType", bSE_Activities.BAA_iType); } } if(bSE_Activities.BAA_Remark_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_Remark)) { idb.AddParameter("@BAA_Remark", DBNull.Value); } else { idb.AddParameter("@BAA_Remark", bSE_Activities.BAA_Remark); } } if(bSE_Activities.BAA_RefType_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_RefType)) { idb.AddParameter("@BAA_RefType", DBNull.Value); } else { idb.AddParameter("@BAA_RefType", bSE_Activities.BAA_RefType); } } if(bSE_Activities.BAA_RefCode_IsChanged) { if (string.IsNullOrEmpty(bSE_Activities.BAA_RefCode)) { idb.AddParameter("@BAA_RefCode", DBNull.Value); } else { idb.AddParameter("@BAA_RefCode", bSE_Activities.BAA_RefCode); } } idb.AddParameter("@BAA_ID", bSE_Activities.BAA_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> /// 获取指定的活动情况 BSE_Activities对象集合 /// </summary> public List<BSE_Activities> GetListByWhere(string strCondition) { List<BSE_Activities> ret = new List<BSE_Activities>(); string sql = "SELECT BAA_ID,BAA_Code,BAA_Type,BAA_Category,BAA_CName,BAA_CCode,BAA_Owner,BAA_Member,BAA_Contract,BAA_Tel,BAA_Begin,BAA_End,BAA_Period,BAA_Priority,BAA_Addr,BAA_Reminder,BAA_Content,BAA_Stat,BAA_iType,BAA_Remark,BAA_RefType,BAA_RefCode FROM BSE_Activities 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()) { BSE_Activities bSE_Activities = new BSE_Activities(); if (dr["BAA_ID"] != DBNull.Value) bSE_Activities.BAA_ID = Convert.ToDecimal(dr["BAA_ID"]); if (dr["BAA_Code"] != DBNull.Value) bSE_Activities.BAA_Code = Convert.ToString(dr["BAA_Code"]); if (dr["BAA_Type"] != DBNull.Value) bSE_Activities.BAA_Type = Convert.ToString(dr["BAA_Type"]); if (dr["BAA_Category"] != DBNull.Value) bSE_Activities.BAA_Category = Convert.ToString(dr["BAA_Category"]); if (dr["BAA_CName"] != DBNull.Value) bSE_Activities.BAA_CName = Convert.ToString(dr["BAA_CName"]); if (dr["BAA_CCode"] != DBNull.Value) bSE_Activities.BAA_CCode = Convert.ToString(dr["BAA_CCode"]); if (dr["BAA_Owner"] != DBNull.Value) bSE_Activities.BAA_Owner = Convert.ToString(dr["BAA_Owner"]); if (dr["BAA_Member"] != DBNull.Value) bSE_Activities.BAA_Member = Convert.ToString(dr["BAA_Member"]); if (dr["BAA_Contract"] != DBNull.Value) bSE_Activities.BAA_Contract = Convert.ToString(dr["BAA_Contract"]); if (dr["BAA_Tel"] != DBNull.Value) bSE_Activities.BAA_Tel = Convert.ToString(dr["BAA_Tel"]); if (dr["BAA_Begin"] != DBNull.Value) bSE_Activities.BAA_Begin = Convert.ToDateTime(dr["BAA_Begin"]); if (dr["BAA_End"] != DBNull.Value) bSE_Activities.BAA_End = Convert.ToDateTime(dr["BAA_End"]); if (dr["BAA_Period"] != DBNull.Value) bSE_Activities.BAA_Period = Convert.ToInt32(dr["BAA_Period"]); if (dr["BAA_Priority"] != DBNull.Value) bSE_Activities.BAA_Priority = Convert.ToString(dr["BAA_Priority"]); if (dr["BAA_Addr"] != DBNull.Value) bSE_Activities.BAA_Addr = Convert.ToString(dr["BAA_Addr"]); if (dr["BAA_Reminder"] != DBNull.Value) bSE_Activities.BAA_Reminder = Convert.ToDateTime(dr["BAA_Reminder"]); if (dr["BAA_Content"] != DBNull.Value) bSE_Activities.BAA_Content = Convert.ToString(dr["BAA_Content"]); if (dr["BAA_Stat"] != DBNull.Value) bSE_Activities.BAA_Stat = Convert.ToInt32(dr["BAA_Stat"]); if (dr["BAA_iType"] != DBNull.Value) bSE_Activities.BAA_iType = Convert.ToString(dr["BAA_iType"]); if (dr["BAA_Remark"] != DBNull.Value) bSE_Activities.BAA_Remark = Convert.ToString(dr["BAA_Remark"]); if (dr["BAA_RefType"] != DBNull.Value) bSE_Activities.BAA_RefType = Convert.ToString(dr["BAA_RefType"]); if (dr["BAA_RefCode"] != DBNull.Value) bSE_Activities.BAA_RefCode = Convert.ToString(dr["BAA_RefCode"]); ret.Add(bSE_Activities); } }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> /// 获取指定的活动情况 BSE_Activities对象(即:一条记录 /// </summary> public BSE_Activities GetByKey(decimal bAA_ID) { BSE_Activities bSE_Activities = new BSE_Activities(); string sql = "SELECT BAA_ID,BAA_Code,BAA_Type,BAA_Category,BAA_CName,BAA_CCode,BAA_Owner,BAA_Member,BAA_Contract,BAA_Tel,BAA_Begin,BAA_End,BAA_Period,BAA_Priority,BAA_Addr,BAA_Reminder,BAA_Content,BAA_Stat,BAA_iType,BAA_Remark,BAA_RefType,BAA_RefCode FROM BSE_Activities WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND BAA_ID=@BAA_ID "; idb.AddParameter("@BAA_ID", bAA_ID); SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { if (dr["BAA_ID"] != DBNull.Value) bSE_Activities.BAA_ID = Convert.ToDecimal(dr["BAA_ID"]); if (dr["BAA_Code"] != DBNull.Value) bSE_Activities.BAA_Code = Convert.ToString(dr["BAA_Code"]); if (dr["BAA_Type"] != DBNull.Value) bSE_Activities.BAA_Type = Convert.ToString(dr["BAA_Type"]); if (dr["BAA_Category"] != DBNull.Value) bSE_Activities.BAA_Category = Convert.ToString(dr["BAA_Category"]); if (dr["BAA_CName"] != DBNull.Value) bSE_Activities.BAA_CName = Convert.ToString(dr["BAA_CName"]); if (dr["BAA_CCode"] != DBNull.Value) bSE_Activities.BAA_CCode = Convert.ToString(dr["BAA_CCode"]); if (dr["BAA_Owner"] != DBNull.Value) bSE_Activities.BAA_Owner = Convert.ToString(dr["BAA_Owner"]); if (dr["BAA_Member"] != DBNull.Value) bSE_Activities.BAA_Member = Convert.ToString(dr["BAA_Member"]); if (dr["BAA_Contract"] != DBNull.Value) bSE_Activities.BAA_Contract = Convert.ToString(dr["BAA_Contract"]); if (dr["BAA_Tel"] != DBNull.Value) bSE_Activities.BAA_Tel = Convert.ToString(dr["BAA_Tel"]); if (dr["BAA_Begin"] != DBNull.Value) bSE_Activities.BAA_Begin = Convert.ToDateTime(dr["BAA_Begin"]); if (dr["BAA_End"] != DBNull.Value) bSE_Activities.BAA_End = Convert.ToDateTime(dr["BAA_End"]); if (dr["BAA_Period"] != DBNull.Value) bSE_Activities.BAA_Period = Convert.ToInt32(dr["BAA_Period"]); if (dr["BAA_Priority"] != DBNull.Value) bSE_Activities.BAA_Priority = Convert.ToString(dr["BAA_Priority"]); if (dr["BAA_Addr"] != DBNull.Value) bSE_Activities.BAA_Addr = Convert.ToString(dr["BAA_Addr"]); if (dr["BAA_Reminder"] != DBNull.Value) bSE_Activities.BAA_Reminder = Convert.ToDateTime(dr["BAA_Reminder"]); if (dr["BAA_Content"] != DBNull.Value) bSE_Activities.BAA_Content = Convert.ToString(dr["BAA_Content"]); if (dr["BAA_Stat"] != DBNull.Value) bSE_Activities.BAA_Stat = Convert.ToInt32(dr["BAA_Stat"]); if (dr["BAA_iType"] != DBNull.Value) bSE_Activities.BAA_iType = Convert.ToString(dr["BAA_iType"]); if (dr["BAA_Remark"] != DBNull.Value) bSE_Activities.BAA_Remark = Convert.ToString(dr["BAA_Remark"]); if (dr["BAA_RefType"] != DBNull.Value) bSE_Activities.BAA_RefType = Convert.ToString(dr["BAA_RefType"]); if (dr["BAA_RefCode"] != DBNull.Value) bSE_Activities.BAA_RefCode = Convert.ToString(dr["BAA_RefCode"]); } }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 bSE_Activities; }
/// <summary> /// 添加活动情况 BSE_Activities对象(即:一条记录) /// </summary> public int Add(BSE_Activities bSE_Activities) { string sql = "INSERT INTO BSE_Activities (BAA_Code,BAA_Type,BAA_Category,BAA_CName,BAA_CCode,BAA_Owner,BAA_Member,BAA_Contract,BAA_Tel,BAA_Begin,BAA_End,BAA_Period,BAA_Priority,BAA_Addr,BAA_Reminder,BAA_Content,BAA_Stat,BAA_iType,BAA_Remark,BAA_RefType,BAA_RefCode) VALUES (@BAA_Code,@BAA_Type,@BAA_Category,@BAA_CName,@BAA_CCode,@BAA_Owner,@BAA_Member,@BAA_Contract,@BAA_Tel,@BAA_Begin,@BAA_End,@BAA_Period,@BAA_Priority,@BAA_Addr,@BAA_Reminder,@BAA_Content,@BAA_Stat,@BAA_iType,@BAA_Remark,@BAA_RefType,@BAA_RefCode)"; if (string.IsNullOrEmpty(bSE_Activities.BAA_Code)) { idb.AddParameter("@BAA_Code", DBNull.Value); } else { idb.AddParameter("@BAA_Code", bSE_Activities.BAA_Code); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Type)) { idb.AddParameter("@BAA_Type", DBNull.Value); } else { idb.AddParameter("@BAA_Type", bSE_Activities.BAA_Type); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Category)) { idb.AddParameter("@BAA_Category", DBNull.Value); } else { idb.AddParameter("@BAA_Category", bSE_Activities.BAA_Category); } if (string.IsNullOrEmpty(bSE_Activities.BAA_CName)) { idb.AddParameter("@BAA_CName", DBNull.Value); } else { idb.AddParameter("@BAA_CName", bSE_Activities.BAA_CName); } if (string.IsNullOrEmpty(bSE_Activities.BAA_CCode)) { idb.AddParameter("@BAA_CCode", DBNull.Value); } else { idb.AddParameter("@BAA_CCode", bSE_Activities.BAA_CCode); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Owner)) { idb.AddParameter("@BAA_Owner", DBNull.Value); } else { idb.AddParameter("@BAA_Owner", bSE_Activities.BAA_Owner); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Member)) { idb.AddParameter("@BAA_Member", DBNull.Value); } else { idb.AddParameter("@BAA_Member", bSE_Activities.BAA_Member); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Contract)) { idb.AddParameter("@BAA_Contract", DBNull.Value); } else { idb.AddParameter("@BAA_Contract", bSE_Activities.BAA_Contract); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Tel)) { idb.AddParameter("@BAA_Tel", DBNull.Value); } else { idb.AddParameter("@BAA_Tel", bSE_Activities.BAA_Tel); } if (bSE_Activities.BAA_Begin == DateTime.MinValue) { idb.AddParameter("@BAA_Begin", DBNull.Value); } else { idb.AddParameter("@BAA_Begin", bSE_Activities.BAA_Begin); } if (bSE_Activities.BAA_End == DateTime.MinValue) { idb.AddParameter("@BAA_End", DBNull.Value); } else { idb.AddParameter("@BAA_End", bSE_Activities.BAA_End); } if (bSE_Activities.BAA_Period == 0) { idb.AddParameter("@BAA_Period", 0); } else { idb.AddParameter("@BAA_Period", bSE_Activities.BAA_Period); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Priority)) { idb.AddParameter("@BAA_Priority", DBNull.Value); } else { idb.AddParameter("@BAA_Priority", bSE_Activities.BAA_Priority); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Addr)) { idb.AddParameter("@BAA_Addr", DBNull.Value); } else { idb.AddParameter("@BAA_Addr", bSE_Activities.BAA_Addr); } if (bSE_Activities.BAA_Reminder == DateTime.MinValue) { idb.AddParameter("@BAA_Reminder", DBNull.Value); } else { idb.AddParameter("@BAA_Reminder", bSE_Activities.BAA_Reminder); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Content)) { idb.AddParameter("@BAA_Content", DBNull.Value); } else { idb.AddParameter("@BAA_Content", bSE_Activities.BAA_Content); } if (bSE_Activities.BAA_Stat == 0) { idb.AddParameter("@BAA_Stat", 0); } else { idb.AddParameter("@BAA_Stat", bSE_Activities.BAA_Stat); } if (string.IsNullOrEmpty(bSE_Activities.BAA_iType)) { idb.AddParameter("@BAA_iType", DBNull.Value); } else { idb.AddParameter("@BAA_iType", bSE_Activities.BAA_iType); } if (string.IsNullOrEmpty(bSE_Activities.BAA_Remark)) { idb.AddParameter("@BAA_Remark", DBNull.Value); } else { idb.AddParameter("@BAA_Remark", bSE_Activities.BAA_Remark); } if (string.IsNullOrEmpty(bSE_Activities.BAA_RefType)) { idb.AddParameter("@BAA_RefType", DBNull.Value); } else { idb.AddParameter("@BAA_RefType", bSE_Activities.BAA_RefType); } if (string.IsNullOrEmpty(bSE_Activities.BAA_RefCode)) { idb.AddParameter("@BAA_RefCode", DBNull.Value); } else { idb.AddParameter("@BAA_RefCode", bSE_Activities.BAA_RefCode); } 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(BSE_Activities 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(BSE_Activities 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(BSE_Activities model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }