/// <summary> /// 功能描述 : 根据主键取得[tblEQI_Item_Group]表的记录 /// 创建者 : Auto Generator /// 创建日期 : 2009-04-29 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="iPK">PK主键值</param> /// <returns>tblEQI_Item_Group</returns> public tblEQI_Item_Group ByPK(int iPK) { try { usp_tblEQI_Item_Group_ByPK uspByPK = new usp_tblEQI_Item_Group_ByPK(); uspByPK.fldAutoID = iPK; DataTable tblData = uspByPK.ExecDataTable(); if (tblData != null) { tblEQI_Item_Group objData = new tblEQI_Item_Group(); objData.MetaDataTable = tblData; return(objData); } else { throw new Exception("取得单条记录失败,未找到对应的记录"); } } catch (DBOpenException e) { throw new GetByPKException("打开数据库连接失败", "RuletblEQI_Item_Group", "ByPK", iPK.ToString()); } catch (DBQueryException e) { throw new GetByPKException("执行Sql语句失败", "RuletblEQI_Item_Group", "ByPK", iPK.ToString()); } catch (Exception e) { throw new GetByPKException(e.Message, "RuletblEQI_Item_Group", "ByPK", iPK.ToString()); } }
/// <summary> /// 功能描述 : 添加[tblEQI_Item_Group]表的记录 /// 创建者 : Auto Generator /// 创建日期 : 2009-04-28 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="objInsert">需要添加的实体类</param> /// <returns>返回新增记录的PK主键的值</returns> public int Insert(tblEQI_Item_Group objInsert) { try { usp_tblEQI_Item_Group_Insert uspInsert = new usp_tblEQI_Item_Group_Insert(); uspInsert.ReceiveParameter(objInsert); uspInsert.ExecNoQuery(); if (uspInsert.fldAutoID > 0) { return(uspInsert.fldAutoID); } else { throw new Exception("插入新记录失败"); } } catch (DBOpenException e) { throw new InsertException("打开数据库连接失败", "RuletblEQI_Item_Group", "Insert", objInsert.ToString()); } catch (DBPKException e) { throw new InsertPKException("相同的记录已经存在,违反表的唯一键约束", "RuletblEQI_Item_Group", "Insert", objInsert.ToString()); } catch (DBQueryException e) { throw new InsertException("执行Sql语句失败", "RuletblEQI_Item_Group", "Insert", objInsert.ToString()); } catch (Exception e) { throw new InsertException(e.Message, "RuletblEQI_Item_Group", "Insert", objInsert.ToString()); } }
/// <summary> /// 功能描述 : 查询保存的分组 /// 创建者 : 周文卿 /// 创建日期 : 2017-07-05 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="stcode">城市代码</param> /// <param name="type">业务类别</param> /// <returns>IList</returns> public List <tblEQI_Item_Group> GetdllBystcode(string stcode, string type) { try { List <tblEQI_Item_Group> list = new List <tblEQI_Item_Group>(); usp_tblEQI_getdllBystcode usp_t = new usp_tblEQI_getdllBystcode(); usp_t.stcode = stcode; usp_t.fldObject = type; DataTable dt = usp_t.ExecDataTable(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { tblEQI_Item_Group tig = new tblEQI_Item_Group(); tig.fldName = dt.Rows[i]["fldName"].ToString(); tig.fldAutoID = Int32.Parse(dt.Rows[i]["fldAutoID"].ToString()); tig.fldItemContent = dt.Rows[i]["fldItemContent"].ToString(); list.Add(tig); } } return(list); } catch (DBOpenException e) { throw new GetListException("打开数据库连接失败", "RuletblEQI_publi", "usp_tblEQI_Section_getCodeByRRCode", "stcode:" + stcode); } catch (DBQueryException e) { throw new GetListException("执行Sql语句失败", "RuletblEQI_publi", "usp_tblEQI_Section_getCodeByRRCode", "stcode:" + stcode); } catch (Exception e) { throw new GetListException(e.Message, "RuletblEQI_publi", "usp_tblEQI_Section_getCodeByRRCode", "stcode:" + stcode); } }
/// <summary> /// 功能描述 : 根据用户ID和分组所属模块获得[tblEQI_Item_Group]表的所有记录 /// 创建者 : 张浩 /// 创建日期 : 2009-04-28 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <returns>IList</returns> public IList <tblEQI_Item_Group> GetByUserIDandObject(int UserID, string Object) { try { DataTable tblData = new DataTable(); usp_tblEQI_Item_Group_ByUserIDandObject uspByUserIDandObject = new usp_tblEQI_Item_Group_ByUserIDandObject(); uspByUserIDandObject.fldUserID = UserID; uspByUserIDandObject.fldObject = Object; tblData = uspByUserIDandObject.ExecDataTable(); if (tblData != null) { IList <tblEQI_Item_Group> listAll = new List <tblEQI_Item_Group>(); for (int i = 0; i < tblData.Rows.Count; i++) { DataTable tblTmp = tblData.Clone(); tblTmp.Rows.Add(tblData.Rows[i].ItemArray); tblEQI_Item_Group objData = new tblEQI_Item_Group(); objData.MetaDataTable = tblTmp; listAll.Add(objData); } tblData.Dispose(); return(listAll); } else { throw new Exception("取得记录失败,未找到对应的记录"); } } catch (DBOpenException e) { throw new GetListException("打开数据库连接失败", "RuletblEQI_Item_Group", "GetByUserIDandObject", "UserID:" + UserID.ToString() + ",Object:" + Object); } catch (DBQueryException e) { throw new GetListException("执行Sql语句失败", "RuletblEQI_Item_Group", "GetByUserIDandObject", "UserID:" + UserID.ToString() + ",Object:" + Object); } catch (Exception e) { throw new GetListException(e.Message, "RuletblEQI_Item_Group", "GetByUserIDandObject", "UserID:" + UserID.ToString() + ",Object:" + Object); } }
/// <summary> /// 功能描述 : 更新[tblEQI_Item_Group]表的记录 /// 创建者 : Auto Generator /// 创建日期 : 2009-04-28 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="objUpdate_old">需要更新的实体类</param> /// <param name="objUpdate_new">更新后的实体类</param> /// <returns>true / false</returns> public bool Update(tblEQI_Item_Group objUpdate_old, tblEQI_Item_Group objUpdate_new) { try { usp_tblEQI_Item_Group_Update uspUpdate = new usp_tblEQI_Item_Group_Update(); uspUpdate.ReceiveParameter_Old(objUpdate_old); uspUpdate.ReceiveParameter_New(objUpdate_new); int iResult = uspUpdate.ExecNoQuery(); if (iResult > 0) { return(true); } else { throw new Exception("更新记录失败,未找到对应的记录"); } } catch (DBOpenException e) { throw new UpdateException("打开数据库连接失败", "RuletblEQI_Item_Group", "Update", "objUpdate_old:" + objUpdate_old.ToString() + ";objUpdate_new:" + objUpdate_new.ToString()); } catch (DBPKException e) { throw new UpdatePKException("相同的记录已经存在,违反表的唯一键约束", "RuletblEQI_Item_Group", "Update", "objUpdate_old:" + objUpdate_old.ToString() + ";objUpdate_new:" + objUpdate_new.ToString()); } catch (DBQueryException e) { throw new UpdateException("执行Sql语句失败", "RuletblEQI_Item_Group", "Update", "objUpdate_old:" + objUpdate_old.ToString() + ";objUpdate_new:" + objUpdate_new.ToString()); } catch (Exception e) { throw new UpdateException(e.Message, "RuletblEQI_Item_Group", "Update", "objUpdate_old:" + objUpdate_old.ToString() + ";objUpdate_new:" + objUpdate_new.ToString()); } }
//[SupportFilter] public HttpResponseMessage UpdateItemGroup(dynamic obj) { string result = string.Empty; try { if (string.IsNullOrEmpty(Convert.ToString(obj.id)) || Convert.ToString(obj.id) == "0") { result = rule.JsonStr("error", "id参数错误", "缺少更新的项目信息"); } else if (string.IsNullOrEmpty(Convert.ToString(obj.flditemcontent))) { result = rule.JsonStr("error", "flditemcontent参数错误", "缺少要保存在分组中的项目"); } else if (string.IsNullOrEmpty(Convert.ToString(obj.modeltype))) { result = rule.JsonStr("error", "fldobject参数错误", "缺少业务类型"); } else { try { string type = gettype(HttpUtility.UrlDecode(Convert.ToString(obj.modeltype))); RuletblEQI_Item_Group rule_group = new RuletblEQI_Item_Group(); tblEQI_Item_Group objObject_old = rule_group.ByPK(Convert.ToInt32(rule.ConductUserinfo(obj.id))); tblEQI_Item_Group objObject_new = new tblEQI_Item_Group(); objObject_new.fldObject = type; objObject_new.fldUserID = objObject_old.fldUserID; objObject_new.fldName = objObject_old.fldName; objObject_new.fldItemContent = HttpUtility.UrlDecode(Convert.ToString(obj.flditemcontent)); bool isdelete = rule_group.Update(objObject_old, objObject_new); if (isdelete) { objObject_new.fldAutoID = Convert.ToInt32(obj.id); result = rule.JsonStr("ok", "更新组成功", objObject_new); } } catch (UpdatePKException ex) { result = rule.JsonStr("error", "flditemcontent参数错误", "请选择要保存在分组中的项目"); } catch (DDYZ.Ensis.Library.Exception.DataRule.UpdateException ex) { PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "UpdateItemProject", ""); result = rule.JsonStr("error", "更新项目信息时出现了错误", ""); } catch (Exception ex) { PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "UpdateItemProject", ""); result = rule.JsonStr("error", "更新项目信息时出现了错误", ""); } } } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
//[SupportFilter] public HttpResponseMessage AddItemGroup(dynamic obj) { string result = string.Empty; try { //验证字符串是否符合要求 if (!string.IsNullOrEmpty(Convert.ToString(obj.fldname))) { if (!string.IsNullOrEmpty(Convert.ToString(obj.flditemcontent))) { if (!string.IsNullOrEmpty(Convert.ToString(obj.modeltype))) { try { string type = gettype(HttpUtility.UrlDecode(Convert.ToString(obj.modeltype))); tblEQI_Item_Group item_group = new tblEQI_Item_Group(); item_group.fldName = HttpUtility.UrlDecode(Convert.ToString(obj.fldname)); item_group.fldObject = type; item_group.fldUserID = Convert.ToInt32(rule.ConductUserinfo(obj.UserID)); item_group.fldItemContent = Convert.ToString(obj.flditemcontent); RuletblEQI_Item_Group rule_group = new RuletblEQI_Item_Group(); int returnID = rule_group.Insert(item_group); if (returnID > 0) { item_group.fldAutoID = returnID; result = rule.JsonStr("ok", "", item_group); } } catch (InsertPKException ex) { result = rule.JsonStr("error", "相同名称的分组已经存在,请输入其它名称", ""); } catch (InsertException ex) { PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "AddItemProject", ""); result = rule.JsonStr("error", "项目分组信息写入数据库失败", ""); } catch (Exception ex) { PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "AddItemProject", ""); result = rule.JsonStr("error", "新增项目分组失败", ""); } } else { result = rule.JsonStr("error", "fldobject参数错误", ""); } } else { result = rule.JsonStr("error", "flditemcontent参数错误", "请选择要保存在分组中的项目"); } } else { result = rule.JsonStr("error", "fldname参数错误", "请输入要保存的名称"); } } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }