public static Dictionary <string, string> test2()
{
var t = new Thang {
};
var t2 = new Thang {
Thing = "Hey", Name = "long"
};
var dict = new Dictionary <string, string>();
var mapProperty = new Dictionary <string, string>();
Object obj;
(obj, dict) = ObjectToMapWithDict(t);
Console.WriteLine(JsonConvert.SerializeObject(dict));
var serializedObj = JsonConvert.SerializeObject(obj);
var map = ObjectToMap(t2);
Dictionary <string, string> dictJsonProperty = JsonConvert.DeserializeObject <Dictionary <string, string> >(
JsonConvert.SerializeObject(t));
var dictProperty = new Dictionary <string, string>();
foreach (var item in dictJsonProperty)
{
var realPropertyName = dict[item.Value];
dictProperty.Add(item.Key, dict[item.Value]);
map.GetValueOrDefault(realPropertyName);
mapProperty.Add(item.Key, map.GetValueOrDefault(realPropertyName));
}
Console.WriteLine(JsonConvert.SerializeObject(dictProperty));
Console.WriteLine(JsonConvert.SerializeObject(mapProperty));
return(mapProperty);
}
public static DateTime NgayDauThang(DateTime rNgay)
{
int Thang, Nam;
Thang = rNgay.Month;
Nam = rNgay.Year;
return(DateTime.Parse(Thang.ToString() + "/01/" + Nam.ToString()));
}
private void TONGDOANHTHU_Load(object sender, EventArgs e)
{
txttongtien.ReadOnly = true;
groupBox2.Text = "Tổng doanh thu(VNĐ)";
if (Bngay == true)
{
trangthai = "Ngày";
load_dshd_ngay();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Ngày: " + Ngay.ToString();
tinhtongtien(5);
}
else if (Bthang == true)
{
trangthai = "Tháng";
load_dshd_thang();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Tháng: " + Thang.ToString();
tinhtongtien(5);
}
else if (Bnam == true)
{
trangthai = "Năm";
load_dshd_nam();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Năm: " + Nam.ToString();
tinhtongtien(5);
}
else if (Timcheck == true)
{
trangthai = Tenban;
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.Soban = Tenban;
dg_dshd.DataSource = hd_old_bul.load_timhd_old(hd_old_public);
dinhdangluoi_hd_ban();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo " + Tenban;
tinhtongtien(5);
}
else if (Checkten == true)
{
trangthai = Tenban;
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.TENNV = Tenban;
dg_dshd.DataSource = hd_old_bul.load_timhd_old_TENNV(hd_old_public);
dinhdangluoi_hd_ban();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn của nhân viên: " + Tenban;
tinhtongtien(5);
}
else
{
trangthai = "Tất cả các hóa đơn";
dg_dshd.DataSource = hd_old_bul.load_hoadon_old_NOTID();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách tất cả các hóa đơn";
tinhtongtien(5);
}
}
public static DateTime NgayCuoiThang(DateTime rNgay)
{
int Thang, Nam;
Thang = rNgay.Month;
Nam = rNgay.Year;
DateTime _ngay;
_ngay = DateTime.Parse(Thang.ToString() + "/01/" + Nam.ToString());
_ngay = _ngay.AddMonths(1);
return(_ngay.AddDays(-1));
}
// khởi tạo combo box thang
private void initThang()
{
lstThang = new List <Thang>();
for (int i = 1; i <= 12; i++)
{
Thang temp = new Thang()
{
value = i
};
lstThang.Add(temp);
}
}
public static void test2()
{
var settings = new JsonSerializerSettings();
settings.ContractResolver = new GenericPropertyContractResolver(typeof(Response <>));
var aa = new Response <Thang>
{
Data = new Thang {
Thing = "Hey"
}
};
var t = new Thang {
Thing = "Hey", Name = "long"
};
//JsonConvert.SerializeXNode(t)
Console.WriteLine(JsonConvert.SerializeObject(aa));
Console.WriteLine("aa");
Console.WriteLine(PropertyToDict(t));
Console.WriteLine("PropertyToDict");
Console.WriteLine(JsonConvert.SerializeObject(ObjectToMap(t)));
Console.WriteLine("ObjectToMap==");
Dictionary <string, string> dic2 = JsonConvert.DeserializeObject <Dictionary <string, string> >(
JsonConvert.SerializeObject(t));
foreach (var item in dic2)
{
Console.WriteLine($"{item.Key}---->{item.Value}");
}
string serialized = JsonConvert.SerializeObject(new Response <Thang>
{
Data = new Thang {
Thing = "Hey"
}
}, settings);
//PropertyToDict()
Console.WriteLine(serialized);
Console.WriteLine("dsd()");
dsd();
}
//Doanh thu theo tháng
public ActionResult Chart()
{
Session["View"] = "Income";
//string str = "select DATEPART(month, CreatedDate) as Thang,sum(TotalPrice) as TongTien from Orders where Status = 6 group by DATEPART(month, CreatedDate)";
var query = (from x in db.Orders
where x.Status == 6
orderby x.CreatedDate
group x by x.CreatedDate.Value.Month into Thang
select new
{
TongTien = Thang.Sum(x => x.TotalPrice),
Thang = "Tháng " + Thang.Key.ToString()
}).ToList();
ViewBag.DataPoints = JsonConvert.SerializeObject(query.ToList(), _jsonSetting);
return(View());
}
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();
}
public Thing(Thang thang)
{
_thang = thang;
}
