/// <summary>
/// 查詢超商店家
/// </summary>
/// <param name="store">Store Model</param>
/// <param name="status">店家狀態</param>
/// <returns>Store Model List</returns>
public List<DeliveryStoreQuery> Query(DeliveryStore store, out int totalCount)
{
store.Replace4MySQL();
StringBuilder tempStr = new StringBuilder("select delivery_store.rowid,delivery_store_id,a.parametername as delivery_store_name,big,bigcode,middle,middlecode,");
tempStr.Append("small,smallcode,store_id,store_name,address,phone,status from delivery_store left join ");
tempStr.Append(" (select parametercode,parametername from t_parametersrc where parametertype='deliver_store') a on ");
tempStr.Append("delivery_store.delivery_store_id=a.parametercode where 1=1");
if (store.delivery_store_id != 0)
{
tempStr.AppendFormat(" and delivery_store_id = {0}", store.delivery_store_id); ;
}
if (store.status != 0)
{
tempStr.AppendFormat(" and status = {0}", store.status);
}
totalCount = 0;
if (store.IsPage)
{
System.Data.DataTable _dt = _access.getDataTable(tempStr.ToString());
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = _dt.Rows.Count;
}
tempStr.AppendFormat(" limit {0},{1}", store.Start, store.Limit);
}
return _access.getDataTableForObj<DeliveryStoreQuery>(tempStr.ToString());
}
public int Save(DeliveryStore store)
{
store.Replace4MySQL();
StringBuilder strSql = new StringBuilder("insert into delivery_store(`delivery_store_id`,`big`,`bigcode`,`middle`,`middlecode`,`small`,`smallcode`,`store_id`,`store_name`,");
strSql.AppendFormat("`address`,`phone`,`status`)values({0},'{1}','{2}','{3}','{4}',",store.delivery_store_id,store.big,store.bigcode,store.middle,store.middlecode);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}',{6})", store.small, store.smallcode, store.store_id, store.store_name, store.address, store.phone, store.status);
return _access.execCommand(strSql.ToString());
}
public int Update(DeliveryStore store)
{
store.Replace4MySQL();
StringBuilder strSql = new StringBuilder("update delivery_store set ");
strSql.AppendFormat("delivery_store_id={0},big='{1}',bigcode='{2}',middle='{3}',middlecode='{4}',", store.delivery_store_id, store.big, store.bigcode, store.middle, store.middlecode);
strSql.AppendFormat("small='{0}',smallcode='{1}',store_id='{2}',store_name='{3}',address='{4}',", store.small, store.smallcode,store.store_id, store.store_name, store.address);
strSql.AppendFormat("phone='{0}',status={1} where rowid={2}", store.phone, store.status, store.rowid);
return _access.execCommand(strSql.ToString());
}
public List<DeliveryStoreQuery> Query(DeliveryStore store, out int totalCount)
{
try
{
return _deliveryDao.Query(store, out totalCount);
}
catch (Exception ex)
{
throw new Exception("DeliveryStoreMgr-->Query-->" + ex.Message, ex);
}
}
public int Update(DeliveryStore store)
{
try
{
return _deliveryDao.Update(store);
}
catch (Exception ex)
{
throw new Exception("DeliveryStoreMgr-->Update-->" + ex.Message, ex);
}
}
public int Save(DeliveryStore store)
{
try
{
return _deliveryDao.Save(store);
}
catch (Exception ex)
{
throw new Exception("DeliveryStoreMgr-->SingleCompareSave-->" + ex.Message, ex);
}
}
public JsonResult GetSuperStore()
{
IDeliveryStoreImplMgr _deliveryMgr = new DeliveryStoreMgr(connectionString);
JsonResult result = null;
int storeId = 0;
int.TryParse(Request.Params["storeId"] ?? "0", out storeId);
DeliveryStore store = new DeliveryStore();
store.delivery_store_id = storeId;
store.IsPage = false;
int count = 0;
try
{
if (storeId != 0)
{
result = Json(_deliveryMgr.Query(store, out count));
}
}
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 result;
}
public HttpResponseBase SaveDeliveryStore()
{
DeliveryStore store = new DeliveryStore();
string json = "{success:false}";
try
{
#region 填充實體
if (!string.IsNullOrEmpty(Request.Form["delivery_store_id"]))
{
store.delivery_store_id = Convert.ToInt32(Request.Form["delivery_store_id"]);
}
if (!string.IsNullOrEmpty(Request.Form["BigText"]))
{
store.big = Request.Form["BigText"];
}
if (!string.IsNullOrEmpty(Request.Form["bigcode"]))
{
store.bigcode = Request.Form["bigcode"];
}
if (!string.IsNullOrEmpty(Request.Form["MiddleText"]))
{
store.middle = Request.Form["MiddleText"];
}
if (!string.IsNullOrEmpty(Request.Form["middlecode"]))
{
store.middlecode = Request.Form["middlecode"];
}
if (!string.IsNullOrEmpty(Request.Form["smallcode"]))
{
string[] small = Request.Form["smallcode"].Split('/');
store.small = small[1];
store.smallcode = small[0];
}
if (!string.IsNullOrEmpty(Request.Form["store_id"]))
{
store.store_id = Request.Form["store_id"];
}
if (!string.IsNullOrEmpty(Request.Form["store_name"]))
{
store.store_name = Request.Form["store_name"];
}
if (!string.IsNullOrEmpty(Request.Form["address"]))
{
store.address = Request.Form["address"];
}
if (!string.IsNullOrEmpty(Request.Form["phone"]))
{
store.phone = Request.Form["phone"];
}
if (!string.IsNullOrEmpty(Request.Form["status"]))
{
store.status = Convert.ToInt32(Request.Form["status"]);
}
#endregion
deliveryStoreMgr = new DeliveryStoreMgr(connectionString);
if (!string.IsNullOrEmpty(Request.Form["rowid"]))
{
store.rowid = Convert.ToInt32(Request.Form["rowid"]);
if (deliveryStoreMgr.Update(store) > 0)
{
json = "{success:true}";
}
}
else
{
if (deliveryStoreMgr.Save(store) > 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:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase QueryDeliveryStore()
{
List<DeliveryStoreQuery> stores = new List<DeliveryStoreQuery>();
string json = string.Empty;
try
{
DeliveryStore query = new DeliveryStore();
query.Start = Convert.ToInt32(Request.Form["start"] ?? "0");
query.status = 0;
if (!string.IsNullOrEmpty(Request.Form["limit"]))
{
query.Limit = Convert.ToInt32(Request.Form["limit"]);
}
if (!string.IsNullOrEmpty(Request.Form["Delivery"]))
{
query.delivery_store_id = Convert.ToInt32(Request.Form["Delivery"]);
}
if (!string.IsNullOrEmpty(Request.Form["Status"]))
{
query.status = Convert.ToInt32(Request.Form["Status"]);
}
deliveryStoreMgr = new DeliveryStoreMgr(connectionString);
int totalCount = 0;
stores = deliveryStoreMgr.Query(query, out totalCount);
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores) + "}";
}
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;
}