public ProductConsultQuery GetProductInfo(ProductConsultQuery query)
{
try
{
return _productConsultImplDao.GetProductInfo(query);
}
catch (Exception ex)
{
throw new Exception("ProductConsultMgr-->UpdateActive-->" + ex.Message, ex);
}
}
/// <summary>
/// 更改回覆狀態
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateAnswerStatus(ProductConsultQuery model)
{
try
{
return _productConsultImplDao.UpdateAnswerStatus(model);
}
catch (Exception ex)
{
throw new Exception("ProductConsultMgr-->UpdateAnswerStatus-->" + ex.Message, ex);
}
}
public List<ProductConsultQuery> Query(ProductConsultQuery store, out int totalCount)
{
try
{
return _productConsultImplDao.Query(store, out totalCount);
}
catch (Exception ex)
{
throw new Exception("ProductConsultMgr-->Query-->" + ex.Message, ex);
}
}
public int SaveProductConsultAnswer(ProductConsultQuery query)
{
try
{
return _productConsultImplDao.SaveProductConsultAnswer(query);
}
catch (Exception ex)
{
throw new Exception("ProductConsultMgr-->SaveProductConsultAnswer-->" + ex.Message, ex);
}
}
/// <summary>
/// 商品咨詢列表查詢
/// </summary>
/// <param name="store"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List<ProductConsultQuery> Query(ProductConsultQuery store, out int totalCount)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strCondition = new StringBuilder();
StringBuilder strSelect = new StringBuilder();
StringBuilder strTemp = new StringBuilder();
try
{
store.Replace4MySQL();
totalCount = 0;
strSelect.AppendFormat("select pc.consult_id,pc.product_id,p.product_name,mu.user_username as manage_name,pc.user_id,uc.user_email,uc.user_name,pc.consult_info,tp.parameterName,pc.consult_type,pc.consult_answer,pc.is_sendEmail,pc.create_date,pc.answer_date,pc.answer_user,pc.status,pc.consult_url,pc.product_url,pc.item_id,pc.answer_status,pc.delay_reason,p.prod_classify ");
strCondition.AppendFormat(" from product_consult pc left join product p on p.product_id=pc.product_id left join users uc on uc.user_id=pc.user_id ");
strCondition.AppendFormat(" left join (SELECT parameterName,parameterCode,parameterType from t_parametersrc where parameterType='consultType' ) tp on pc.consult_type=tp.parameterCode ");
strCondition.AppendFormat(" left join manage_user mu on mu.user_id=pc.answer_user ");
strCondition.AppendFormat(" where 1=1 ");
if (store.answer_status != 0)
{
strCondition.AppendFormat(" and answer_status={0} ", store.answer_status);
}
if (store.consult_id != 0)
{
strCondition.AppendFormat(" and pc.consult_id ={0} ", store.consult_id);
}
if (store.huifu ==1)
{
strCondition.AppendFormat(" and status={0} ", 1);
}
if (store.huifu == 2)
{
strCondition.AppendFormat(" and status={0} ", 0);
}
if (store.product_name != "")
{
strCondition.AppendFormat(" and p.product_name like '%{0}%'", store.product_name);
}
if (store.product_id != 0)
{
strCondition.AppendFormat(" and p.product_id ={0} ", store.product_id);
}
if (store.consultType != "")
{
strCondition.AppendFormat(" and pc.consult_type in ({0}) ", store.consultType);
}
if (store.user_email != "")
{
strCondition.AppendFormat(" and uc.user_email like '%{0}%' ", store.user_email);
}
if (store.user_name != "")
{
strCondition.AppendFormat(" and uc.user_name like '%{0}%' ", store.user_name);
}
if (store.productIds != "")
{
strCondition.AppendFormat(" and p.prod_classify ={0} ", store.productIds);
}
if (store.beginTime != DateTime.MinValue)
{
strCondition.AppendFormat(" and pc.create_date>='{0}' ", store.beginTime.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (store.endTime != DateTime.MinValue)
{
strCondition.AppendFormat(" and pc.create_date<='{0}' ", store.endTime.ToString("yyyy-MM-dd HH:mm:ss"));
}
StringBuilder strTotalCount = new StringBuilder(" select count(pc.consult_id) as totalCount ");
if (store.IsPage)
{
strSql.AppendFormat(strTotalCount.ToString());
strSql.AppendFormat(strCondition.ToString());
System.Data.DataTable _dt = _access.getDataTable(strSql.ToString());
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
}
strSql.AppendFormat(";");
strCondition.AppendFormat(" order by pc.consult_id desc ");
}
strTemp.AppendFormat(strSelect.ToString());
strTemp.AppendFormat(strCondition.ToString());
strTemp.AppendFormat(" limit {0},{1}", store.Start, store.Limit);
strTemp.AppendFormat(";");
strSql.AppendFormat(strTemp.ToString());
return _access.getDataTableForObj<ProductConsultQuery>(strTemp.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductConsultDao-->Query-->" + ex.Message + strSql.ToString(), ex);
}
}
/// <summary>
/// 查詢郵件群組的編號
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public DataTable QueryMailGroup(ProductConsultQuery query)
{
try
{
return _productConsultImplDao.QueryMailGroup(query);
}
catch (Exception ex)
{
throw new Exception("ProductConsultMgr-->QueryMailGroup-->" + ex.Message, ex);
}
}
/// <summary>
/// 更改諮詢類型
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateConsultType(ProductConsultQuery model)
{
string strSql = string.Empty;
try
{
strSql = string.Format("set sql_safe_updates = 0; update product_consult set consult_type='{0}' where consult_id='{1}'; set sql_safe_updates = 1;", model.consult_type, model.consult_id);
return _access.execCommand(strSql);
}
catch (Exception ex)
{
throw new Exception("ProductConsultDao-->UpdateConsultType-->" + ex.Message + strSql, ex);
}
}
/// <summary>
/// 查詢郵件群組的編號
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public DataTable QueryMailGroup(ProductConsultQuery query)
{
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat("select row_id from mail_group where group_code='{0}'", query.group_code);
return _access.getDataTable(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductConsultDao-->QueryMailGroup-->" + ex.Message + strSql.ToString(), ex);
}
}
/// <summary>
/// 回覆咨詢
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public int SaveProductConsultAnswer(ProductConsultQuery query)
{
StringBuilder strSql = new StringBuilder();
try
{
query.Replace4MySQL();
strSql.AppendFormat("set sql_safe_updates = 0; update product_consult set answer_date='{0}',consult_answer='{1}',answer_user='******',answer_status='{3}',status='{4}',is_sendEmail='{5}' where consult_id='{6}'; set sql_safe_updates = 1;", query.answer_date.ToString("yyyy-MM-dd HH:mm:ss"), query.consult_answer, query.answer_user, query.answer_status, query.status,query.is_sendEmail, query.consult_id);
return _access.execCommand(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductConsultDao-->SaveProductConsultAnswer-->" + ex.Message + strSql.ToString(), ex);
}
}
/// <summary>
/// 更改回覆狀態
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateAnswerStatus(ProductConsultQuery model)
{
string strSql = string.Empty;
try
{
strSql = string.Format("set sql_safe_updates = 0; update product_consult set answer_status='{0}',answer_user='******',delay_reason='{2}' where consult_id='{3}'; set sql_safe_updates = 1;", model.answer_status, model.answer_user, model.delay_reason, model.consult_id);
return _access.execCommand(strSql);
}
catch (Exception ex)
{
throw new Exception("ProductConsultDao-->UpdateAnswerStatus-->" + ex.Message + strSql, ex);
}
}
/// <summary>
/// 查詢商品信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ProductConsultQuery GetProductInfo(ProductConsultQuery query)
{
StringBuilder strSql = new StringBuilder();
try
{
if (query.item_id == 0)
{
strSql.AppendFormat("SELECT vb.brand_name,p.product_name,p.product_image,pm.price ,pm.event_price ,pm.event_start,pm.event_end FROM price_master pm LEFT JOIN product p ON pm.product_id=p.product_id LEFT JOIN vendor_brand vb on vb.brand_id=p.brand_id WHERE pm.product_id ='{0}' AND pm.site_id = 1 AND (pm.child_id = pm.product_id or pm.child_id = 0)AND pm.user_level = 1", query.product_id);
}
else
{
strSql.AppendFormat("SELECT vb.brand_name,p.product_name,ps1.spec_name as spec_name1,ps2.spec_name as spec_name2,ps1.spec_image as product_image1,ps2.spec_image as product_image2,p.product_image,ip.item_money,ip.event_money,pm.event_start,pm.event_end FROM product_item pit LEFT JOIN product p ON pit.product_id = p.product_id LEFT JOIN product_spec ps1 on ps1.spec_id=pit.spec_id_1 LEFT JOIN product_spec ps2 on ps2.spec_id=pit.spec_id_2 LEFT JOIN price_master pm ON p.product_id = pm.product_id LEFT JOIN item_price ip ON ip.price_master_id = pm.price_master_id LEFT JOIN vendor_brand vb on vb.brand_id=p.brand_id WHERE 1=1 AND pm.price_status = 1 AND pit.item_id = {0} AND pm.site_id = 1 AND pm.user_level = 1 AND ip.price_master_id = pm.price_master_id AND ip.item_id = {0} and p.product_id={1}", query.item_id, query.product_id);
}
return _access.getSinggleObj<ProductConsultQuery>(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductConsultDao-->GetProductInfo-->" + ex.Message + strSql.ToString(), ex);
}
}
public HttpResponseBase GetProductConsultList()
{
List<ProductConsultQuery> store = new List<ProductConsultQuery>();
string json = string.Empty;
string str = string.Empty;
try
{
ProductConsultQuery query = new ProductConsultQuery();
_productconsultMgr = new ProductConsultMgr(mySqlConnectionString);
query.Start = Convert.ToInt32(Request["Start"] ?? "0");
if (!string.IsNullOrEmpty(Request["Limit"]))
{
query.Limit = Convert.ToInt32(Request["Limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["ddlSel"]))
{
query.answer_status = Convert.ToInt32(Request.Params["ddlSel"]);
}
if (!string.IsNullOrEmpty(Request.Params["huifu"]))
{
query.huifu = Convert.ToInt32(Request.Params["huifu"]);
}
if (!string.IsNullOrEmpty(Request.Params["productName"]))
{
query.product_name = Request.Params["productName"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["productId"]))
{
query.product_id = Convert.ToUInt32(Request.Params["productId"]);
}
if (Convert.ToBoolean(Request.Params["consultType1"]))
{
query.consultType += "1,";
}
if (Convert.ToBoolean(Request.Params["consultType2"]))
{
query.consultType += "2,";
}
if (Convert.ToBoolean(Request.Params["consultType3"]))
{
query.consultType += "3,";
}
if (Convert.ToBoolean(Request.Params["consultType4"]))
{
query.consultType += "4,";
}
if (Convert.ToBoolean(Request.Params["consultType5"]))
{
query.consultType += "5,";
}
if (query.consultType != "")
{
query.consultType = query.consultType.Remove(query.consultType.LastIndexOf(","));
}
if (!string.IsNullOrEmpty(Request.Params["userName"]))
{
query.user_name = Request.Params["userName"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["userEmail"]))
{
query.user_email = Request.Params["userEmail"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["timestart"]))
{
query.beginTime = Convert.ToDateTime(Convert.ToDateTime(Request.Params["timestart"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["timeend"]))
{
query.endTime = Convert.ToDateTime(Convert.ToDateTime(Request.Params["timeend"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (Convert.ToBoolean(Request.Params["shopClass1"]) && Convert.ToBoolean(Request.Params["shopClass2"]))
{
}
else
{
if (Convert.ToBoolean(Request.Params["shopClass1"]))
{
query.productIds = "10";//食品館
}
if (Convert.ToBoolean(Request.Params["shopClass2"]))
{
query.productIds = "20";//用品館
}
}
if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆
{
query.consult_id = Convert.ToInt32(Request.Params["relation_id"]);
}
int totalCount = 0;
store = _productconsultMgr.Query(query, out totalCount);
if (Convert.ToBoolean(Request.Params["isSecret"]))
{
foreach (var item in store)
{
if (!string.IsNullOrEmpty(item.user_name))
{
item.user_name = item.user_name.Substring(0, 1) + "**";
}
item.user_email = item.user_email.Split('@')[0] + "@***";
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public HttpResponseBase SaveProductConsultAnswer()
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig Mail_From = _siteConfigMgr.GetConfigByName("Mail_From");
SiteConfig Mail_Host = _siteConfigMgr.GetConfigByName("Mail_Host");
SiteConfig Mail_Port = _siteConfigMgr.GetConfigByName("Mail_Port");
SiteConfig Mail_UserName = _siteConfigMgr.GetConfigByName("Mail_UserName");
SiteConfig Mail_UserPasswd = _siteConfigMgr.GetConfigByName("Mail_UserPasswd");
string EmailFrom = Mail_From.Value;//發件人郵箱
string SmtpHost = Mail_Host.Value;//smtp服务器
string SmtpPort = Mail_Port.Value;//smtp服务器端口
string EmailUserName = Mail_UserName.Value;//郵箱登陸名
string EmailPassWord = Mail_UserPasswd.Value;//郵箱登陸密碼
string json = string.Empty;
string jsonStr = string.Empty;
ProductConsultQuery query = new ProductConsultQuery();
IAreaPactetImplMgr _iareaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
_productconsultMgr = new ProductConsultMgr(mySqlConnectionString);
try
{
if (!string.IsNullOrEmpty(Request.Params["consult_id"]))
{
query.consult_id = Convert.ToInt32(Request.Params["consult_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["answer_status"]))
{
if (Convert.ToInt32(Request.Params["answer_status"]) == 2)
{
query.answer_status = 2;
query.answer_user = ((Caller)Session["caller"]).user_id;
query.delay_reason = Request.Params["delay_reason"].ToString();
_productconsultMgr.UpdateAnswerStatus(query);
json = "{success:true}";
}
else
{
query.answer_status = 3;
if (!string.IsNullOrEmpty(Request.Params["status"]))
{
query.status = Convert.ToInt32(Request.Params["status"]);
}
if (!string.IsNullOrEmpty(Request.Params["is_sendEmail"]))
{
query.is_sendEmail = Convert.ToInt32(Request.Params["is_sendEmail"]);
}
if (!string.IsNullOrEmpty(Request.Params["consult_answer"]))
{
query.consult_answer = Request.Params["consult_answer"].ToString();
}
query.answer_date = DateTime.Now;
query.answer_user = ((Caller)Session["caller"]).user_id;
int i = _productconsultMgr.SaveProductConsultAnswer(query);
if (!string.IsNullOrEmpty(Request.Params["is_sendEmail"]))
{
int j = Convert.ToInt32(Request.Params["is_sendEmail"]);
if (j == 1 && i > 0)
{
string userName = string.Empty;
string product_name = string.Empty;
string consultInfo = string.Empty;
string answerInfo = string.Empty;
string consultUrl = string.Empty;
string productUrl = string.Empty;
string userEmail = string.Empty;
if (!string.IsNullOrEmpty(Request.Params["user_name"]))
{
userName = Request.Params["user_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["user_email"]))
{
userEmail = Request.Params["user_email"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["consult_info"]))
{
consultInfo = Request.Params["consult_info"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["consult_answer"]))
{
answerInfo = Request.Params["consult_answer"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["product_url"]))
{
productUrl = Request.Params["product_url"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
query.product_id = Convert.ToUInt32(Request.Params["product_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["consult_url"]))
{
consultUrl = Request.Params["consult_url"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["item_id"]))
{
query.item_id = Convert.ToInt32(Request.Params["item_id"].ToString());
}
ProductConsultQuery queryTemp = _productconsultMgr.GetProductInfo(query);
FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/productConsultAnwser.html"), FileMode.OpenOrCreate, FileAccess.Read);
StreamReader sr = new StreamReader(fs, Encoding.UTF8);
string strTemp = sr.ReadToEnd();
sr.Close();
fs.Close();
//if (queryTemp.spec_name1 == "" && queryTemp.spec_name2 == "")
//{
// product_name = queryTemp.brand_name + queryTemp.product_name;
//}
//else
//{
// product_name = queryTemp.brand_name + queryTemp.product_name + "(" + queryTemp.spec_name1 + " " + queryTemp.spec_name2 + ")";
//}
product_name = queryTemp.product_name;
strTemp = strTemp.Replace("{{$username$}}", userName);
strTemp = strTemp.Replace("{{$productName$}}", product_name);
strTemp = strTemp.Replace("{{$consultInfo$}}", consultInfo);
strTemp = strTemp.Replace("{{$consultAnwser$}}", answerInfo);
strTemp = strTemp.Replace("{{$productUrl$}}", productUrl);
sendmail(EmailFrom, FromName, userEmail, userName, EmailTile, strTemp, "", SmtpHost, Convert.ToInt32(SmtpPort), EmailUserName, EmailPassWord);
}
}
if (i > 0)
{
json = "{success:true}";
}
}
}
}
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:true,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 更改活動使用狀態
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult UpdateActive()
{
string jsonStr = string.Empty;
try
{
ProductConsultQuery model = new ProductConsultQuery();
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
model.status = Convert.ToInt32(Request.Params["active"]);
}
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
model.consult_id = Convert.ToInt32(Request.Params["id"]);
}
_productconsultMgr = new ProductConsultMgr(mySqlConnectionString);
if (_productconsultMgr.UpdateActive(model) > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
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);
return Json(new { success = "false" });
}
}
public HttpResponseBase SendMailByGroup()
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig Food_Product_Consult = _siteConfigMgr.GetConfigByName("Food_Product_Consult");
SiteConfig Use_Product_Consult = _siteConfigMgr.GetConfigByName("Use_Product_Consult");
SiteConfig Other_Product_Consult = _siteConfigMgr.GetConfigByName("Other_Product_Consult");
string jsonStr = String.Empty;
ProductConsultQuery query = new ProductConsultQuery();
_productconsultMgr = new ProductConsultMgr(mySqlConnectionString);
try
{
if (!string.IsNullOrEmpty(Request["zixunType"]))
{
query.consult_type = Convert.ToInt32(Request["zixunType"]);
}
switch (query.consult_type)
{
case 1:
query.consultType = "商品諮詢";
break;
case 2:
query.consultType = "庫存及配送";
break;
case 3:
query.consultType = "支付問題";
break;
case 4:
query.consultType = "發票及保修";
break;
case 5:
query.consultType = "促銷及贈品";
break;
}
if (!string.IsNullOrEmpty(Request.Params["ckShopClass"]))
{
query.ckShopClass = Request.Params["ckShopClass"].ToString();
}
if (!string.IsNullOrEmpty(Request["consult_id"]))
{
query.consult_id = Convert.ToInt32(Request["consult_id"]);
}
if (!string.IsNullOrEmpty(Request["consult_info"]))
{
query.consult_info = Request["consult_info"].ToString();
}
if (!string.IsNullOrEmpty(Request["user_name"]))
{
query.user_name = Request["user_name"].ToString();
}
if (!string.IsNullOrEmpty(Request["create_date"]))
{
query.create_date = Convert.ToDateTime(Request["create_date"]);
}
FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/productConsultKeFu.html"), FileMode.OpenOrCreate, FileAccess.Read);
StreamReader sr = new StreamReader(fs, Encoding.UTF8);
string strTemp = sr.ReadToEnd();
sr.Close();
fs.Close();
strTemp = strTemp.Replace("{{$s_username$}}", query.user_name);
strTemp = strTemp.Replace("{{$s_datetime$}}", query.create_date.ToString());
strTemp = strTemp.Replace("{{$consultInfo$}}", query.consult_info);
strTemp = strTemp.Replace("{{$consultType$}}", query.consultType);
if (query.ckShopClass == "ckShopClass1" && query.consult_type == 1)//食品館商品諮詢
{
query.group_code = Food_Product_Consult.Value.ToString();
}
if (query.ckShopClass == "ckShopClass2" && query.consult_type == 1)//用品館商品諮詢
{
query.group_code = Use_Product_Consult.Value.ToString();
}
if (query.consult_type != 1)//其他諮詢類型問題
{
query.group_code = Other_Product_Consult.Value.ToString();
}
int i = _productconsultMgr.UpdateConsultType(query);
if (i > 0)
{
DataTable dt = _productconsultMgr.QueryMailGroup(query);
MailHelper mHelper = new MailHelper();
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
if (!string.IsNullOrEmpty(dt.Rows[j]["row_id"].ToString()))
{
mHelper.SendToGroup(Convert.ToInt32(dt.Rows[j]["row_id"]), "吉甲地市集【商品諮詢】通知信", strTemp.ToString(), true, true);
}
}
}
}
jsonStr = "{success:true }";
}
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);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
