/// <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);
}
