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