private Entities.QS_RulesRange LoadSingleQS_RulesRange(DataRow row) { Entities.QS_RulesRange model = new Entities.QS_RulesRange(); if (row["RecID"].ToString() != "") { model.RecID = int.Parse(row["RecID"].ToString()); } if (row["QS_RTID"].ToString() != "") { model.QS_RTID = int.Parse(row["QS_RTID"].ToString()); } if (row["QS_IM_RTID"].ToString() != "") { model.QS_IM_RTID = int.Parse(row["QS_IM_RTID"].ToString()); } if (row["BGID"].ToString() != "") { model.BGID = int.Parse(row["BGID"].ToString()); } if (row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } return(model); }
public Entities.QS_RulesRange getModelByBGID(int BGID) { Entities.QS_RulesRange model = null; string sqlStr = "select * from QS_RulesRange where BGID=" + BGID; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.Text, sqlStr); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { model = LoadSingleQS_RulesRange(ds.Tables[0].Rows[0]); } } return(model); }
/// 编辑应用范围 /// <summary> /// 编辑应用范围 /// </summary> /// <param name="msg"></param> private void RangeManage(out string msg) { msg = string.Empty; try { int bgid = CommonFunction.ObjectToInteger(BGID, -1); int qs_rtid = CommonFunction.ObjectToInteger(QS_RTID, -1); int qs_im_rtid = CommonFunction.ObjectToInteger(QS_IM_RTID, -1); Entities.QS_RulesRange old_Model = BLL.QS_RulesRange.Instance.getModelByBGID(bgid); BLL.QS_RulesRange.Instance.RangeManage(bgid, qs_rtid, qs_im_rtid); Entities.QS_RulesRange new_Model = BLL.QS_RulesRange.Instance.getModelByBGID(bgid); insertLog(old_Model, new_Model); msg = "{result:'ok',msg:''}"; } catch (Exception ex) { msg = "{result:'error',msg:'" + ex.Message + "'}"; } }