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