/// <summary> /// 根据id取消审核一条信息 /// </summary> /// <param name="context"></param> private void CancelCheckById(HttpContext context) { #region 存储过程处理proc_K_U_CommonSet KingTop.Model.pageModel.Json j = new KingTop.Model.pageModel.Json(); SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4); returnValue.Direction = ParameterDirection.Output; string cmdText = "proc_K_U_CommonSet"; string tranType = "CANCELCHECK"; string IDList = Utils.CheckSql(context.Request.Params["id"]); string SetValue = "3"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@tranType", tranType), new SqlParameter("@IDList", IDList), new SqlParameter("@SetValue", SetValue), returnValue }; SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras); string isOk = returnValue.Value.ToString(); if (isOk == "1") { j.success = true; j.msg = "取消审核"; } #endregion JavaScriptSerializer js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(j)); context.Response.End(); }
/// <summary> /// 添加一条信息 /// </summary> /// <param name="context"></param> private void AddData(HttpContext context) { KingTop.Model.pageModel.Json j = new KingTop.Model.pageModel.Json(); KingTop.Model.Common.Common model = new KingTop.Model.Common.Common(); string[] arrIDOrders = KingTop.BLL.Public.GetTableID("0", "K_U_Common");//主键(ID)和排序数组 //添加 model.Id = arrIDOrders[0]; model.Title = context.Request.Params["Title"]; model.NodeCode = context.Request.Params["nodecode"]; model.UserName = context.Request.Params["UserName"]; model.BigImg = context.Request.Params["BigImg"]; model.FlowState = Utils.ParseInt(context.Request.Params["FlowState"], 3).ToString(); model.AddDate = Utils.GetDateTime(); model.Orders = Utils.ParseInt(context.Request.Params["Order"], 0); model.SiteID = this.SiteID; model.Detail = context.Request.Params["TxtDetail"]; StringBuilder builder = new StringBuilder(); builder.Append("insert into K_U_Common "); builder.Append("(Id,Title,NodeCode,UserName,BigImg,FlowState,AddDate,Orders,SiteID,Detail)"); builder.Append(" values "); builder.Append("(@Id,@Title,@NodeCode,@UserName,@BigImg,@FlowState,@AddDate,@Orders,@SiteID,@Detail)"); builder.Append(";select @@IDENTITY"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.VarChar), new SqlParameter("@Title", SqlDbType.NVarChar), new SqlParameter("@NodeCode", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@BigImg", SqlDbType.NVarChar), new SqlParameter("@FlowState", SqlDbType.Int), new SqlParameter("@AddDate", SqlDbType.NVarChar), new SqlParameter("@Orders", SqlDbType.Int), new SqlParameter("@SiteID", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.NVarChar) }; cmdParms[0].Value = model.Id; cmdParms[1].Value = model.Title; cmdParms[2].Value = model.NodeCode; cmdParms[3].Value = model.UserName; cmdParms[4].Value = model.BigImg; cmdParms[5].Value = model.FlowState; cmdParms[6].Value = model.AddDate; cmdParms[7].Value = model.Orders; cmdParms[8].Value = model.SiteID; cmdParms[9].Value = model.Detail; int isOk = SQLHelper.ExecuteCommand(builder.ToString(), CommandType.Text, cmdParms); if (isOk > 0) { j.success = true; j.msg = "添加成功"; } JavaScriptSerializer js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(j)); context.Response.End(); }
/// <summary> /// 根据id修改一条信息 /// </summary> /// <param name="context"></param> private void EditData(HttpContext context) { KingTop.Model.pageModel.Json j = new KingTop.Model.pageModel.Json(); KingTop.Model.Common.Common model = new KingTop.Model.Common.Common(); string id = context.Request.Params["id"]; if (!string.IsNullOrEmpty(id)) { model.Id = id; model.Title = context.Request.Params["Title"]; model.NodeCode = context.Request.Params["nodecode"]; model.UserName = context.Request.Params["UserName"]; model.BigImg = context.Request.Params["BigImg"]; model.FlowState = Utils.ParseInt(context.Request.Params["FlowState"], 3).ToString(); model.Orders = Utils.ParseInt(context.Request.Params["Order"], 0); model.Detail = context.Request.Params["TxtDetail"]; StringBuilder builder = new StringBuilder(); builder.Append("update K_U_Common "); builder.Append(" set Title=@Title,NodeCode=@NodeCode,UserName=@UserName,BigImg=@BigImg,FlowState=@FlowState,Orders=@Orders,Detail=@Detail"); builder.Append(" where id=@Id"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.VarChar), new SqlParameter("@Title", SqlDbType.NVarChar), new SqlParameter("@NodeCode", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@BigImg", SqlDbType.NVarChar), new SqlParameter("@FlowState", SqlDbType.Int), new SqlParameter("@Orders", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.NVarChar) }; cmdParms[0].Value = model.Id; cmdParms[1].Value = model.Title; cmdParms[2].Value = model.NodeCode; cmdParms[3].Value = model.UserName; cmdParms[4].Value = model.BigImg; cmdParms[5].Value = model.FlowState; cmdParms[6].Value = model.Orders; cmdParms[7].Value = model.Detail; int isOk = SQLHelper.ExecuteCommand(builder.ToString(), CommandType.Text, cmdParms); if (isOk > 0) { j.success = true; j.msg = "修改成功"; } else { j.success = false; j.msg = "修改失败"; } } JavaScriptSerializer js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(j)); context.Response.End(); }