/// <summary> /// 获得数据列表 /// </summary> public List<Model.VipRank> DataTableToList(DataTable dt) { List<Model.VipRank> modelList = new List<Model.VipRank>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.VipRank model; for (int n = 0; n < rowsCount; n++) { model = new Model.VipRank(); if (dt.Rows[n]["r_ID"] != null && dt.Rows[n]["r_ID"].ToString() != "") { model.r_ID = int.Parse(dt.Rows[n]["r_ID"].ToString()); } if (dt.Rows[n]["r_Name"] != null && dt.Rows[n]["r_Name"].ToString() != "") { model.r_Name = dt.Rows[n]["r_Name"].ToString(); } if (dt.Rows[n]["r_ZheK"] != null && dt.Rows[n]["r_ZheK"].ToString() != "") { model.r_ZheK = decimal.Parse(dt.Rows[n]["r_ZheK"].ToString()); } if (dt.Rows[n]["r_Score"] != null && dt.Rows[n]["r_Score"].ToString() != "") { model.r_Score = int.Parse(dt.Rows[n]["r_Score"].ToString()); } if (dt.Rows[n]["r_Status"] != null && dt.Rows[n]["r_Status"].ToString() != "") { model.r_Status = int.Parse(dt.Rows[n]["r_Status"].ToString()); } if (dt.Rows[n]["r_Rank"] != null && dt.Rows[n]["r_Rank"].ToString() != "") { model.r_Rank = int.Parse(dt.Rows[n]["r_Rank"].ToString()); } if (dt.Rows[n]["r_UpperScore"] != null && dt.Rows[n]["r_UpperScore"].ToString() != "") { model.r_UpperScore = int.Parse(dt.Rows[n]["r_UpperScore"].ToString()); } if (model != null) { modelList.Add(model); } } } return modelList; }
public ActionResult Add(Model.VipRank model) { bool result = false; bool ischongfu = false; Model.VipRank mb = new Model.VipRank(); List<Model.VipRank> listvip = viprankbll.GetModelList(" r_Status!=2"); for (int i = 0; i < listvip.Count; i++) { if (listvip[i].r_Rank == model.r_Rank) { ischongfu = true; } } try { if (ischongfu == false) { model.r_Status = 0; result = viprankbll.Add(model) > 0 ? true : false; if (result) { return Content(DWZUtil.GetResultJson("200", "操作成功!!", "w_会员等级管理", "", "closeCurrent")); } else { return Content(DWZUtil.GetResultJson("300", "保存失败!!", "", "", "")); } } else { return Content(DWZUtil.GetResultJson("300", "保存失败,会员等级已存在!!", "", "", "")); } } catch { return Content(DWZUtil.GetResultJson("300", "保存失败!!", "", "", "")); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.VipRank DataRowToModel(DataRow row) { Model.VipRank model = new Model.VipRank(); if (row != null) { if (row["r_ID"] != null && row["r_ID"].ToString() != "") { model.r_ID = int.Parse(row["r_ID"].ToString()); } if (row["r_Name"] != null) { model.r_Name = row["r_Name"].ToString(); } if (row["r_ZheK"] != null && row["r_ZheK"].ToString() != "") { model.r_ZheK = decimal.Parse(row["r_ZheK"].ToString()); } if (row["r_Score"] != null && row["r_Score"].ToString() != "") { model.r_Score = int.Parse(row["r_Score"].ToString()); } if (row["r_Status"] != null && row["r_Status"].ToString() != "") { model.r_Status = int.Parse(row["r_Status"].ToString()); } if (row["r_Rank"] != null && row["r_Rank"].ToString() != "") { model.r_Rank = int.Parse(row["r_Rank"].ToString()); } if (row["r_UpperScore"] != null && row["r_UpperScore"].ToString() != "") { model.r_UpperScore = int.Parse(row["r_UpperScore"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.VipRank GetModel(int r_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 r_ID,r_Name,r_ZheK,r_Score,r_Status,r_Rank,r_UpperScore from VipRank "); strSql.Append(" where r_ID=@r_ID"); SqlParameter[] parameters = { new SqlParameter("@r_ID", SqlDbType.Int,4) }; parameters[0].Value = r_ID; Model.VipRank model = new Model.VipRank(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }