/// <summary>
/// 修改reder_dail 表中的所有数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public string UpOrderDetail(OrderDetailQuery query)
{
query.Replace4MySQL();
StringBuilder strSql = new StringBuilder(@"update order_detail set ");
strSql.AppendFormat(" slave_id='{0}',item_id='{1}',item_vendor_id='{2}',product_freight_set='{3}',", query.Slave_Id, query.Item_Id, query.Item_Vendor_Id, query.Product_Freight_Set);
strSql.AppendFormat(" product_mode='{0}',single_price='{1}',product_spec_name='{2}',single_cost='{3}',", query.Product_Mode, query.Single_Price, query.Product_Spec_Name, query.Single_Cost);
strSql.AppendFormat(" event_cost='{0}',product_name='{1}',single_money='{2}',deduct_bonus='{3}',", query.Event_Cost, query.Product_Name, query.Single_Money, query.Deduct_Bonus);
strSql.AppendFormat(" deduct_welfare='{0}',deduct_happygo='{1}',deduct_happygo_money='{2}',", query.Deduct_Welfare, query.Deduct_Happygo, query.Deduct_Happygo_Money);
strSql.AppendFormat(" deduct_account='{0}',deduct_account_note='{1}',accumulated_bonus='{2}',", query.Deduct_Account, query.Deduct_Account_Note, query.Accumulated_Bonus);
strSql.AppendFormat(" accumulated_happygo='{0}',buy_num='{1}',detail_status='{2}',", query.Accumulated_Happygo, query.Buy_Num, query.Detail_Status);
strSql.AppendFormat(" delay_till='{0}',lastmile_deliver_serial='{1}',lastmile_deliver_datetime='{2}',", query.Delay_Till, query.Lastmile_Deliver_Serial, query.Lastmile_Deliver_Datetime);
strSql.AppendFormat(" lastmile_deliver_agency='{0}',bag_check_money='{1}',channel_detail_id='{2}',", query.Lastmile_Deliver_Agency, query.Bag_Check_Money, query.Channel_Detail_Id);
strSql.AppendFormat(" combined_mode='{0}',item_mode='{1}',parent_id='{2}',parent_name='{3}',", query.Combined_Mode, query.item_mode, query.Parent_Id, query.parent_name);
strSql.AppendFormat(" parent_num='{0}',price_master_id='{1}',pack_id='{2}',sub_order_id='{3}',", query.parent_num, query.price_master_id, query.pack_id, query.Sub_Order_Id);
strSql.AppendFormat(" site_id='{0}',event_id='{1}',prepaid='{2}' ", query.Site_Id, query.event_id, query.Prepaid);
strSql.AppendFormat(" where detail_id='{0}';", query.Detail_Id);
return strSql.ToString();
}
/// <summary>
/// 返回新增的sql 语句
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public string AddOrderDetail(OrderDetailQuery query)
{
query.Replace4MySQL();
StringBuilder strSql = new StringBuilder(@"insert into order_detail (detail_id,slave_id,item_id,item_vendor_id,product_freight_set,product_mode,product_name,product_spec_name,single_cost,");
strSql.Append("event_cost,single_price,single_money,deduct_bonus,deduct_welfare,deduct_happygo,deduct_happygo_money,deduct_account,deduct_account_note,");
strSql.Append("accumulated_bonus,accumulated_happygo,buy_num,detail_status,detail_note,item_code,arrival_status,delay_till,lastmile_deliver_serial,");
strSql.Append("lastmile_deliver_datetime,lastmile_deliver_agency,bag_check_money,channel_detail_id,combined_mode,item_mode,parent_id,parent_name,parent_num,");
strSql.Append("price_master_id,pack_id,sub_order_id,site_id,event_id,prepaid) values(");
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.Detail_Id, query.Slave_Id, query.Item_Id, query.Item_Vendor_Id, query.Product_Freight_Set);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.Product_Mode, query.Product_Name, query.Product_Spec_Name, query.Single_Cost, query.Event_Cost);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.Single_Price, query.Single_Money, query.Deduct_Bonus, query.Deduct_Welfare, query.Deduct_Happygo);
strSql.AppendFormat("'{0}','{1}','{2}','{3}',", query.Deduct_Happygo_Money, query.Deduct_Account, query.Deduct_Account_Note, query.Accumulated_Bonus);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.Accumulated_Happygo, query.Buy_Num, query.Detail_Status, query.Detail_Note, query.Item_Code);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.Arrival_Status, query.Delay_Till, query.Lastmile_Deliver_Serial, query.Lastmile_Deliver_Datetime, query.Lastmile_Deliver_Agency);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.Bag_Check_Money, query.Channel_Detail_Id, query.Combined_Mode, query.item_mode, query.Parent_Id);
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.parent_name, query.parent_num, query.price_master_id, query.pack_id, query.Sub_Order_Id);
strSql.AppendFormat("'{0}','{1}','{2}');", query.Site_Id, query.event_id, query.Prepaid);
return strSql.ToString();
}
