public string LayMaLoaiTuTenLoaiSP(string tenloai)
{
DataTable dt = new DataTable();
dt = db.ExecuteBang("select MALOAI from LOAISANPHAM WHERE TENLOAI=N'" + tenloai + "'");
s = dt.Rows[0]["MALOAI"].ToString();
return(s);
}
//goi thu thuc lay ma don dat hang(Cho ma tu dong tang)
public void LayMaDonDatHang()
{
using (DataTable dt = db.ExecuteBang("EXEC LAYMADDH"))
{
txtMaDonDatHang.Text = dt.Rows[0][0].ToString();
}
}
public static string DocSoTiengAnh(string number)
{
CDatabase db = new CDatabase();
DataTable dt = new DataTable();
dt = db.ExecuteBang(string.Format("SELECT dbo.F_DOCSOTHANHTU({0})", number));
return(dt.Rows[0][0].ToString());
}
private void btnXemBieuDo_Click_1(object sender, EventArgs e)
{
xtraTabControlMain.SelectedTabPage = xtpPreview;
if (dateEditTuNgay.Text != "" && dateEditDenNgay.Text != "")
{
if (dgvDSTinhDuocChon.Rows.Count != 0)
{
rptSoSanhDoanhThuGiuaCacTinh rpt = new rptSoSanhDoanhThuGiuaCacTinh();
DataTable dt = new DataTable();
string str;
for (int i = 0; i < dgvDSTinhDuocChon.Rows.Count; i++)
{
str = String.Format("EXEC SP_SOSANHDOANHTHUTHEOTINH '{0}','{1}','{2}','{3}'", dateEditTuNgay.Text, dateEditDenNgay.Text, dgvDSTinhDuocChon.Rows[i].Cells["matinhchon"].Value.ToString(), cbSanPham.GetColumnValue("MASP").ToString());
dt = db.ExecuteBang(str);
if (i == 0)
{
rpt.xrChart1.Series[0].DataSource = dt;
//so sanh theo ten tinh
rpt.xrChart1.Series[0].ArgumentDataMember = "tentinh";
rpt.xrChart1.Series[0].Name = dgvDSTinhDuocChon.Rows[i].Cells["tentinhchon"].Value.ToString();
//dieu kien de so sanh la doanh thu
rpt.xrChart1.Series[0].ValueDataMembers.AddRange(new string[] { "DOANHTHU" });
}
else
{
Series s = new Series();
s.DataSource = dt;
s.ArgumentDataMember = "tentinh";
s.Name = dgvDSTinhDuocChon.Rows[i].Cells["tentinhchon"].Value.ToString();
s.ValueDataMembers.AddRange(new string[] { "DOANHTHU" });
rpt.xrChart1.Series.Add(s);
}
}
rpt.xrChart1.Legend.Visible = true;
rpt.xrlbTuNgay.Text = Convert.ToDateTime(dateEditTuNgay.Text).ToShortDateString();
rpt.xrlbDenNgay.Text = Convert.ToDateTime(dateEditDenNgay.Text).ToShortDateString();
rpt.xrlbTenSP.Text = cbSanPham.Text;
printControlPreview.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument();
}
else
{
MessageBox.Show("Bạn chưa chọn các tỉnh cần so sánh", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Bạn phải nhập khoảng thời gian cần thống kê", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void FrmPhanTramKhachHangTheoLoai_Load(object sender, EventArgs e)
{
rptPhanTramKhachHangTheoLoai rpt = new rptPhanTramKhachHangTheoLoai();
DataTable dt = new DataTable();
dt = db.ExecuteBang("exec SP_THONGKEPHANTRAMLOAIKHACHHANG");
rpt.xrChartTKKHTheoLoai.DataSource = dt;
rpt.xrChartTKKHTheoLoai.Series[0].ArgumentDataMember = "TENLOAIKH";
rpt.xrChartTKKHTheoLoai.Series[0].ValueDataMembers.AddRange(new string[] { "PHANTRAM" });
rpt.xrChartTKKHTheoLoai.Series[0].PointOptions.PointView = PointView.ArgumentAndValues;
rpt.xrChartTKKHTheoLoai.Series[0].PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
rpt.xrChartTKKHTheoLoai.Series[0].PointOptions.ValueNumericOptions.Precision = 0;
rpt.xrChartTKKHTheoLoai.Legend.Visible = true;
printControl1.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument();
}
private void btnXemBieuDo_Click(object sender, EventArgs e)
{
if (dateEditTuNgay.Text != "" && dateEditDenNgay.Text != "")
{
rptThongKeDoanhThuTheoThoiGian rpt = new rptThongKeDoanhThuTheoThoiGian();
DataTable dt = new DataTable();
dt = db.ExecuteBang("SP_THONGKEDOANHTHUTHEOTHOIGIAN '" + string.Format("{0:dd/MM/yyyy}", dateEditTuNgay.Text) + "','" + string.Format("{0:dd/MM/yyyy}", dateEditDenNgay.Text) + "'");
rpt.xrChart1.DataSource = dt;
rpt.xrChart1.Series[0].ArgumentDataMember = "THANG_NAM";
rpt.xrChart1.Series[0].ValueDataMembers.AddRange(new string[] { "DOANH THU" });
rpt.xrChart1.Legend.Visible = true;
rpt.lbTuNgay.Text = string.Format("{0:dd/MM/yyyy}", dateEditTuNgay.Text);
rpt.lbDenNgay.Text = string.Format("{0:dd/MM/yyyy}", dateEditDenNgay.Text);
printControl1.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument();
}
else
{
MessageBox.Show("Bạn phải chọn thời gian cần thống kê!", "Thông Báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public DataTable LayDSKhachHang()
{
return(db.ExecuteBang("SELECT MAKH, HOTENKH, DCHIKH, DIENTHOAIKH,LADN, TENLOAIKH FROM KHACHHANG INNER JOIN LOAIKHACHHANG ON KHACHHANG.MALOAIKH=LOAIKHACHHANG.MALOAIKH"));
}
public DataTable HienThiCongTy()
{
return(db.ExecuteBang("SELECT * FROM CONGTY"));
}
public void LayMaCH()
{
dt = db.ExecuteBang("EXEC LAYMACH");
txtMaCH.Text = dt.Rows[0][0].ToString();
}
public void LayMaDDH()
{
DataTable dt1 = db.ExecuteBang("EXEC LAYMADDH");
txtMaDDH.Text = dt1.Rows[0][0].ToString();
}
public DataTable HienThiNhomTuoi()
{
return(db.ExecuteBang("SELECT * FROM NHOMTUOI"));
}
public DataTable LayDSDonDatHang()
{
return(db.ExecuteBang("SELECT MADDH FROM DONDATHANG"));
}
public DataTable HienThiKhachHangLaDN()
{
return(db.ExecuteBang("SELECT MAKH, MALV, MAHUYEN, MANGUON, MALOAIKH, MANV, HOTENKH, DIENTHOAIKH, DCHIKH, SOTK, WEBSITE, DOANHTHUHANGTHANG FROM KHACHHANG WHERE LADN=1"));
}
public void ThietLapLoaiKH(int thoihanthanthiet, int thoihanchinhthuc, float nguongcanhan, float nguongdoanhnghiep)
{
string sql = "UPDATE THIETLAPLOAIKH SET THOIHANTHANTHIET=" + thoihanthanthiet + ", THOIHANCHINHTHUC=" + thoihanchinhthuc + ", NGUONGCANHAN=" + nguongcanhan + ",NGUONGDOANHNGHIEP=" + nguongdoanhnghiep + " WHERE MATL='TL1'";
db.ExecuteBang(sql);
}
public DataTable HienThiNghe()
{
return(db.ExecuteBang("SELECT * FROM NGHENGHIEP"));
}
public DataTable LayDSQuanHuyen()
{
return(db.ExecuteBang("SELECT MAHUYEN, TENHUYEN FROM QUANHUYEN"));
}
public DataTable LayDSCapNhatDonDatHang()
{
return(db.ExecuteBang("SELECT CT.MADDH, SP.TENSP, CT.SOLUONGDAT FROM CTDDH CT, SANPHAM SP WHERE CT.MASP=SP.MASP ORDER BY CT.MADDH"));
}
public DataTable LayDanhSachLoaiSanPham()
{
return(db.ExecuteBang("SELECT MALOAI, TENLOAI FROM LOAISANPHAM"));
}
public DataTable XuatDanhSachKhachHang_report(DateTime tungay, DateTime denngay)
{
return(db.ExecuteBang("exec SP_KHACHHANGDATHANGNHIEUNHAT '" + tungay + "','" + denngay + "'"));
}
public DataTable HienThiChiTiet()
{
return(db.ExecuteBang("SELECT * FROM CHUCVU"));
}
public DataTable HienThiLoaiKH()
{
return(db.ExecuteBang("SELECT * FROM LOAIKHACHHANG"));
}
public DataTable LayDSCauHoi()
{
return(db.ExecuteBang("SELECT * FROM CAUHOI"));
}
public DataTable LayDanhSachKhachHang()
{
string query = "SELECT * FROM KHACHHANG";
return(db.ExecuteBang(query));
}
public static DataTable LAYDSNGUOIDUNG()
{
string query = "SELECT TENDANGNHAP, MATKHAU, QUYENADMIN, QUYENTHEM, QUYENXOA, QUYENSUA FROM QUANLYNGUOIDUNG";
return(db.ExecuteBang(query));
}
public DataTable LayLoaiSP()
{
return(db.ExecuteBang("SELECT * FROM LOAISANPHAM"));
}
//Ham lay danh sach nhan vien
public DataTable LayDSCV()
{
return(db.ExecuteBang("SELECT * FROM CHUCVU"));
}
public DataTable LayDSTinhThanh()
{
return(db.ExecuteBang("SELECT MATINH, TENTINH FROM TINHTHANH"));
}
public DataTable HienThiChiTiet(string maddh)
{
return(db.ExecuteBang("SELECT MADDH, MAKH, NGAYDAT FROM DONDATHANG WHERE MADDH='" + maddh + "'"));
}
public DataTable LayDanhSachDonViTinh()
{
return(db.ExecuteBang("SELECT MADVI, TENDVI FROM DVITINH"));
}
public DataTable HienThiDSDDH()
{
return(db.ExecuteBang("SELECT MADDH, MAKH, NGAYDAT FROM DONDATHANG"));
}
