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