コード例 #1
0
 public List<DesignRequestQuery> GetList(DesignRequestQuery query, out int totalCount)
 {
     try
     {
        return _DesignRequestDao.GetList(query, out totalCount);
     }
     catch (Exception ex)
     {
        throw new Exception("DesignRequestMgr.GetList-->" + ex.Message, ex);
     }
 }
コード例 #2
0
        public HttpResponseBase GetDesignRequestList()
        {
            string json = string.Empty;
            int totalCount = 0;
            DesignRequestQuery query = new DesignRequestQuery();
            
            List<DesignRequestQuery> store = new List<DesignRequestQuery>();
            _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString);
            try
            {
                query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
                query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量
                if (!string.IsNullOrEmpty(Request.Params["dr_requester"]))
                {
                    query.dr_requester_id_name = Request.Params["dr_requester"].ToString().Trim();
                }
                if (!string.IsNullOrEmpty(Request.Params["dr_type"]))
                {
                    query.dr_type = Convert.ToInt32(Request.Params["dr_type"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["assign_to"]))
                {
                    query.dr_assign_to = Convert.ToInt32(Request.Params["assign_to"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["status"]))
                {
                    query.dr_status = Convert.ToInt32(Request.Params["status"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["start_time"]))
                {
                    query.start_time = Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd HH:mm:ss");
                }
                if (!string.IsNullOrEmpty(Request.Params["search_date"]))
                {
                    query.date_type = Convert.ToInt32(Request.Params["search_date"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["end_time"]))
                {
                    query.end_time = Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd HH:mm:ss");
                }
                query.login_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
                store = _DesignRequestMgr.GetList(query,out totalCount);
                foreach (var item in store)
                {
                    if (item.dr_expected < DateTime.Now.Date)
                    {
                        item.Isgq = 1;
                    }
                }
                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";

                json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                json = "{success:false,totalCount:0,data:[]}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
コード例 #3
0
 public HttpResponseBase TakeJob()
 {
     string json = string.Empty;
     DesignRequestQuery query = new DesignRequestQuery();
     _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString);
     try
     {
         if (!string.IsNullOrEmpty(Request.Params["dr_id"]))
         {
             query.dr_ids = Request.Params["dr_id"].ToString();
         }
         query.dr_ids = query.dr_ids.Substring(0, query.dr_ids.Length - 1);
         query.login_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
         query.dr_assign_to = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
         query.Istake = 1;//認領工作是全部設計人員都可認領
         json = _DesignRequestMgr.UpdStatus(query);
     }
     catch (Exception ex)
     {
         Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
         logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
         logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
         log.Error(logMessage);
         json = "{success:false}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
コード例 #4
0
 public HttpResponseBase DesigneeSave()
 {
     string json = string.Empty;
     DesignRequestQuery query = new DesignRequestQuery();
     _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString);
     try
     {
         //獲取id
         if (!string.IsNullOrEmpty(Request.Params["dr_id"]))
         {
             query.dr_id = Convert.ToUInt32(Request.Params["dr_id"]);
         }
         //獲取狀態
         if (!string.IsNullOrEmpty(Request.Params["dr_status"]))
         {
             query.dr_status = Convert.ToInt32(Request.Params["dr_status"]) + 1;
         }
         //獲取派工人員
         if (!string.IsNullOrEmpty(Request.Params["dr_assign_to"]))
         {
             query.dr_assign_to = Convert.ToInt32(Request.Params["dr_assign_to"]);
         }
         query.login_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
         json = _DesignRequestMgr.UpdStatus(query);
     }
     catch (Exception ex)
     {
         Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
         logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
         logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
         log.Error(logMessage);
         json = "{success:false}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
コード例 #5
0
 public int DelDesignRequest(DesignRequestQuery query)
 {
     StringBuilder sb = new StringBuilder();
     try
     {
         sb.AppendFormat(@"DELETE FROM design_request WHERE dr_id IN ({0});",query.dr_ids);
         return _accessMySql.execCommand(sb.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.DelDesignRequest-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #6
0
 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);
     }
 }
コード例 #7
0
 public bool IsManagerNumber(DesignRequestQuery drt)
 {
     try
     {
        return  _DesignRequestDao.IsManagerNumber(drt);
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestMgr.IsManagerNumber-->" + ex.Message, ex);
     }
 }
コード例 #8
0
        public bool IsManagerNumber(DesignRequestQuery drt)
        {
            bool bo=false;
            StringBuilder sb = new StringBuilder();
            try
            {
                sb.Append(@"SELECT m.user_id from t_fgroup tf
LEFT JOIN t_groupcaller tg ON tf.rowid=tg.groupId
LEFT JOIN manage_user m ON tg.callid=m.user_email
LEFT JOIN t_parametersrc t ON  t.parameterCode=tf.rowid
WHERE  t.parameterType='design';");
                DataTable _dt = _accessMySql.getDataTable(sb.ToString());
                for (int i = 0; i < _dt.Rows.Count; i++)
                {
                    if (Convert.ToInt32(_dt.Rows[i][0]) == drt.login_id)
                    {
                        bo= true;
                    }
                }
                return bo;
            }
            catch (Exception ex)
            {
                throw new Exception("DesignRequestDao.IsManager-->" + ex.Message + sb.ToString(), ex);
            }
        }
コード例 #9
0
 public DataTable GetExpected(DesignRequestQuery drt)
 {
     DataTable _dt = new DataTable();
     StringBuilder sb = new StringBuilder();
     try
     {
         if (drt.dr_type > 0)
         {
             sb.AppendFormat("SELECT remark FROM t_parametersrc WHERE parameterType='job_day' and parameterCode='{0}' ", drt.dr_type);
             _dt = _accessMySql.getDataTable(sb.ToString());
         }
         return _dt;               
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.GetExpected-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #10
0
 public int UpdStatus(DesignRequestQuery drt)
 {
     StringBuilder sb = new StringBuilder();
     try
     {
          if (drt.dr_status > 1)
          {
              sb.AppendFormat(@"update design_request set dr_status='{0}' ", drt.dr_status);
              if (drt.dr_assign_to > 0)
              {
                  sb.AppendFormat(" ,dr_assign_to='{0}' ", drt.dr_assign_to);
              }
              if (drt.day > 0)
              {
                  sb.AppendFormat(" ,dr_expected=DATE_ADD(NOW(),INTERVAL '{0}' DAY) ", drt.day);
              }
              if (drt.dr_id > 0)
              {
                  sb.AppendFormat("  where dr_id in ({0})  ", drt.dr_id);
              }
              else
              {
                  sb.AppendFormat("  where dr_id in ({0}) ", drt.dr_ids);
              
              }
              return _accessMySql.execCommand(sb.ToString());
          }
          else
          {
              return 0;
          }
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.UpdStatus-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #11
0
 public bool IsManager(DesignRequestQuery drt)
 {
     StringBuilder sb = new StringBuilder();
     try
     {
         sb.Append("SELECT parameterCode FROM t_parametersrc WHERE parameterType='design_manager';");
         DataTable _dt = _accessMySql.getDataTable(sb.ToString());
         if (_dt.Rows.Count > 0 && Convert.ToInt32(_dt.Rows[0][0]) == drt.login_id)
         {
             return true;
         }
         else
         {
             return false;
         }
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.IsManager-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #12
0
 public int UpdateProductDetailText(DesignRequestQuery drt)
 {
     StringBuilder sb = new StringBuilder();
     try
     {
         DataTable _dt = GetPorductNameByProductId(Convert.ToInt32(drt.product_id));
         sb.AppendFormat(@"update product set product_detail_text='{0}'", drt.dr_content_text);
         if (string.IsNullOrEmpty(_dt.Rows[0]["product_detail_text"].ToString()))
         {//無內容的變更時間和建立人
             sb.AppendFormat(",detail_createdate='{0}',detail_created='{1}' ", Common.CommonFunction.DateTimeToString(DateTime.Now), drt.dr_requester_id);
         }
         else 
         {
             sb.AppendFormat(",detail_updatedate='{0}',detail_update='{1}' ", Common.CommonFunction.DateTimeToString(DateTime.Now), drt.dr_requester_id);
         }
         sb.AppendFormat(" where product_id='{0}';", drt.product_id);
         return  _accessMySql.execCommand(sb.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.UpdateProductDetailText-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #13
0
 public List<DesignRequestQuery> GetList(DesignRequestQuery query,out int totalCount)
 {
     StringBuilder sb = new StringBuilder();
     StringBuilder sbwhere = new StringBuilder();
     StringBuilder sbcount = new StringBuilder();
     totalCount = 0;
     try
     {
         sb.Append("SELECT dr.dr_id,dr_type,dr.dr_content_text,dr.dr_description,dr.dr_document_path,dr.dr_resource_path");
         sb.Append(",mu.user_username AS dr_requester_id_name,mu1.user_username AS dr_assign_to_name,tp1.parameterName as dr_type_tostring,tp3.parameterName AS dr_status_tostring,dr.dr_created,dr.dr_modified,dr.product_id,p.product_name,dr.dr_status,dr_expected,dr_assign_to ");
         sbwhere.Append(" FROM design_request dr ");
         sbwhere.Append("  LEFT JOIN manage_user mu  ON mu.user_id=dr.dr_requester_id  ");
         sbwhere.Append(" LEFT JOIN manage_user mu1 ON mu1.user_id=dr.dr_assign_to  ");
         sbwhere.Append(" LEFT JOIN product p ON p.product_id=dr.product_id  ");
         sbwhere.Append(" LEFT JOIN (SELECT tp.parameterName,tp.parameterCode FROM t_parametersrc tp WHERE tp.parameterType='job_type') tp1 ON tp1.parameterCode=dr.dr_type  ");
         sbwhere.Append(" LEFT JOIN (SELECT tp2.parameterName,tp2.parameterCode FROM t_parametersrc tp2 WHERE tp2.parameterType='job_status') tp3 ON tp3.parameterCode=dr.dr_status  ");
         sbcount.Append(" select count(dr.dr_id) as totalCount ");
         sbwhere.Append(" where 1=1 ");
         if (!IsManager(query) && !IsEmail(query) && !IsManagerNumber(query))
         {//不是主管,不是郵件群組人員,不是設計部人員就限制查看的項目
             sbwhere.AppendFormat(" and (dr.dr_requester_id='{0}' or dr.dr_assign_to ='{0}') ", query.login_id);
         }
         if (!string.IsNullOrEmpty(query.dr_requester_id_name))
         {
             sbwhere.AppendFormat(" AND mu.user_username LIKE '%{0}%'  ", query.dr_requester_id_name);
         }
         if (query.dr_type!=0)
         {
             sbwhere.AppendFormat(" and dr.dr_type='{0}' ", query.dr_type);
         }
         if (query.dr_assign_to != 0)
         {
             sbwhere.AppendFormat(" and dr.dr_assign_to='{0}' ", query.dr_assign_to);
         }
         if (query.dr_status != 0)
         {
             sbwhere.AppendFormat(" and dr.dr_status='{0}' ", query.dr_status);
         }
         else
         {//如果沒有選擇狀態默認為非已結案的全部顯示
             sbwhere.AppendFormat(" and dr.dr_status<>'6' ", query.dr_status);
         }
         if (query.date_type != 0)
         {
             if (!string.IsNullOrEmpty(query.start_time))
             {
                 sbwhere.AppendFormat(" and dr.dr_created>='{0}' ", query.start_time);
             }
             if (!string.IsNullOrEmpty(query.end_time))
             {
                 sbwhere.AppendFormat(" and dr.dr_created<='{0}' ", query.end_time);
             }
         }
         if (query.IsPage)
         {
             sbcount.Append(sbwhere.ToString());
             DataTable dt = _accessMySql.getDataTable(sbcount.ToString());
             if (dt != null && dt.Rows.Count > 0)
             {
                 totalCount = Convert.ToInt32(dt.Rows[0]["totalCount"]);
             }
         }
         sbwhere.AppendFormat(" order by dr.dr_id desc limit {0},{1} ",query.Start,query.Limit);
         sb.Append(sbwhere.ToString());
         return _accessMySql.getDataTableForObj<DesignRequestQuery>(sb.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.GetList-->" + ex.Message + sb.ToString()+sbwhere.ToString(), ex);
     }
 }
コード例 #14
0
 public DesignRequestQuery GetSingleDesignRequest(DesignRequestQuery query)
 {
     StringBuilder sb = new StringBuilder();
     try
     {
         sb.AppendFormat(@"SELECT dr_type,dr_assign_to FROM design_request WHERE dr_id='{0}'", query.dr_id);
         return _accessMySql.getSinggleObj<DesignRequestQuery>(sb.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.GetSingleDesignRequest-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #15
0
 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);
     }
 }
コード例 #16
0
 //是否是檢查關鍵人人員
 public bool IsEmail(DesignRequestQuery drt)
 {
     StringBuilder sb = new StringBuilder();
     try
     {
         sb.Append(@"SELECT user_id from manage_user where user_email IN (SELECT user_mail from mail_user where row_id IN (SELECT user_id from mail_group_map where group_id IN (SELECT row_id from mail_group WHERE group_code='Job')));");
         DataTable _dt = _accessMySql.getDataTable(sb.ToString());
         for (int i = 0; i < _dt.Rows.Count; i++)
         {
             if (Convert.ToInt32(_dt.Rows[i][0]) == drt.login_id)
             {
                 return true;
             }
         }
         return false;
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.IsEmail-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #17
0
 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);
     }
 }
コード例 #18
0
 public bool IsDesSelf(DesignRequestQuery drt)
 {
     bool bo = false;
     StringBuilder sb = new StringBuilder();
     try
     {//是否是自己申請的派工系統
         sb.AppendFormat("SELECT dr_assign_to from design_request WHERE dr_id in ('{0}') ;", drt.dr_id);
         DataTable _dt = _accessMySql.getDataTable(sb.ToString());
         for (int i = 0; i < _dt.Rows.Count; i++)
         {
             if (Convert.ToInt32(_dt.Rows[i][0]) == drt.login_id)
             {
                 bo = true;
             }
             else
             {
                 return false;
             }
         }
         return bo;
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestDao.IsDesSelf-->" + ex.Message + sb.ToString(), ex);
     }
 }
コード例 #19
0
 public int GetExpected(DesignRequestQuery drt)
 {
     string json = string.Empty;
     int day =0;
     try
     {
         if (_DesignRequestDao.GetExpected(drt).Rows.Count>0)
         {
             if (int.TryParse(_DesignRequestDao.GetExpected(drt).Rows[0][0].ToString(),out day))
             {
                 return day;
             }
         }
         return day;                
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestMgr.GetExpected-->" + ex.Message, ex);
     }
 }
コード例 #20
0
 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);
     }
 }
コード例 #21
0
 public bool IsDesSelf(DesignRequestQuery drt)
 {
     try
     {
         return _DesignRequestDao.IsDesSelf(drt);
     }
     catch (Exception ex)
     {
         throw new Exception("DesignRequestMgr.IsDesSelf-->" + ex.Message, ex);
     }
 }
コード例 #22
0
 public HttpResponseBase DesignRequestEdit()
 {
     string json = string.Empty;
     DesignRequestQuery query = new DesignRequestQuery();
     _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString);
     try
     {
         if (!string.IsNullOrEmpty(Request.Params["dr_id"]))
         {
             query.dr_id = Convert.ToUInt32(Request.Params["dr_id"]);
         }
         if (!string.IsNullOrEmpty(Request.Params["dr_content_text"]))
         {
             query.dr_content_text = Request.Params["dr_content_text"].ToString().Replace("\\", "\\\\"); 
         }
         if (!string.IsNullOrEmpty(Request.Params["dr_description"]))
         {
             query.dr_description = Request.Params["dr_description"].Replace("\\", "\\\\");
         }
         if (!string.IsNullOrEmpty(Request.Params["dr_document_path"]))
         {
             query.dr_document_path = Request.Params["dr_document_path"];
         }
         if (!string.IsNullOrEmpty(Request.Params["dr_resource_path"]))
         {
             query.dr_resource_path = Request.Params["dr_resource_path"];
         }
         if (!string.IsNullOrEmpty(Request.Params["product_id"]))
         {
             query.product_id = Convert.ToUInt32(Request.Params["product_id"]);
         }
         if (!string.IsNullOrEmpty(Request.Params["dr_type"]))
         {
             int num = 0;
             if (int.TryParse(Request.Params["dr_type"], out num))
             {
                 query.dr_type = num;
             }
             else
             {
                 query.dr_type_tostring = Request.Params["dr_type"].ToString();
             }
         }
         query.dr_created = DateTime.Now;
         query.dr_status = 1;
         query.dr_requester_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
         json = _DesignRequestMgr.DesignRequestEdit(query);
     }
     catch (Exception ex)
     {
         Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
         logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
         logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
         log.Error(logMessage);
         json = "{success:false}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
コード例 #23
0
 public int Getday(DesignRequestQuery query)
 { //獲取完成天數
     string week =DateTime.Now.DayOfWeek.ToString();
     int day = GetExpected(query);
     switch (day)
     {
         case 3:
             if (week == "Wednesday" || week == "Thursday" || week == "Friday")
                 day = day + 2;
             break;
         case 2:
             if (week == "Thursday" || week == "Friday")
                 day = day + 2;
             break;
         case 1:
             if (week == "Friday")
                 day = day + 2;
             break;
         default:                                 
             break;
     }
     return day;        
 }
コード例 #24
0
 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);
     }
 }