public int Add(Model.Promotion Model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert Promotion(UniqueID,ClientID,LogisticsCode,Operator,BrokerageRatio,State,Remark)");
strSql.Append(" values (");
strSql.Append("@UniqueID,@ClientID,@LogisticsCode,@Operator,@BrokerageRatio,@State,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@UniqueID", SqlDbType.UniqueIdentifier),
new SqlParameter("@ClientID", SqlDbType.Int, 8),
new SqlParameter("@LogisticsCode", SqlDbType.VarChar, 250),
new SqlParameter("@Operator", SqlDbType.Int, 8),
new SqlParameter("@BrokerageRatio", SqlDbType.Money),
new SqlParameter("@State", SqlDbType.Int, 8),
new SqlParameter("@Remark", SqlDbType.NText)
};
parameters[0].Value = Model.UniqueID;
parameters[1].Value = Model.ClientID;
parameters[2].Value = Model.LogisticsCode;
parameters[3].Value = Model.Operator;
parameters[4].Value = Model.BrokerageRatio;
parameters[5].Value = Model.State;
parameters[6].Value = Model.Remark;
object obj = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void BtnUpdate_Click(object sender, RoutedEventArgs e)
{
Model.Promotion promotionNew = new Model.Promotion();
if (id.Text == "")
{
MessageBox.Show("Vui lòng chọn mã trước khi cập nhật!!!");
return;
}
promotionNew.id = id.Text;
promotionNew.code = NamePromotion.Text;
promotionNew.value = int.Parse(valuePromotion.Text);
promotionNew.rule = rulePromotion.Text;
if (ActivePromotion.SelectedIndex == 0)
{
promotionNew.active = true;
}
else
{
promotionNew.active = false;
}
if (TypePromotion.SelectedIndex == 0)
{
promotionNew.type = "percent";
}
else
{
promotionNew.type = "value";
}
foreach (var item in Promotions)
{
if (item.code == NamePromotion.Text && item.id != id.Text)
{
MessageBox.Show("Mã khuyến mãi đã có!!!\n Bạn vui lòng chọn mã khác!");
return;
}
}
;
string result = API.UpdatePromotion(id.Text, promotionNew);
dynamic stuff = JsonConvert.DeserializeObject(result);
if (result == "")
{
return;
}
if (stuff.message == "successful")
{
MessageBox.Show("Cập nhật thông tin mã khuyến mãi thành công!!!");
Promotions.Clear();
Load();
LoadEmpty();
}
else
{
MessageBox.Show("Có lỗi sảy ra trong quá trình cập nhật, vui lòng thử lại!!!");
}
}
public bool Add(Model.Promotion Model, bool trans)
{
List <CommandInfo> sqllist = new List <CommandInfo>();
StringBuilder strSql1 = new StringBuilder();
strSql1.Append(" insert Promotion(UniqueID,LogisticsCode,Operator,BrokerageRatio,State,Remark,CreateTime)");
strSql1.Append(" values (");
strSql1.Append("@UniqueID,@LogisticsCode,@Operator,@BrokerageRatio,@State,@Remark,@CreateTime)");
SqlParameter[] parameters1 =
{
new SqlParameter("@UniqueID", SqlDbType.UniqueIdentifier),
new SqlParameter("@LogisticsCode", SqlDbType.VarChar, 250),
new SqlParameter("@Operator", SqlDbType.Int, 8),
new SqlParameter("@BrokerageRatio", SqlDbType.Money),
new SqlParameter("@State", SqlDbType.Int, 8),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters1[0].Value = Model.UniqueID;
parameters1[1].Value = Model.LogisticsCode;
parameters1[2].Value = Model.Operator;
parameters1[3].Value = Model.BrokerageRatio;
parameters1[4].Value = Model.State;
parameters1[5].Value = Model.Remark;
parameters1[6].Value = DateTime.Now;
CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1);
sqllist.Add(cmd);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append(" update barCode set state=3 where LogisticsCode=@LogisticsCode");
SqlParameter[] parameters2 = { new SqlParameter("@LogisticsCode", SqlDbType.VarChar, 250) };
parameters2[0].Value = Model.LogisticsCode;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
StringBuilder strSql3 = new StringBuilder();
strSql3.Append(" update Promotion set state=3 where LogisticsCode=@LogisticsCode");
SqlParameter[] parameters3 = { new SqlParameter("@LogisticsCode", SqlDbType.VarChar, 250) };
parameters3[0].Value = Model.LogisticsCode;
cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(cmd);
int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Add(Model.Promotion Model, bool trans)
{
return(dal.Add(Model, trans));
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public int Add(Model.Promotion Model)
{
return(dal.Add(Model));
}
private void ListViewPromotion_MouseUp(object sender, MouseButtonEventArgs e)
{
if (((ListView)sender).SelectedIndex == -1)
{
return;
}
if (((ListView)sender).ItemContainerGenerator.ContainerFromIndex(((ListView)sender).SelectedIndex) is ListViewItem lvi)
{
var bc = new BrushConverter();
for (int j = 0; j < Promotions.Count; j++)
{
ListViewItem lvi1 = ListViewPromotion.ItemContainerGenerator.ContainerFromIndex(j) as ListViewItem;
var cp1 = VisualTreeHelperExtensions.FindVisualChild <ContentPresenter>(lvi1);
var dt1 = cp1.ContentTemplate as DataTemplate;
var rt1 = (Rectangle)dt1.FindName("BackGround", cp1);
var tb1 = (TextBlock)dt1.FindName("NamePromotion", cp1);
rt1.Fill = Brushes.White;
}
var cp = VisualTreeHelperExtensions.FindVisualChild <ContentPresenter>(lvi);
var dt = cp.ContentTemplate as DataTemplate;
var rt = (Rectangle)dt.FindName("BackGround", cp);
var tb = (TextBlock)dt.FindName("NamePromotion", cp);
Model.Promotion promotionSelected = new Model.Promotion();
foreach (var item in Promotions)
{
if (item.code == tb.Text)
{
promotionSelected = item;
break;
}
}
;
NamePromotion.Text = promotionSelected.code;
valuePromotion.Text = promotionSelected.value.ToString();
if (promotionSelected.type == "percent")
{
TypePromotion.SelectedIndex = 0;
}
else
{
TypePromotion.SelectedIndex = 1;
}
rulePromotion.Text = promotionSelected.rule;
if (promotionSelected.active)
{
ActivePromotion.SelectedIndex = 0;
}
else
{
ActivePromotion.SelectedIndex = 1;
}
id.Text = promotionSelected.id;
btnUpdate.IsEnabled = true;
btnDelete.IsEnabled = true;
rt.Fill = (Brush)bc.ConvertFrom("#FF0BD9EE");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
List <Model.Promotion> list = new List <Model.Promotion>();
string type = context.Request.QueryString["type"];
BLL.Promotion bll = new BLL.Promotion();
BLL.BarCode bb = new BLL.BarCode();
switch (type)
{
case "one":
if (context.Request.QueryString["code"] == null || context.Request.QueryString["code"] == "undefined" || context.Request.QueryString["code"] == "")
{
if (context.Cache["key"] != null)
{
list = (List <Model.Promotion>)context.Cache["key"];
IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
context.Response.Write(JsonConvert.SerializeObject(list));
}
}
else
{
Model.manager adminmodel = context.Session[DTKeys.SESSION_ADMIN_INFO] as Model.manager;
Model.Promotion model = new Model.Promotion();
//model.ClientID = 0;
model.UniqueID = Guid.NewGuid();
model.LogisticsCode = context.Request.QueryString["code"];
model.Operator = adminmodel.id;
model.State = 3;
model.BrokerageRatio = 0;
model.CreateTime = Convert.ToDateTime(DateTime.Now);
model.Remark = string.Empty;
if (context.Cache["key"] == null)
{
list.Add(model);
context.Cache["key"] = list;
}
else
{
list = (List <Model.Promotion>)context.Cache["key"];
list.Add(model);
}
try
{
//if (bb.ExistsOut(context.Request.QueryString["code"]))
//{
if (bll.Add(model, true))
{
IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
context.Response.Write(JsonConvert.SerializeObject(list, timeFormat));
}
//}
}
catch (Exception)
{
}
}
break;
case "two":
Common.ComExcelHelper ch = new Common.ComExcelHelper();
DataTable dt = new DataTable();
dt = ch.ReadExcel2DataTable(context.Server.MapPath("/DownLoad/") + context.Request.QueryString["filename"], "nihao", "物流码");
dt.Rows.RemoveAt(0);
dt.Columns.Add("UniqueID", typeof(Guid));
//dt.Columns.Add("ClientID", typeof(Int32));
dt.Columns.Add("Operator", typeof(Int32));
dt.Columns.Add("CreateTime", typeof(DateTime));
dt.Columns.Add("State", typeof(Int32));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i][1] = Guid.NewGuid();
dt.Rows[i][2] = 1;
dt.Rows[i][3] = DateTime.Now;
dt.Rows[i][4] = 3;
if (dt.Rows[i][0] == null || dt.Rows[i][0].ToString() == "")
{
dt.Rows.RemoveAt(i);
}
}
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("UniqueID", "UniqueID");
//dic.Add("ClientID", "ClientID");
dic.Add("物流码", "LogisticsCode");
dic.Add("Operator", "Operator");
dic.Add("CreateTime", "CreateTime");
dic.Add("State", "State");
string json = "";
try
{
bll.Add(dt, "TempPromotion", dic);
}
catch (Exception)
{}
try
{
bll.Add(dt, "Promotion", dic);
IsoDateTimeConverter timeFormat2 = new IsoDateTimeConverter();
int total = dt.Rows.Count;
timeFormat2.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
dt = GetPagedTable(dt, Convert.ToInt32(context.Request.Form["page"]), Convert.ToInt32(context.Request.Form["rows"]));
json = JsonConvert.SerializeObject(dt, new DataTableConverter(), timeFormat2);
json = "{\"total\":" + "\"" + total + "\"" + ",\"rows\":" + json + "}";
}
catch (Exception)
{
json = "{\"total\":" + "\"0\"" + ",\"rows\":[]}";
}
finally
{
context.Response.Write(json);
}
break;
case "Three":
try
{
if (bb.ExistsOut(context.Request.QueryString["code"]))
{
context.Response.Write("true");
}
else
{
context.Response.Write("false");
}
}
catch (Exception)
{
}
break;
}
}
