public string UpdStatus(DesignRequestQuery drt) { string json = string.Empty; try { if (drt.dr_status == 2 ) {//狀態為新建立,類型為內頁文, if (drt.product_id != 0&& drt.dr_type == 4) {//審核文字通過新增到product表,變更狀態 if (_DesignRequestDao.UpdateProductDetailText(drt) ==0) { return json = "{success:true,msg:3}";//更新內頁文失敗 } } if (GetExpected(drt) > 0) {//已審核的文件算出期望完成時間 int day = Getday(drt); drt.day = day; } if (_DesignRequestDao.UpdStatus(drt) > 0) { return json = "{success:true,msg:0}";//審核成功 } else { return json = "{success:false}"; } } else if (drt.dr_assign_to > 0) {//指派工作 變更指派人員 //認領工作只能設計部人員認領 //指派工作只能主管指派 if (_DesignRequestDao.IsManager(drt) ||(drt.Istake==1 && IsManagerNumber(drt))) { drt.dr_status = 3; MailHelper mail = new MailHelper(); string sbHtml = "你好,派工系統申請的文案通過審核分配給您,請前去查看工作內容 "; if (mail.SendToUser(GetmailId(drt.dr_assign_to), "派工系統", sbHtml.ToString()))//發送email給指派的人員 { if (_DesignRequestDao.UpdStatus(drt) > 0) { return json = "{success:true,msg:0}";//msg=2表示有敏感詞 } else { return json = "{success:false}";//msg=2表示有敏感詞 } } else { return json = "{success:true,msg:4}";//email發送失敗 } } else { return json = "{success:true,msg:2}";//msg=2不是設計部人員不能指派 } } else {//如果是設計人員就可以變更已指派後面的所有狀態 if (IsDesSelf(drt)) { if (_DesignRequestDao.UpdStatus(drt) > 0) { return json = "{success:true,msg:0}";//msg=2表示有敏感詞 } else { return json = "{success:false}";//msg=2表示有敏感詞 } } else { return json = "{success:true,msg:2}";//msg=2不是設計部人員不能指派 } } } catch (Exception ex) { throw new Exception("DesignRequestMgr.UpdStatus-->" + ex.Message, ex); } }
public string DelDesignRequest(DesignRequestQuery query) { string json = ""; try { if (IsSelf(query)) { if (query.dr_status>2) { MailHelper mail = new MailHelper(); string sbHtml = "你好,派工系統分配給您的工作被需求者刪除,還請查看 "; if (!mail.SendToUser(GetmailId(query.dr_assign_to), "派工系統", sbHtml.ToString()))//發送email給指派的人員 { return json = "{success:true,msg:3}";//郵件發送失敗 } } if (_DesignRequestDao.DelDesignRequest(query) > 0) { return json = "{success:true,msg:0}"; } else { return json = "{success:true,msg:1}";//msg=1刪除失敗 } } else { return json = "{success:true,msg:2}";//msg=2不是需求者不能刪除 } } catch (Exception ex) { throw new Exception("DesignRequestMgr.DelDesignRequest-->" + ex.Message, ex); } }