/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.WorkOrderTag model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@BGID", SqlDbType.Int, 4),
new SqlParameter("@TagName", SqlDbType.NVarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@OrderNum", SqlDbType.Int, 4),
new SqlParameter("@PID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.BGID;
parameters[2].Value = model.TagName;
parameters[3].Value = model.Status;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.ModifyTime;
parameters[7].Value = model.ModifyUserID;
parameters[8].Value = model.OrderNum;
parameters[9].Value = model.PID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_WORKORDERTAG_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.WorkOrderTag model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@BGID", SqlDbType.Int, 4),
new SqlParameter("@TagName", SqlDbType.NVarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@OrderNum", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.BGID;
parameters[2].Value = model.TagName;
parameters[3].Value = model.Status;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.ModifyTime;
parameters[7].Value = model.ModifyUserID;
parameters[8].Value = model.OrderNum;
return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_WORKORDERTAG_UPDATE, parameters));
}
private Entities.WorkOrderTag LoadSingleWorkOrderTag(DataRow row)
{
Entities.WorkOrderTag model = new Entities.WorkOrderTag();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
if (row["BGID"].ToString() != "")
{
model.BGID = int.Parse(row["BGID"].ToString());
}
if (row["PID"].ToString() != "")
{
model.PID = int.Parse(row["PID"].ToString());
}
if (row["OrderNum"].ToString() != "")
{
model.OrderNum = int.Parse(row["OrderNum"].ToString());
}
model.TagName = row["TagName"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
if (row["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
}
if (row["ModifyUserID"].ToString() != "")
{
model.ModifyUserID = int.Parse(row["ModifyUserID"].ToString());
}
return(model);
}
public void ProcessRequest(HttpContext context)
{
BitAuto.YanFa.SysRightManager.Common.UserInfo.Check();
context.Response.ContentType = "text/plain";
currentContext = context;
if (!string.IsNullOrEmpty(action))
{
string strResult = string.Empty;
switch (action)
{
case "ChangeName":
strResult = ChangeName();
break;
case "ChangeOrder":
strResult = ChangeOrder();
break;
case "ChangeValidate":
strResult = ChangeValidate();
break;
case "DeleTag":
strResult = DeleTag();
break;
case "InsertNewTag":
strResult = InsertNewTag();
break;
case "GetSimulerWorkOrder":
strResult = GetSimulerWorkOrder();
break;
}
context.Response.Write(strResult);
context.Response.End();
return;
}
if ((context.Request["TagsSelectAll"] + "").Trim() == "yes")
{
//取当前选择的业务组
if (BGID != -1 && userID != -1)
{
//DataTable dt = BLL.BusinessGroup.Instance.GetBusinessGroupTagsByBGID(userID,BGID);
//标签管理页面已做数据权限制，这里直接取业务组下标签即可
DataTable dt = BLL.BusinessGroup.Instance.GetBusinessGroupTagsByBGIDOnly(BGID);
if (dt.Rows.Count > 0)
{
//在已选标签中遍历
//判断标签是否在已选择标签里，是则isSelected=true
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dt.Rows)
{
sb.Append("{'BGID':'" + row["BGID"].ToString() + "','GroupName':'" + row["GroupName"].ToString() + "','TagID':'" + row["TagID"].ToString() +
"','TagName':'" + row["TagName"].ToString() + "','IsUsed':'" + row["IsUsed"].ToString() + "','order':'" + row["OrderNum"].ToString() + "'},");
}
message = sb.ToString();
if (message.EndsWith(","))
{
message = message.Substring(0, message.Length - 1);
}
}
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
else if ((context.Request["TagsIsUsedSelect"] + "").Trim() == "yes")
{
if (TagID != -1)
{
bool isUsed = false;
isUsed = BLL.WorkOrderTag.Instance.isUsedTagByTagID(TagID);
if (isUsed)
{
message = "isUsed";
}
else
{
message = "notUsed";
}
}
context.Response.Write(message);
context.Response.End();
}
else if ((context.Request["InsertTag2DB"] + "").Trim() == "yes")
{
int retval = 0;
if (BGID != -1)
{
List <JsonTag> Tags = new List <JsonTag>();
Tags = (List <JsonTag>)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(tagsJSON, typeof(List <JsonTag>));
Entities.WorkOrderTag model = new Entities.WorkOrderTag();
foreach (JsonTag tag in Tags)
{
model.BGID = BGID;
model.CreateTime = DateTime.Now;
model.CreateUserID = userID;
model.ModifyUserID = userID;
model.ModifyTime = DateTime.Now;
model.Status = Convert.ToInt32(tag.Status);
model.TagName = HttpContext.Current.Server.UrlDecode(tag.TagName);
model.OrderNum = Convert.ToInt32(HttpContext.Current.Server.UrlDecode(tag.OrderNum.ToString()));
retval = BLL.WorkOrderTag.Instance.Insert(model);
}
}
if (retval > 0)
{
message = "操作成功";
}
else
{
message = "操作失败";
}
context.Response.Write(message);
context.Response.End();
}
else if ((context.Request["DeleteTag2DB"] + "").Trim() == "yes")
{
int retval = 0;
List <JsonTag> Tags = new List <JsonTag>();
Tags = (List <JsonTag>)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(tagsJSON, typeof(List <JsonTag>));
Entities.WorkOrderTag model = new Entities.WorkOrderTag();
string tagids = "";
foreach (JsonTag tag in Tags)
{
tagids += tag.TagID + ",";
}
if (tagids.EndsWith(","))
{
tagids = tagids.Substring(0, tagids.Length - 1);
}
tagids = "(" + tagids + ")";
retval = BLL.WorkOrderTag.Instance.DeleteMany(tagids);
if (retval > 0)
{
message = "操作成功";
}
else
{
message = "操作失败";
}
context.Response.Write(message);
context.Response.End();
}
else if ((context.Request["UpdateTag2DB"] + "").Trim() == "yes")
{
int retval = 0;
if (BGID != -1)
{
List <JsonTag> Tags = new List <JsonTag>();
Tags = (List <JsonTag>)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(tagsJSON, typeof(List <JsonTag>));
Entities.WorkOrderTag model = new Entities.WorkOrderTag();
foreach (JsonTag tag in Tags)
{
model.BGID = BGID;
model.CreateUserID = userID;
model.ModifyTime = DateTime.Now;
model.Status = Convert.ToInt32(tag.Status);
model.TagName = HttpContext.Current.Server.UrlDecode(tag.TagName);
model.RecID = tag.TagID;
model.OrderNum = Convert.ToInt32(HttpContext.Current.Server.UrlDecode(tag.OrderNum.ToString()));
retval = BLL.WorkOrderTag.Instance.Update(model);
}
}
if (retval > 0)
{
message = "操作成功";
}
else
{
message = "操作失败";
}
context.Response.Write(message);
context.Response.End();
}
else
{
success = false;
message = "request error";
BitAuto.ISDC.CC2012.BLL.AJAXHelper.WrapJsonResponse(success, result, message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.WorkOrderTag model)
{
return(Dal.WorkOrderTag.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.WorkOrderTag model)
{
return(Dal.WorkOrderTag.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.WorkOrderTag model)
{
return(Dal.WorkOrderTag.Instance.Insert(model));
}
