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