public List<ProdVdReqQuery> QueryProdVdReqList(ProdVdReqQuery query, out int totalCount)
{
try
{
return _prodVbReqdao.QueryProdVdReqList(query, out totalCount);
}
catch (Exception ex)
{
throw new Exception("ProdVdReqMgr.QueryProdVdReqList-->" + ex.Message, ex);
}
}
public HttpResponseBase ProductDown()
{
string json = "{success:true}";
_prodVdReq = new ProdVdReqMgr(connectionString);
_productMgr = new ProductMgr(connectionString);
try
{
if (!string.IsNullOrEmpty(Request.Form["Product_Id"]))
{
string[] pro_Ids = Request.Form["Product_Id"].Split('|');
BLL.gigade.Model.Vendor vendor = Session["vendor"] as BLL.gigade.Model.Vendor;
uint product_end = 0;
string dtime = CommonFunction.DateTimeToString(Convert.ToDateTime(DateTime.Now.ToString()));
var explain = Request.Form["explain"] ?? "";
if (!string.IsNullOrEmpty(Request.Form["Product_End"]))
{
dtime = CommonFunction.DateTimeToString(Convert.ToDateTime(Request.Form["Product_End"].ToString()));
product_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Form["Product_End"]));
}
foreach (string str in pro_Ids.Distinct())
{
if (!string.IsNullOrEmpty(str))
{
uint product_id = uint.Parse(str);
Product pro = _productMgr.Query(new Product { Product_Id = product_id }).FirstOrDefault();
if (product_end == 0)//說明是立即下架,就用原來的時間
{
product_end = pro.Product_End;
}
if (pro != null && pro.Product_Status == 5)// && pro.user_id == (Session["caller"] as Caller).user_id
{
ProdVdReqQuery prodQuery = new ProdVdReqQuery();
prodQuery.vendor_id = Convert.ToInt32(vendor.vendor_id);
prodQuery.product_id = Convert.ToInt32(product_id);
prodQuery.req_status = 1;
int totalCount = 0;
ProdVdReq prodRquery = _prodVdReq.QueryProdVdReqList(prodQuery, out totalCount).FirstOrDefault();
if (prodRquery == null)
{
prodRquery = new ProdVdReq();
prodRquery.vendor_id = Convert.ToInt32(vendor.vendor_id);
prodRquery.product_id = Convert.ToInt32(product_id);
prodRquery.req_status = 1;
prodRquery.req_datatime = Convert.ToDateTime(dtime);
prodRquery.req_type = 2;
prodRquery.explain = explain + dtime;
if (_prodVdReq.Insert(prodRquery) < 0)
{
json = "{success:false,msg:0}";//返回json數據
}
}
else
{
prodRquery.vendor_id = Convert.ToInt32(vendor.vendor_id);
prodRquery.product_id = Convert.ToInt32(product_id);
prodRquery.req_status = 1;
prodRquery.req_datatime = Convert.ToDateTime(dtime);
prodRquery.req_type = 2;
prodRquery.explain = explain + dtime;
if (_prodVdReq.Update(prodRquery) < 0)
{
json = "{success:false,msg:0}";//返回json數據
}
}
}
}
}
}
//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:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase ProductUp()
{
string json = "{success:true}";
BLL.gigade.Model.Vendor vendor = Session["vendor"] as BLL.gigade.Model.Vendor;
_prodVdReq = new ProdVdReqMgr(connectionString);
_productMgr = new ProductMgr(connectionString);
try
{
if (!string.IsNullOrEmpty(Request.Form["Product_Id"]))
{
string[] pro_Ids = Request.Form["Product_Id"].Split('|');
foreach (string str in pro_Ids.Distinct())
{
if (!string.IsNullOrEmpty(str))
{
uint product_id = uint.Parse(str);
Product pro = _productMgr.Query(new Product { Product_Id = product_id }).FirstOrDefault();
if (pro != null && pro.Product_Status != 5)
{
ProdVdReqQuery prodQuery = new ProdVdReqQuery();
prodQuery.vendor_id = Convert.ToInt32(vendor.vendor_id);
prodQuery.product_id = Convert.ToInt32(product_id);
prodQuery.req_status = 1;
int totalCount = 0;
ProdVdReq prodRquery = _prodVdReq.QueryProdVdReqList(prodQuery, out totalCount).FirstOrDefault();
if (prodRquery == null)
{
prodRquery = new ProdVdReq();
prodRquery.vendor_id = Convert.ToInt32(vendor.vendor_id);
prodRquery.product_id = Convert.ToInt32(product_id);
prodRquery.req_status = 1;
prodRquery.req_datatime = DateTime.Now;
prodRquery.req_type = 1;
if (_prodVdReq.Insert(prodRquery) < 0)
{
json = "{success:false,msg:0}";//返回json數據
}
}
else
{
prodRquery.vendor_id = Convert.ToInt32(vendor.vendor_id);
prodRquery.product_id = Convert.ToInt32(product_id);
prodRquery.req_status = 1;
prodRquery.req_datatime = DateTime.Now;
prodRquery.req_type = 1;
if (_prodVdReq.Update(prodRquery) < 0)
{
json = "{success:false,msg:0}";//返回json數據
}
}
}
}
}
}
//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:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<ProdVdReqQuery> QueryProdVdReqList(ProdVdReqQuery query, out int totalCount)
{
StringBuilder sql = new StringBuilder();
try
{
query.Replace4MySQL();
StringBuilder strCols = new StringBuilder("select pvr.rid,pvr.vendor_id,v.vendor_name_full,v.vendor_name_simple as vendor_name, ");
strCols.Append("pvr.product_id,p.product_name,p.product_status,psta.parameterName as statusName,p.brand_id,vb.brand_name,");
strCols.Append(" pvr.req_status,pvr.req_datatime,pvr.`explain`, ");
strCols.Append("pvr.req_type, pvr.user_id,u.user_name,pvr.reply_note, ");
strCols.AppendFormat(" pvr.reply_datetime ");
StringBuilder strTbls = new StringBuilder(" from prod_vd_req pvr ");
strTbls.Append(" LEFT JOIN vendor v on v.vendor_id=pvr.vendor_id ");
strTbls.Append(" LEFT JOIN product p on p.product_id=pvr.product_id ");
strTbls.Append(" LEFT JOIN vendor_brand vb on vb.brand_id =p.brand_id and pvr.vendor_id=vb.vendor_id ");
strTbls.Append(" LEFT JOIN (select * from t_parametersrc tp where tp.parameterType ='product_status') psta on psta.parameterCode= p.product_status ");
strTbls.Append(" LEFT JOIN users u on u.user_id=pvr.user_id ");
StringBuilder strCondi = new StringBuilder(" where 1=1 ");
//if (!string.IsNullOrEmpty(query.vendor_name))
//{
// strCondi.AppendFormat(" and ( v.vendor_name_simple LIKE '%{0}%'", query.vendor_name);
// strCondi.AppendFormat(" OR v.vendor_name_simple LIKE '%{0}%' )", query.vendor_name);
//}
if (query.brand_id != 0)
{
strCondi.AppendFormat(" and p.brand_id ={0} ", query.brand_id);
}
if (query.rid != 0)
{
strCondi.AppendFormat(" and pvr.rid ={0} ", query.rid);
}
if (query.product_id != 0)
{
strCondi.AppendFormat(" and pvr.product_id ={0}", query.product_id);
}
if (query.req_status != 0)
{
strCondi.AppendFormat(" and pvr.req_status ={0}", query.req_status);
}
if (query.time_start != DateTime.MinValue)
{
strCondi.AppendFormat(" and pvr.req_datatime >='{0}'", CommonFunction.DateTimeToString(query.time_start));
}
if (query.time_end != DateTime.MinValue)
{
strCondi.AppendFormat(" and pvr.req_datatime <='{0}'", CommonFunction.DateTimeToString(query.time_end));
}
if (query.req_type != 0)
{
strCondi.AppendFormat(" and pvr.req_type ={0}", query.req_type);
}
string strCount = "select count(*) as totalCount " + strTbls.ToString() + strCondi.ToString();
sql.Append(strCount + ";");
System.Data.DataTable _dt = _dbAccess.getDataTable(strCount);
totalCount = 0;
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
}
strCondi.Append(" order by pvr.req_datatime desc ");
if (query.IsPage)
{
strCondi.AppendFormat(" limit {0},{1}", query.Start, query.Limit);
}
string sqlstr = strCols.ToString() + strTbls.ToString() + strCondi.ToString();
sql.Append(sqlstr + ";");
return _dbAccess.getDataTableForObj<ProdVdReqQuery>(sqlstr);
}
catch (Exception ex)
{
throw new Exception("ProdVdReqDao.QueryProdVdReqList-->" + ex.Message + sql.ToString(), ex);
}
}
public HttpResponseBase ProdVdReqPass()
{
string resultStr = "{success:true}";
try
{
string rIdAndProdId = Request.Params["rIdAndProdId"];
string[] rIdAndProdIdS = rIdAndProdId.Split(';');
foreach (string item in rIdAndProdIdS)
{
var rid = item.Split(',')[0];
var product_id = item.Split(',')[1];
ProdVdReqQuery prodQuery = new ProdVdReqQuery();
prodQuery.rid = int.Parse(rid);
prodQuery.product_id = int.Parse(product_id);
int totalCount = 0;
ProdVdReq prodRquery = _prodVdReq.QueryProdVdReqList(prodQuery, out totalCount).FirstOrDefault();
_prodMgr = new ProductMgr(connectionString);
Product p = _prodMgr.Query(new Product { Product_Id = Convert.ToUInt32(prodRquery.product_id) }).FirstOrDefault();
if (p.Product_Status != 5 && prodRquery.req_type == 1)
{
resultStr = "{success:false,msg:\"" + "請先核可商品狀態,以完成上下架申請" + "\"}";//返回json數據
break;
}
else if (p.Product_Status != 6 && prodRquery.req_type == 2)
{
resultStr = "{success:false,msg:\"" + "請先核可商品狀態,以完成上下架申請" + "\"}";//返回json數據
break;
}
else
{
prodRquery.req_status = 2;
prodRquery.reply_datetime = DateTime.Now;
prodRquery.user_id = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
if (_prodVdReq.Update(prodRquery) < 0)
{
resultStr = "{success:false,msg'" + Resources.Product.SAVE_FAIL + "'}";
}
}
}
//resultStr = "{success:true,msg'" + Resources.Product.SAVE_SUCCESS + "'}";
}
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);
resultStr = "{success:false,msg'" + Resources.Product.SAVE_FAIL + "'}";
}
Response.Clear();
Response.Write(resultStr);
Response.End();
return this.Response;
}
public HttpResponseBase ProdVdReqBack()
{
string resultStr = "{success:true}";
try
{
string rIdAndProdId = Request.Params["rIdAndProdId"];
string[] rIdAndProdIdS = rIdAndProdId.Split(';');
string backReason = Request.Params["backReason"];
foreach (string item in rIdAndProdIdS)
{
var rid = item.Split(',')[0];
var product_id = item.Split(',')[1];
ProdVdReqQuery prodQuery = new ProdVdReqQuery();
prodQuery.rid = int.Parse(rid);
prodQuery.product_id = int.Parse(product_id);
int totalCount = 0;
ProdVdReq prodRquery = _prodVdReq.QueryProdVdReqList(prodQuery, out totalCount).FirstOrDefault();
if (prodRquery != null)
{
//prodQuery.rid = int.Parse(rid);
//prodQuery.product_id = int.Parse(product_id);
prodRquery.req_status = 3;
prodRquery.reply_note = backReason;
prodRquery.reply_datetime = DateTime.Now;
prodRquery.user_id = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
if (_prodVdReq.Update(prodRquery) < 0)
{
resultStr = "{success:false,msg:0}";//返回json數據
}
}
else
{
resultStr = "{success:false,msg:0}";//返回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);
}
Response.Clear();
Response.Write(resultStr);
Response.End();
return this.Response;
}
public HttpResponseBase ProdVdReqListQuery()
{
string json = string.Empty;
try
{
ProdVdReqQuery query = new ProdVdReqQuery();
#region 查询条件填充
query.IsPage = true;
query.Start = int.Parse(Request.Form["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Form["limit"]))
{
query.Limit = Convert.ToInt32(Request.Form["limit"]);
}
if (!string.IsNullOrEmpty(Request.Form["brand_id"]))
{
query.brand_id = Convert.ToUInt32(Request.Form["brand_id"]);
}
if (!string.IsNullOrEmpty(Request.Form["product_id"]))
{
query.product_id = int.Parse(Request.Form["product_id"]);
}
if (!string.IsNullOrEmpty(Request.Form["req_status"]))
{
query.req_status = int.Parse(Request.Form["req_status"]);
}
if (!string.IsNullOrEmpty(Request.Form["time_start"]))
{
query.time_start = Convert.ToDateTime(Convert.ToDateTime(Request.Form["time_start"]).ToString("yyyy/MM/dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Form["time_end"]))
{
query.time_end = Convert.ToDateTime(Convert.ToDateTime(Request.Form["time_end"]).ToString("yyyy/MM/dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Form["req_type"]))
{
query.req_type = int.Parse(Request.Form["req_type"]);
}
#endregion
_prodVdReq = new ProdVdReqMgr(connectionString);
int totalCount = 0;
List<ProdVdReqQuery> pros = _prodVdReq.QueryProdVdReqList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{succes:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(pros, 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 = "{succes:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}