/// <summary> /// 得到一个对象实体 /// </summary> public Models.m_return_fee_rule GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,USER_ID,AREA_ID,NUMBER,TIME_START,TIME_END,STATUS,DAYS,FEE_MEN,FEE_WOMEN,COMMENTS,CREATE_USER_ID,CREATE_DATETIME,UPDATE_USER_ID,UPDATE_DATETIME,DELETE_FLG from m_return_fee_rule "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16) }; parameters[0].Value = ID; Models.m_return_fee_rule model = new Models.m_return_fee_rule(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Models.m_return_fee_rule DataRowToModel(DataRow row) { Models.m_return_fee_rule model = new Models.m_return_fee_rule(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["USER_ID"] != null && row["USER_ID"].ToString() != "") { model.USER_ID = new Guid(row["USER_ID"].ToString()); } if (row["AREA_ID"] != null && row["AREA_ID"].ToString() != "") { model.AREA_ID = new Guid(row["AREA_ID"].ToString()); } if (row["NUMBER"] != null && row["NUMBER"].ToString() != "") { model.NUMBER = int.Parse(row["NUMBER"].ToString()); } if (row["TIME_START"] != null && row["TIME_START"].ToString() != "") { model.TIME_START = DateTime.Parse(row["TIME_START"].ToString()); } if (row["TIME_END"] != null && row["TIME_END"].ToString() != "") { model.TIME_END = DateTime.Parse(row["TIME_END"].ToString()); } if (row["STATUS"] != null && row["STATUS"].ToString() != "") { model.STATUS = int.Parse(row["STATUS"].ToString()); } if (row["DAYS"] != null && row["DAYS"].ToString() != "") { model.DAYS = int.Parse(row["DAYS"].ToString()); } if (row["FEE_MEN"] != null && row["FEE_MEN"].ToString() != "") { model.FEE_MEN = decimal.Parse(row["FEE_MEN"].ToString()); } if (row["FEE_WOMEN"] != null && row["FEE_WOMEN"].ToString() != "") { model.FEE_WOMEN = decimal.Parse(row["FEE_WOMEN"].ToString()); } if (row["COMMENTS"] != null) { model.COMMENTS = row["COMMENTS"].ToString(); } if (row["CREATE_USER_ID"] != null && row["CREATE_USER_ID"].ToString() != "") { model.CREATE_USER_ID = new Guid(row["CREATE_USER_ID"].ToString()); } if (row["CREATE_DATETIME"] != null && row["CREATE_DATETIME"].ToString() != "") { model.CREATE_DATETIME = DateTime.Parse(row["CREATE_DATETIME"].ToString()); } if (row["UPDATE_USER_ID"] != null && row["UPDATE_USER_ID"].ToString() != "") { model.UPDATE_USER_ID = new Guid(row["UPDATE_USER_ID"].ToString()); } if (row["UPDATE_DATETIME"] != null && row["UPDATE_DATETIME"].ToString() != "") { model.UPDATE_DATETIME = DateTime.Parse(row["UPDATE_DATETIME"].ToString()); } if (row["DELETE_FLG"] != null) { model.DELETE_FLG = row["DELETE_FLG"].ToString(); } } return model; }
public ActionResult Setting(string areaSave, string companySave, FormCollection collection) { areaSave = HttpUtility.UrlDecode(areaSave); companySave = HttpUtility.UrlDecode(companySave); Models.z_user session_model_z_user = (Models.z_user)ViewBag.model_z_user; DAL.m_return_fee_rule dal_m_return_fee_rule = new DAL.m_return_fee_rule(); dal_m_return_fee_rule.DeleteByUserId(new Guid(companySave), new Guid(areaSave)); for (int i = 1; i < 7; i++) { try { Models.m_return_fee_rule model_m_return_fee_rule = new Models.m_return_fee_rule(); model_m_return_fee_rule.ID = Guid.NewGuid(); model_m_return_fee_rule.USER_ID = new Guid(companySave); model_m_return_fee_rule.AREA_ID = new Guid(areaSave); model_m_return_fee_rule.NUMBER = i; model_m_return_fee_rule.TIME_START = DateTime.Parse(collection["DATE_FROM" + i].Trim()); model_m_return_fee_rule.TIME_END = DateTime.Parse(collection["DATE_TO" + i].Trim()); model_m_return_fee_rule.STATUS = int.Parse(collection["STATUS" + i].Trim()); model_m_return_fee_rule.DAYS = int.Parse(collection["DAY" + i].Trim()); model_m_return_fee_rule.FEE_MEN = decimal.Parse(collection["MEN" + i].Trim()); model_m_return_fee_rule.FEE_WOMEN = decimal.Parse(collection["WOMEN" + i].Trim()); model_m_return_fee_rule.COMMENTS = ""; model_m_return_fee_rule.CREATE_USER_ID = session_model_z_user.ID; model_m_return_fee_rule.CREATE_DATETIME = DateTime.Now; model_m_return_fee_rule.UPDATE_USER_ID = session_model_z_user.ID; model_m_return_fee_rule.UPDATE_DATETIME = DateTime.Now; model_m_return_fee_rule.DELETE_FLG = "0"; dal_m_return_fee_rule.Add(model_m_return_fee_rule); } catch { } } ViewBag.message = "保存成功"; DAL.z_parameter dal_z_parameter = new DAL.z_parameter(); List<Models.z_parameter> area_list = dal_z_parameter.GetModelList("地区"); List<Models.z_parameter> company_list = dal_z_parameter.GetModelList("分公司"); ViewBag.area_list = area_list; ViewBag.company_list = company_list; if (areaSave == null || areaSave == "") { areaSave = area_list[0].ID.ToString(); } if (companySave == null || companySave == "") { companySave = company_list[0].ID.ToString(); } ViewBag.area = areaSave; ViewBag.company = companySave; List<Models.m_return_fee_rule> m_list = dal_m_return_fee_rule.GetListModel(new Guid(companySave), new Guid(areaSave)); return View(m_list); }