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