/// <summary>
/// 新增promotionsamountfare的sql語句，用於事物的調用
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string SavePromoFare(PromotionsAmountFare model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("insert into promotions_amount_fare (");
sql.AppendFormat("name,display,delivery_store,group_id,class_id,brand_id,category_id,product_id,type,amount,quantity,start,end,");
sql.AppendFormat("created,active,event_desc,event_type,condition_id,device,kuser,fare_percent,payment_code,off_times,url_by,site,modified,muser,status,vendor_coverage) values ");
sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',{14},'{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}');select @@identity;",
model.name, model.display, model.delivery_store, model.group_id, model.class_id, model.brand_id,
model.category_id, model.product_id, model.type, model.amount, model.quantity, CommonFunction.DateTimeToString(model.start),
CommonFunction.DateTimeToString(model.end),
CommonFunction.DateTimeToString(model.created),
model.active ? 1 : 0, model.event_desc, model.event_type,
model.condition_id, model.device, model.kuser,
model.fare_percent, model.payment_code, model.off_times,
model.url_by, model.site, CommonFunction.DateTimeToString(model.modified), model.muser, model.status, model.vendor_coverage);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountFareDao-->SavePromoFare-->" + ex.Message, ex);
}
}
/// <summary>
/// 根據編號獲取數據
/// </summary>
/// <param name="model">滿額滿件免運對象</param>
/// <returns>數據列表</returns>
public DataTable Select(PromotionsAmountFare model)
{
model.Replace4MySQL();
StringBuilder sb = new StringBuilder();
sb.Append(@" select id, name,display,delivery_store,group_id,class_id,brand_id,category_id,product_id,type,amount,quantity,start,end,
created,active,event_desc,event_type,condition_id,device,kuser,fare_percent,payment_code,off_times,url_by,
site,modified,muser,status,vendor_coverage from promotions_amount_fare where 1=1");
if (model.id != 0)
{
sb.AppendFormat(" and id='{0}';", model.id);
}
try
{
return _access.getDataTable(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountFareDao-->Select-->" + ex.Message + sb.ToString(), ex);
}
}
/// <summary>
/// 頁面的第一次保存,向product_category和promotionsAmountFare中新增基本數據并分別獲取category_id和id
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(PromotionsAmountFareQuery model)
{
model.Replace4MySQL();
int id = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
//#region 保存第一步到product_category 獲取prodduct_amount_fare的category_id
ProductCategory pmodel = new ProductCategory();
pmodel.category_name = model.name;
pmodel.category_createdate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_father_id = model.category_father_id;
pmodel.category_ipfrom = model.category_ipfrom;
pmodel.category_display = Convert.ToUInt32(model.status);
mySqlCmd.CommandText = _cateDao.SaveCategory(pmodel);
model.category_id = Convert.ToUInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 12;
serial.Serial_Value = Convert.ToUInt32(model.category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serial);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//#endregion
PromotionsAmountFare pfmodel = new PromotionsAmountFare();
pfmodel.name = model.name;
pfmodel.event_desc = model.event_desc;
pfmodel.vendor_coverage = model.vendor_coverage;
pfmodel.event_type = model.event_type;
pfmodel.kuser = model.kuser;
pfmodel.created = model.created;
pfmodel.active = model.active;
pfmodel.category_id = model.category_id;
pfmodel.status = model.status;
pfmodel.payment_code = model.payment_code;
mySqlCmd.CommandText = SavePromoFare(pfmodel);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromotionsAmountFareDao-->Save-->" + ex.Message, ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return id;
}
public HttpResponseBase FirstSaveFare()
{
string jsonStr = String.Empty;
try
{
PromotionsAmountFareQuery model = new PromotionsAmountFareQuery();
if (!string.IsNullOrEmpty(Request.Params["name"].ToString()))
{
model.name = Request.Params["name"].ToString();
}
else
{
model.name = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["desc"].ToString()))
{
model.event_desc = Request.Params["desc"].ToString();
}
else
{
model.event_desc = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"]))
{
model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString());
}
else
{
model.vendor_coverage = 0;
}
if (!string.IsNullOrEmpty(Request.Params["amount"].ToString()))
{
model.amount = Convert.ToInt32(Request.Params["amount"].ToString());
}
else
{
model.amount = 0;
}
if (!string.IsNullOrEmpty(Request.Params["quantity"].ToString()))
{
model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString());
}
else
{
model.quantity = 0;
}
if (!string.IsNullOrEmpty(Request.Params["fare_percent"].ToString()))
{
model.fare_percent = Convert.ToInt32(Request.Params["fare_percent"].ToString());
}
else
{
model.fare_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Params["off_times"].ToString()))
{
model.off_times = Convert.ToInt32(Request.Params["off_times"].ToString());
}
else
{
model.off_times = 0;
}
model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.created = DateTime.Now;
model.status = 0;
//獲取event_type和category_father_id
_parasrcMgr = new ParameterMgr(mySqlConnectionString);
List<Parametersrc> fatherIdResult = _parasrcMgr.QueryUsed(new Parametersrc { ParameterType = "event_type", parameterName = Request.Params["event_type"].ToString(), Used = 1 });
if (fatherIdResult.Count == 1)
{
model.event_type = fatherIdResult[0].ParameterCode;
model.category_father_id = Convert.ToUInt32(fatherIdResult[0].ParameterProperty);
}
model.category_ipfrom = Request.UserHostAddress;//獲取當前ip
_promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString);
PromotionsAmountFare query = new PromotionsAmountFare();
query.id = _promoAmountFareMgr.Save(model);
System.Data.DataTable dt = _promoAmountFareMgr.Select(query);
if (dt.Rows.Count > 0)
{
jsonStr = "{success:true,\"id\":\"" + dt.Rows[0]["id"] + "\",\"cateID\":\"" + dt.Rows[0]["category_id"] + "\",\"event_type\":\"" + dt.Rows[0]["event_type"] + "\"}";
}
else
{
jsonStr = "{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);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}