public ActionResult DeleteConfirmed(int id)
{
Tuan tuan = db.Tuans.Find(id);
db.Tuans.Remove(tuan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name")] Tuan tuan)
{
if (ModelState.IsValid)
{
db.Entry(tuan).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tuan));
}
public ActionResult Create([Bind(Include = "Id,Name")] Tuan tuan)
{
if (ModelState.IsValid)
{
db.Tuans.Add(tuan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tuan));
}
// GET: Tuans/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tuan tuan = db.Tuans.Find(id);
if (tuan == null)
{
return(HttpNotFound());
}
return(View(tuan));
}
void DieuChinh(string azs = "GiaNet")
{
if (bdtpTu.EditValue == null || bdtpDen.EditValue == null)
{
return;
}
DataTable dt = new DataTable();
for (int i = 0; i < GVTK.Bands.Count; i++)
{
if (!GVTK.Bands[i].Name.Equals("Gb1"))
{
GVTK.Bands.Remove(GVTK.Bands[i]); i--;
}
}
for (int i = 0; i < GVTK.Columns.Count; i++)
{
if (!"colDaiLy, colHang, colSale".Contains(GVTK.Columns[i].Name))
{
GVTK.GroupSummary.Remove(GVTK.GroupSummary[i - 3]);
GVTK.Columns.Remove(GVTK.Columns[i]);
}
}
DateTime startDate = ((DateTime)bdtpTu.EditValue).Date;
DateTime endDate = ((DateTime)bdtpDen.EditValue).Date;
var dates = Enumerable.Range(0, (int)(endDate - startDate).TotalDays + 1)
.Select(x => startDate.AddDays(x))
.ToList();
List <DateTime> Ngay = dates.ToList();
List <string> Nam;
List <string> Quy;
List <string> Thang;
List <string> Tuan;
List <string> ListTenCot = new List <string>();
string TenCot = string.Empty;
CultureInfo cul = CultureInfo.GetCultureInfo("vi-VN");
Nam = Ngay.Select(w => w.Year.ToString()).Distinct().AsEnumerable().Reverse().ToList();
Quy = Ngay.Select(w => (1 + (w.Month - 1) / 3) + "/" + w.Year).Distinct().AsEnumerable().Reverse().ToList();
Thang = Ngay.Select(w => w.Month + "/" + (1 + (w.Month - 1) / 3) + "/" + w.Year).Distinct().AsEnumerable().Reverse().ToList();
Tuan = Ngay.Select(w => cul.Calendar.GetWeekOfYear(w, CalendarWeekRule.FirstDay, DayOfWeek.Monday) + "/" + w.Year).Distinct().AsEnumerable().Reverse().ToList();
string TenCotTao = string.Empty;
string TenCotTao2 = string.Empty;
switch (_IDThoiGian)
{
case 0:
TenCotTao = "datepart(YEAR, NgayGD)";
TenCotTao2 = "datepart(YEAR, NgayGD)";
GridBand gridBand = new GridBand()
{
Caption = "Năm", Name = "Gb2", VisibleIndex = 1, Width = 225
};
GVTK.Bands.Add(gridBand);
foreach (string a in Nam)
{
TenCot = a;
ListTenCot.Add(TenCot);
dt.Columns.Add(TenCot, typeof(long));
BandedGridColumn bandedGridColumn = new BandedGridColumn()
{
Caption = $"-{a}-", FieldName = TenCot, Name = $"col{a}", Visible = true, Width = 50
};
bandedGridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bandedGridColumn.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bandedGridColumn.DisplayFormat.FormatString = "{0:#,##0;(#,##0)}";
bandedGridColumn.Summary.AddRange(new GridSummaryItem[] { new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, TenCot, "{0:#,##0;(#,##0)}") });
gridBand.Columns.Add(bandedGridColumn);
}
break;
case 1:
foreach (string a in Nam)
{
TenCotTao = "cast(datepart(QUARTER, NgayGD) as varchar)+cast(datepart(YEAR, NgayGD) as varchar)";
TenCotTao2 = "datepart(YEAR, NgayGD), datepart(QUARTER, NgayGD)";
GridBand gridBand1 = new GridBand()
{
Caption = $"-{a}-", Name = $"Gb{a}", VisibleIndex = 1, Width = 225
};
GVTK.Bands.Add(gridBand1);
List <string> _Quy = Quy.Where(w => w.Split('/')[1].Contains(a)).ToList();
foreach (string b in _Quy)
{
TenCot = b.Replace("/", string.Empty);
ListTenCot.Add(TenCot);
dt.Columns.Add(TenCot, typeof(long));
BandedGridColumn bandedGridColumn = new BandedGridColumn()
{
Caption = $"Quý {b.Split('/')[0]}", FieldName = TenCot, Name = $"col{b.Replace("/", string.Empty)}", Visible = true, Width = 50
};
bandedGridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bandedGridColumn.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bandedGridColumn.DisplayFormat.FormatString = "{0:#,##0;(#,##0)}";
bandedGridColumn.Summary.AddRange(new GridSummaryItem[] { new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, TenCot, "{0:#,##0;(#,##0)}") });
gridBand1.Columns.Add(bandedGridColumn);
}
}
break;
case 2:
foreach (string a in Nam)
{
TenCotTao = "cast(datepart(MONTH, NgayGD) as varchar)+cast(datepart(YEAR, NgayGD) as varchar)";
TenCotTao2 = "datepart(YEAR, NgayGD), datepart(MONTH, NgayGD)";
GridBand gridBand1 = new GridBand()
{
Caption = $"-{a}-", Name = $"Gb{a}", VisibleIndex = 1, Width = 225
};
GVTK.Bands.Add(gridBand1);
List <string> _Quy = Quy.Where(w => w.Contains(a)).ToList();
foreach (string b in _Quy)
{
GridBand gridBand2 = new GridBand()
{
Caption = $"Quý {b.Split('/')[0]}", Name = $"Gb{a}", VisibleIndex = 1, Width = 225
};
gridBand1.Children.Add(gridBand2);
List <string> _Thang = Thang.Where(w => w.Split('/')[2].Equals(a) && w.EndsWith(b)).ToList();
foreach (string c in _Thang)
{
TenCot = c.Replace($"/{b}", string.Empty) + a;
ListTenCot.Add(TenCot);
dt.Columns.Add(TenCot, typeof(long));
BandedGridColumn bandedGridColumn = new BandedGridColumn()
{
Caption = $"Tháng {c.Split('/')[0]}", FieldName = TenCot, Name = $"col{c.Replace("/", string.Empty)}", Visible = true, Width = 50
};
bandedGridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bandedGridColumn.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bandedGridColumn.DisplayFormat.FormatString = "{0:#,##0;(#,##0)}";
bandedGridColumn.Summary.AddRange(new GridSummaryItem[] { new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, TenCot, "{0:#,##0;(#,##0)}") });
gridBand2.Columns.Add(bandedGridColumn);
GVTK.GroupSummary.Add(new GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, bandedGridColumn.FieldName, bandedGridColumn, "{0:#,##0;(#,##0)}"));
}
}
}
break;
case 3:
foreach (string a in Nam)
{
TenCotTao = "cast(datepart(WEEK, NgayGD) as varchar)+cast(datepart(YEAR, NgayGD) as varchar)";
TenCotTao2 = "datepart(YEAR, NgayGD), datepart(WEEK, NgayGD)";
GridBand gridBand1 = new GridBand()
{
Caption = $"-{a}-", Name = $"Gb{a}", VisibleIndex = 1, Width = 225
};
GVTK.Bands.Add(gridBand1);
List <string> _Tuan = Tuan.Where(w => w.Split('/')[1].Contains(a)).ToList();
foreach (string b in _Tuan)
{
TenCot = b.Replace("/", string.Empty);
ListTenCot.Add(TenCot);
dt.Columns.Add(TenCot, typeof(long));
BandedGridColumn bandedGridColumn = new BandedGridColumn()
{
Caption = $"Tuần {b.Split('/')[0]}", FieldName = TenCot, Name = $"col{b.Replace("/", string.Empty)}", Visible = true, Width = 50
};
bandedGridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bandedGridColumn.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bandedGridColumn.DisplayFormat.FormatString = "{0:#,##0;(#,##0)}";
bandedGridColumn.Summary.AddRange(new GridSummaryItem[] { new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, TenCot, "{0:#,##0;(#,##0)}") });
gridBand1.Columns.Add(bandedGridColumn);
}
}
break;
}
string az = "";
if (barCheckItem2.Checked)
{
colHang.Visible = false;
az = string.Format(@"
SET DATEFIRST 1
select * from (
select IDKhachHang,dl.NVGiaoDich,{0} 'CotMoc',SUM({5}) Gia from GIAODICH
left join (select ID MaIDDL,NVGiaoDich from DAILY where LoaiKhachHang = 1) dl on IDKhachHang = MaIDDL where MaIDDL is not null and LoaiGiaoDich in ({6}) and CONVERT(date,NgayGD) between '{2}' and '{3}' group by {1} ,IDKhachHang ,dl.NVGiaoDich
) Y pivot (max(Gia) for CotMoc in ([{4}])) as pv
order by IDKhachHang", TenCotTao, TenCotTao2, startDate.ToString("yyyyMMdd"), endDate.ToString("yyyyMMdd"), String.Join("],[", ListTenCot.ToArray()), azs, azs == "GiaNet" ? "4" : "9");
}
else
{
colHang.Visible = true;
az = string.Format(@"
SET DATEFIRST 1
select * from (
select IDKhachHang,dl.NVGiaoDich,NhaCungCap,{0} 'CotMoc',SUM({5}) Gia from GIAODICH
left join (select ID MaIDDL,NVGiaoDich from DAILY where LoaiKhachHang = 1) dl on IDKhachHang = MaIDDL where MaIDDL is not null and LoaiGiaoDich in ({6}) and CONVERT(date,NgayGD) between '{2}' and '{3}' and coalesce(NhaCungCap,0)>0 group by {1} ,IDKhachHang,NhaCungCap ,dl.NVGiaoDich
) Y pivot (max(Gia) for CotMoc in ([{4}])) as pv
order by IDKhachHang,NhaCungCap", TenCotTao, TenCotTao2, startDate.ToString("yyyyMMdd"), endDate.ToString("yyyyMMdd"), String.Join("],[", ListTenCot.ToArray()), azs, azs == "GiaNet" ? "4" : "9");
}
dt = new D_GIAODICH().LayDataTable(az);
GCTK.DataSource = dt;
GVTK.BestFitColumns();
}
/// <summary>
/// 获取团
/// </summary>
/// <param name="loginUrl"></param>
/// <param name="tuanUrl"></param>
/// <returns></returns>
public static async Task GetTuanList(string loginUrl, string tuanUrl)
{
CookieContainer cookiescontainer = new CookieContainer();
var handler = new HttpClientHandler()
{
CookieContainer = cookiescontainer,
AllowAutoRedirect = true,
UseCookies = true
};
var httpClient = new HttpClient(handler);
var result = await httpClient.PostAsync(loginUrl, new FormUrlEncodedContent(Common.GetPostPara()));
if (result.IsSuccessStatusCode)
{
var parser = new HtmlParser();
var pageResult = await httpClient.GetStringAsync(tuanUrl);
var document = await parser.ParseAsync(pageResult);
var tbodys = document.QuerySelectorAll("tbody");
var trElements = tbodys[0].QuerySelectorAll("tr");
List <Tuan> tuanList = new List <Tuan>();
foreach (var item in trElements)
{
var teamTdNodes = item.QuerySelectorAll("td");
Tuan tuan = new Tuan
{
TuanId = item.GetAttribute("data-id"),
HeadImg = item.QuerySelector(".col-team").QuerySelector("img").GetAttribute("src"),
Name = item.QuerySelector(".cell").TextContent,
TuanType = teamTdNodes[2].QuerySelector(".cell").TextContent,
TuanRenShu = teamTdNodes[3].QuerySelector(".cell").TextContent,
TuanZhang = teamTdNodes[4].QuerySelector(".cell").TextContent,
FanLiType = teamTdNodes[5].QuerySelector(".cell").TextContent,
TotalAmount = teamTdNodes[6].QuerySelector(".cell").TextContent,
TotalSaleCount = teamTdNodes[7].QuerySelector(".cell").TextContent,
TuanCreateTime = teamTdNodes[8].QuerySelector(".cell").TextContent,
IsUpdate = true,
UpdateTime = DateTime.Now,
CreateTime = DateTime.Now
};
tuanList.Add(tuan);
}
using (var context = new TswwDbContext())
{
foreach (var item in tuanList)
{
var tuan = context.Tuans.SingleOrDefault(s => s.TuanId == item.TuanId);
if (tuan != null)
{
tuan.Name = item.Name;
tuan.TuanRenShu = item.TuanRenShu;
tuan.TotalAmount = item.TotalAmount;
tuan.TotalSaleCount = item.TotalSaleCount;
}
else
{
context.Tuans.Add(item);
}
context.SaveChanges();
}
}
}
}
