public ActionResult Edit_DB_Classify() { this.Response.ContentType = "text/plain"; string classify_num = this.Request.QueryString["Num"]; NModel.DB_Classify model = new NModel.DB_Classify(); BLL.DB_Classify dal = new BLL.DB_Classify(); String JsonStr = ""; bool isGet = Tool.NStr.PostForSetVal <NModel.DB_Classify>(ref model, ref JsonStr, ""); model.Classify_Num = classify_num; // 下面代码编写 if (isGet && model.Classify_AddTime != null && !string.IsNullOrEmpty(model.Classify_Name) && !string.IsNullOrEmpty(model.Classify_Num) && model.Classify_ID > 0 ) { //取默认值 model.Classify_EditTime = DateTime.Parse(DateTime.Now.ToString("s")); bool isEdit = dal.EditFree(model, string.Format(" 'Classify_ID={0}'", model.Classify_ID)) > 0 ? true : false; string msg = dal.ErrorMsg; if (!string.IsNullOrEmpty(msg)) { msg = "原因:" + msg; } if (isEdit) { this.Response.Write(Tool.NMsg.SetMsg("修改成功", "1")); this.Response.End(); } else { this.Response.Write(Tool.NMsg.SetMsg("修改失败" + msg, "0")); this.Response.End(); } dal.Close(); } else { this.Response.Write(Tool.NMsg.SetMsg("提交失败", "0")); this.Response.End(); } dal.Close(); return(View()); }
public ActionResult Add_DB_Classify() { byte bLevel = 0; this.Response.ContentType = "text/plain"; string level = "0"; //this.Request.Form["level"];//0顶级1下一级 string classify_num = this.Request.QueryString["Num"]; NModel.DB_Classify model = new NModel.DB_Classify(); BLL.DB_Classify dal = new BLL.DB_Classify(); dal.Open(); String JsonStr = ""; bool isGet = Tool.NStr.PostForSetVal <NModel.DB_Classify>(ref model, ref JsonStr, ""); model.Classify_Num = classify_num; if (model.Classify_X == null || model.Classify_X <= 0 && model.Classify_Y <= 0 && model.Classify_Z <= 0) { model.Classify_X = 1; model.Classify_Y = 1; model.Classify_Z = 1; } else { level = "1"; model.Classify_Z = model.Classify_Z - 1; } byte.TryParse(level, out bLevel); // 下面代码编写 if (isGet && model != null && !string.IsNullOrEmpty(model.Classify_Name) && !string.IsNullOrEmpty(model.Classify_Num) && model.Classify_X != null && model.Classify_X > 0 && model.Classify_Y > 0 && model.Classify_Z > 0 ) { string Xstr = (model.Classify_X + ""); long xOutLong = 0; long? zOutLong = 0; long yOutLong = 0; long? xLong = 0; DataTable dtMax = null; if (bLevel == 0) { if (model.Classify_Y == 1 && model.Classify_Z == 1) { dtMax = dal.GetFristLevelMaxXModel(); if (dtMax != null && dtMax.Rows.Count > 0) { long.TryParse(dtMax.Rows[0]["next_x"] + "", out xOutLong); model.Classify_X = xOutLong; } else { xOutLong = 1; yOutLong = 1; zOutLong = 1; } } else if (model.Classify_Z >= 2) { NModel.DB_Classify nadm = dal.GetMaxXANDZYModel(model.Classify_X, model.Classify_Z); model.Classify_Y = (long)(nadm.Classify_Y + 1); } } else if (bLevel == 1) { string xStr = (model.Classify_X + ""); xStr = xStr.Replace("-", ""); long eqStr = 0; if (model.Classify_Z >= 2) { long.TryParse(string.Format("{0}{1}", xStr, model.Classify_Y), out eqStr); } else { long.TryParse(xStr + "", out eqStr); } dtMax = dal.GetXMaxYModel(eqStr); if (dtMax != null && dtMax.Rows.Count > 0) { long.TryParse(dtMax.Rows[0]["next_y"] + "", out yOutLong); } else { yOutLong = 1; } xOutLong = eqStr; zOutLong = model.Classify_Z + 1; model.Classify_X = xOutLong; model.Classify_Y = yOutLong > 0 ? yOutLong : 1; model.Classify_Z = zOutLong; } else { this.Response.Write(Tool.NMsg.SetMsg("请选择加级", "0")); return(View()); } model.Classify_AddTime = DateTime.Parse(DateTime.Now.ToString("s")); ; model.Classify_EditTime = DateTime.Parse(DateTime.Now.ToString("s")); ; long isAdd = dal.AddFree(model); if (isAdd > 0) { this.Response.Write(Tool.NMsg.SetMsg("增加成功", "1")); } else { this.Response.Write(Tool.NMsg.SetMsg("增加失败", "0")); } dal.Close(); } else { this.Response.Write(Tool.NMsg.SetMsg("提交失败/填写数据不完整", "0")); this.Response.End(); } dal.Close(); return(View()); }