public int InsertDesignRequest(DesignRequestQuery query) { StringBuilder sb = new StringBuilder(); query.Replace4MySQL(); try { sb.AppendFormat(@"INSERT INTO design_request (dr_requester_id,dr_type,dr_assign_to,dr_content_text,dr_description,dr_resource_path,dr_document_path,dr_status,dr_created,product_id,dr_expected) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',NOW(),'{8}',DATE_ADD(NOW(),INTERVAL '{9}' DAY));", query.dr_requester_id, query.dr_type, query.dr_assign_to, query.dr_content_text, query.dr_description, query.dr_resource_path, query.dr_document_path, query.dr_status, query.product_id, query.day); return _accessMySql.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("DesignRequestDao.InsertDesignRequest-->" + ex.Message + sb.ToString(), ex); } }
public string DesignRequestEdit(DesignRequestQuery query) { string json = string.Empty; query.Replace4MySQL(); query.dr_resource_path = query.dr_resource_path.Replace("\\", "\\\\"); query.dr_document_path = query.dr_document_path.Replace("\\", "\\\\"); List<DisableKeywords> list = new List<DisableKeywords>(); try { int j = 0; list = _DesignRequestDao.GetKeyWordsList(); for (int i = 0; i < list.Count; i++) { if (query.dr_content_text.Contains(list[i].dk_string)) { j = 1; } } if (query.dr_id == 0) {//新增 if (query.product_id != 0 && query.dr_type == 4 && j != 1) { _DesignRequestDao.UpdateProductDetailText(query); } if (j == 1) { query.dr_status = 1; MailHelper mail = new MailHelper(); string sbHtml = "你好,派工系統申請的文案包含有禁用的關鍵字,還請前去查看新建立的項目 "; mail.SendToGroup("job", "派工系統", sbHtml.ToString(), false, true); } else { query.dr_status = 2;//已審核 if (GetExpected(query) > 0 && j != 1) {//已審核的文件直接算出期望完成時間 int day = Getday(query); //query.dr_expected = DateTime.Now.AddDays(day); query.day = day; } } int res = _DesignRequestDao.InsertDesignRequest(query); if (res > 0) { json = "{success:true,type:1,msg:1}";//type=1表示新增,msg=1表示新增成功 } else { json = "{success:true,type:1,msg:0}";//type=1表示新增,msg=0表示新增失敗 } } else { //編輯 query.dr_status = 1; DesignRequestQuery OldModel = new DesignRequestQuery(); OldModel = _DesignRequestDao.GetSingleDesignRequest(query); if (!string.IsNullOrEmpty(query.dr_type_tostring)) { query.dr_type = OldModel.dr_type; } if (query.product_id != 0 && query.dr_type == 4 && j != 1) { _DesignRequestDao.UpdateProductDetailText(query); } if (j == 1) { query.dr_status = 1; MailHelper mail = new MailHelper(); string sbHtml = "你好,派工系統申請的文案包含有禁用的關鍵字,還請前去查看新建立的項目 "; mail.SendToGroup("job", "派工系統", sbHtml.ToString(), false, true); } else { query.dr_status = 2; if (GetExpected(query) > 0 && j != 1) {//已審核的文件直接算出期望完成時間 int day = Getday(query); //query.dr_expected = DateTime.Now.AddDays(day); query.day = day; } } int res = _DesignRequestDao.UpdateDesignRequest(query); if (res > 0) { json = "{success:true,type:2,msg:1}";//type=2表示編輯,msg=1表示編輯成功 } else { json = "{success:true,type:2,msg:0}";//type=2表示編輯,msg=0表示編輯失敗 } } return json; } catch (Exception ex) { throw new Exception("DesignRequestMgr.DesignRequestEdit-->" + ex.Message, ex); } }
public int UpdateDesignRequest(DesignRequestQuery query) { StringBuilder sb = new StringBuilder(); query.Replace4MySQL(); try { sb.AppendFormat(@"UPDATE design_request SET dr_content_text='{0}',dr_description='{1}',dr_resource_path='{2}',dr_document_path='{3}',dr_type='{4}',product_id='{5}',dr_status='{6}' ", query.dr_content_text, query.dr_description, query.dr_resource_path, query.dr_document_path, query.dr_type, query.product_id,query.dr_status); if (query.day > 0) { sb.AppendFormat(@",dr_expected=DATE_ADD(NOW(),INTERVAL '{0}' DAY) ", query.day); } sb.AppendFormat(@"WHERE dr_id='{0}';", query.dr_id); return _accessMySql.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("DesignRequestDao.UpdateDesignRequest-->" + ex.Message + sb.ToString(), ex); } }