private string danhgia() { string kq = ""; string sql = "Select * From theodoisk where ngaydanhgia <= #" + DC1.ngaythang(dtpNTDen.Text) + "# and mahocsinh = '" + Connect.GetStr(Luhocsinh.EditValue) + "' and sothangtuoi = (Select Max(sothangtuoi) from theodoisk where ngaydanhgia <= #" + DC1.ngaythang(dtpNTDen.Text) + "# and mahocsinh = '" + Connect.GetStr(Luhocsinh.EditValue) + "')"; OleDbDataReader dr = Connect.TruyVandr("Select * From theodoisk where ngaydanhgia <= #" + DC1.ngaythang(dtpNTDen.Text) + "# and mahocsinh = '" + Connect.GetStr(Luhocsinh.EditValue) + "' and sothangtuoi = (Select Max(sothangtuoi) from theodoisk where ngaydanhgia <= #" + DC1.ngaythang(dtpNTDen.Text) + "# and mahocsinh = '" + Connect.GetStr(Luhocsinh.EditValue) + "')"); while (dr.Read()) { if (dr["danhgia"].ToString() == "Rất gầy") { kq = "Bé nhà bạn đang ở tình trạng rất gầy. Bạn phải cải thiện chế độ ăn uống, dinh dưỡng cho bé."; } if (dr["danhgia"].ToString() == "Gầy") { kq = "Bé nhà bạn đang ở tình trạng gầy. Bạn phải cải thiện chế độ ăn uống, dinh dưỡng cho bé."; } if (dr["danhgia"].ToString() == "Bình thường") { kq = "Bé nhà bạn đang ở tình trạng bình thường. Bạn phải hãy giữ chế độ ăn uống, dinh dưỡng cho bé."; } if (dr["danhgia"].ToString() == "Thừa cân") { kq = "Bé nhà bạn đang ở tình trạng thừa cân. Bạn phải điều chỉnh lại chế độ ăn uống, dinh dưỡng cho bé."; } if (dr["danhgia"].ToString() == "Béo phì") { kq = "Bé nhà bạn đang ở tình trạng béo phì. Bạn phải điều chỉnh lại chế dộ ăn uống, dinh dưỡng cho bé."; } } dr.Close(); return(kq); }
private void button16_Click(object sender, EventArgs e) { Reports.rptSoCTQuy rpt = new Reports.rptSoCTQuy(); frmHienThi frm = new frmHienThi(); DataTable dtSD = Connect.TruyVandt("Select * From qrSoQuyTM Where ngaygs < #" + DC1.ngaythang(dtpNTTu.Text) + "#"); Dataset.dsChungTu ds = new Dataset.dsChungTu(); foreach (DataRow row in Connect.TruyVandt("Select * From qrSoQuyTM Where ploai='Thu' and ngaygs Between #" + DC1.ngaythang(dtpNTTu.Text) + "# and #" + DC1.ngaythang(dtpNTDen.Text) + "#").Rows) { ds.qrSoQuyTM.Rows.Add(row["ngaygs"], "", row["sohieu"], row["noidung"], 0, row["SoTien"], "", 0, row["thang"]); } foreach (DataRow row in Connect.TruyVandt("Select * From qrSoQuyTM Where ploai='Chi' and ngaygs Between #" + DC1.ngaythang(dtpNTTu.Text) + "# and #" + DC1.ngaythang(dtpNTDen.Text) + "#").Rows) { ds.qrSoQuyTM.Rows.Add(row["ngaygs"], "", "", row["noidung"], row["SoTien"], 0, row["sohieu"], 0, row["thang"]); } foreach (DataRow row in ds.qrSoQuyTM.Rows) { row["sodu"] = dcts.TinhToan(dtSD.Select("ploai='Thu'"), "sotien") - dcts.TinhToan(dtSD.Select("ploai='Chi'"), "sotien"); } rpt.Huyen.Value = thongtinketxuat.Default.tendv.ToString(); rpt.TNDN.Value = "Năm " + Convert.ToDateTime(dtpNTDen.EditValue).Year.ToString(); rpt.HTNGSo.Value = thongtinketxuat.Default.thuquy.ToString(); rpt.HTKeTT.Value = thongtinketxuat.Default.ptkt.ToString(); rpt.HTNK.Value = thongtinketxuat.Default.ttdv.ToString(); rpt.NTNSo.Value = thongtinketxuat.Default.diadanh.ToString() + ", ngày ... tháng ... năm ......"; frm.printControl1.PrintingSystem = rpt.PrintingSystem; rpt.DataSource = ds; rpt.CreateDocument(); frm.ShowDialog(); this.Close(); }
private void inserttbl() { foreach (DataRow row in Connect.TruyVandt("Select theodoisk.*, hocsinh.gths From theodoisk inner join hocsinh on theodoisk.mahocsinh = hocsinh.mshs" + " Where mahocsinh = '" + Connect.GetStr(Luhocsinh.EditValue) + "' and ngaydanhgia Between #" + DC1.ngaythang(dtpNTTu.Text) + "# and #" + DC1.ngaythang(dtpNTDen.Text) + "#").Rows) { ds.theodoisk.Rows.Add(row["ngaydanhgia"], row["mahocsinh"], row["sothangtuoi"], row["cannang"], row["chieucao"], row["danhgia"], row["gths"]); } }
private void ThoaiSoQTM_Load(object sender, EventArgs e) { Connect.LoadDL(Luhocsinh, "mshs", "tenhs", "Select * From hocsinh"); dtpNTTu.EditValue = DC1.ngaythang(thongtinketxuat.Default.NTT.ToString()); dtpNTDen.EditValue = DC1.ngaythang(thongtinketxuat.Default.NTD.ToString()); if (DC1.tenhs != "") { Luhocsinh.EditValue = DC1.tenhs; } }
private void MtbNgayTD_Leave(object sender, EventArgs e) { try { MtbNgayTD.Text = DC1.ngaythang(MtbNgayTD.Text); } catch { MtbNgayTD.Text = string.Format("{0:dd/MM/yyyy}", DateTime.Today); } }
private void MtbNTDG_Leave(object sender, EventArgs e) { try { MtbNTDG.Text = DC1.ngaythang(MtbNTDG.Text); } catch { MtbNTDG.Text = DC1.ngaythang(DateTime.Now.ToString()); } cbtenphongb_SelectedIndexChanged(sender, e); }
private string kt(string tentp) { string kq = ""; OleDbDataReader dr = Connect.TruyVandr("Select * From dmtp"); while (dr.Read()) { if (DC1.Func(dr["tentp"].ToString()) == DC1.Func(tentp)) { kq = "C"; } } dr.Close(); return(kq); }
private void labelX3_Click(object sender, EventArgs e) { if (dl.IndexOf("QLDD") == -1) { MessageBox.Show("Đây không phải là csdl, bạn chọn lại", "Thông báo"); } else { cn2 = DC1.Ketnoi_Databasechuyen(DC1.namchuyen); string sqldel = "delete * From hocsinh"; OleDbCommand cmd = new OleDbCommand(sqldel, cn2); cmd.ExecuteNonQuery(); hocsinh(); chungtunx(); thucpham(); MessageBox.Show("Bạn đã chuyển số dư sang năm mới thành công ", "Thông báo"); this.Close(); } }
private void buttonX1_Click(object sender, EventArgs e) { try { for (int i = 0; i < grvKH.RowCount; i++) { if (Connect.GetStr(grvKH.GetRowCellValue(i, colIDKH)) == "0") { OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = "Insert into tblkehoach (MaNT,Tuan,Ngaythang,MaTD,MaMA,TenBA,Tenbua) values (@MaNT,@Tuan,@Ngaythang,@MaTD,@MaMA,@TenBA,@Tenbua)"; cmd.Parameters.Add("@MaNT", OleDbType.VarChar).Value = cboNhomTuoi.EditValue; cmd.Parameters.Add("@Tuan", OleDbType.VarChar).Value = DC1.tuanthu(txtngaythang.Text); cmd.Parameters.Add("@Ngaythang", OleDbType.VarChar).Value = txtngaythang.Text; cmd.Parameters.Add("@MaTD", OleDbType.VarChar).Value = grvKH.GetRowCellValue(i, colMaTD); cmd.Parameters.Add("@MaMA", OleDbType.VarChar).Value = grvKH.GetRowCellValue(i, colMaMA); cmd.Parameters.Add("@TenBA", OleDbType.VarChar).Value = cboBuaan.EditValue; cmd.Parameters.Add("@Tenbua", OleDbType.VarChar).Value = grvKH.GetRowCellValue(i, colTenMA); Connect.LuuDL(cmd); } if (Connect.GetDou(grvKH.GetRowCellValue(i, colIDKH)) > 0) { OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = "Update tblkehoach set MaNT=@MaNT,Tuan=@Tuan,Ngaythang=@Ngaythang,MaTD=@MaTD,MaMA=@MaMA,TenBA=@TenBA,Tenbua=@Tenbua where IDKH = " + Convert.ToInt64(Connect.GetStr(grvKH.GetRowCellValue(i, colIDKH))); cmd.Parameters.Add("@MaNT", OleDbType.VarChar).Value = cboNhomTuoi.EditValue; cmd.Parameters.Add("@Tuan", OleDbType.VarChar).Value = DC1.tuanthu(txtngaythang.Text); cmd.Parameters.Add("@Ngaythang", OleDbType.VarChar).Value = txtngaythang.Text; cmd.Parameters.Add("@MaTD", OleDbType.VarChar).Value = grvKH.GetRowCellValue(i, colMaTD); cmd.Parameters.Add("@MaMA", OleDbType.VarChar).Value = grvKH.GetRowCellValue(i, colMaMA); cmd.Parameters.Add("@TenBA", OleDbType.VarChar).Value = cboBuaan.EditValue; cmd.Parameters.Add("@Tenbua", OleDbType.VarChar).Value = grvKH.GetRowCellValue(i, colTenMA); Connect.LuuDL(cmd); } } Connect.Reconnect(); LuBuaan_EditValueChanged(sender, e); MessageBox.Show("Bạn đã lưu thành công!", "Thông báo"); } catch { MessageBox.Show("Có lỗi trong quá trình lưu dữ liệu. Bạn hãy kiểm tra lại!", "Thông báo"); } }
private void button16_Click(object sender, EventArgs e) { try { if (Connect.GetStr(Luhocsinh.EditValue) == "") { MessageBox.Show("Bạn cần phải chọn học sinh cần tạo!", "Thông báo"); } else { foreach (DataRow row in Connect.TruyVandt("Select theodoisk.*, hocsinh.gths From theodoisk inner join hocsinh on theodoisk.mahocsinh = hocsinh.mshs" + " Where mahocsinh = '" + Connect.GetStr(Luhocsinh.EditValue) + "' and ngaydanhgia Between #" + DC1.ngaythang(dtpNTTu.Text) + "# and #" + DC1.ngaythang(dtpNTDen.Text) + "#").Rows) { ds.theodoisk.Rows.Add(row["ngaydanhgia"], row["mahocsinh"], row["sothangtuoi"], row["cannang"], row["chieucao"], row["danhgia"], row["gths"]); } foreach (DataRow item in ds.theodoisk.Rows) { item["chieucaochuan"] = dcts.LayGT(Connect.TruyVandt("Select chieucaochuan From tblchiso where thang = " + classdc.dungchung.kieudouble(item["sothangtuoi"].ToString()) + " and gioitinh = '" + item["gioitinh"].ToString() + "'").Select(), "chieucaochuan"); item["cannangchuan"] = dcts.LayGT(Connect.TruyVandt("Select cannangchuan From tblchiso where thang = " + classdc.dungchung.kieudouble(item["sothangtuoi"].ToString()) + " and gioitinh = '" + item["gioitinh"].ToString() + "'").Select(), "cannangchuan"); } //Connect.Loadds(dts, "Select * From theodoisk where mahocsinh = '" + Luhocsinh.EditValue.ToString() + "'", "theodoisk"); Reports.Testchart rpt = new Reports.Testchart(); frmHienThi frm = new frmHienThi(); rpt.TenDV.Value = thongtinketxuat.Default.tendv.ToString(); rpt.TenHS.Value = Luhocsinh.Text; rpt.Lop.Value = Connect.LayGT("Select tenphong from hocsinh where mshs = '" + Connect.GetStr(Luhocsinh.EditValue) + "'", "tenphong"); rpt.NgaySinh.Value = Convert.ToDateTime(Connect.LayGT("Select ntns from hocsinh where mshs = '" + Connect.GetStr(Luhocsinh.EditValue) + "'", "ntns")); rpt.TungayDenngay.Value = "Ngày đánh giá từ ngày " + dtpNTTu.Text + " đến ngày " + dtpNTDen.Text; rpt.Ketluan.Value = danhgia(); frm.printControl1.PrintingSystem = rpt.PrintingSystem; rpt.DataSource = ds; rpt.CreateDocument(); frm.ShowDialog(); this.Close(); } } catch { MessageBox.Show("Có lỗi trong quá trình tạo báo cáo. Bạn hãy kiểm tra lại!", "Thông báo"); } }
private void btnOK_Click(object sender, EventArgs e) { Reports.BcTDSKHS rpt = new Reports.BcTDSKHS(); frmHienThi frm = new frmHienThi(); DataTable dtTT = Connect.TruyVandt("SELECT hocsinh.tenhs, hocsinh.gths, hocsinh.ntns, hocsinh.tenphong," + " theodoisk.sothangtuoi, theodoisk.cannang, theodoisk.chieucao, theodoisk.ngaydanhgia, theodoisk.danhgia" + " FROM hocsinh INNER JOIN theodoisk ON hocsinh.mshs = theodoisk.mahocsinh" + " Where theodoisk.ngaydanhgia between #" + DC1.ngaythang(MtbNgayTT.Text) + "# and #" + DC1.ngaythang(MtbNgayTD.Text) + "#"); Dataset.dsTblDC dts = new Dataset.dsTblDC(); foreach (DataRow item in dtTT.Rows) { dts.TblDC.Rows.Add(null, item["ngaydanhgia"], item["ntns"], item["tenhs"], item["gths"], "", item["tenphong"], item["danhgia"], "", "", "", "" + "", "", "", "", "", "", "", "", "", "", "", "", item["sothangtuoi"], item["cannang"], item["chieucao"]); } rpt.NTT.Value = "Từ ngày " + MtbNgayTT.Text + " đến ngày " + MtbNgayTD.Text; //rpt.TenDV.Value = thongtinketxuat.Default.tendv.ToString(); rpt.DataSource = dts; frm.printControl1.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(); frm.ShowDialog(); this.Close(); }
public ChuyenSD() { InitializeComponent(); cn1 = DC1.Ketnoi_Database(DC1.namdllv); //cn2 = DC1.Ketnoi_Databasechuyen(DC1.namchuyen); }
private void button16_Click(object sender, EventArgs e) { string kt1 = "", kt2 = "", kt3 = "", kt4 = "", kt5 = ""; double d = 0; double st1 = 0, st2 = 0, st3 = 0, st4 = 0, st5 = 0, st6 = 0, st = 0; for (int i = 0; i < grvCT.RowCount; i++) { if (grvCT.GetRowCellValue(i, colCheck).ToString() == "True") { d += 1; if (d == 1) { kt1 = grvCT.GetRowCellValue(i, colTenKhoanThu).ToString(); } if (d == 2) { kt2 = grvCT.GetRowCellValue(i, colTenKhoanThu).ToString(); } if (d == 3) { kt3 = grvCT.GetRowCellValue(i, colTenKhoanThu).ToString(); } if (d == 4) { kt4 = grvCT.GetRowCellValue(i, colTenKhoanThu).ToString(); } if (d == 5) { kt5 = grvCT.GetRowCellValue(i, colTenKhoanThu).ToString(); } } } DataTable dt = Connect.TruyVandt("Select * FROM qrThuTT "); Dataset.dsTblDC dts = new KPBT.Dataset.dsTblDC(); foreach (DataRow item in Connect.TruyVandt("Select ngaythu, thang,tenphong From qrThuTT where ngaythu Between #" + DC1.ngaythang(dtpNTTu.Text) + "# and #" + DC1.ngaythang(dtpNTDen.Text) + "# Group by ngaythu,thang,tenphong").Rows) { dts.qrThuTT.Rows.Add(item["ngaythu"], "", "", "", item["thang"], item["tenphong"]); } foreach (DataRow item in dts.qrThuTT.Rows) { if (kt1 != "") { item["SL3"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and ngaythu = '" + DateTime.Parse(item["ngaythu"].ToString()) + "' and tenkhoanthu = '" + kt1 + "'"), "SumOfsotienthu"); st1 = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = '" + kt1 + "'"), "SumOfsotienthu"); } if (kt2 != "") { item["SL4"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and ngaythu = '" + DateTime.Parse(item["ngaythu"].ToString()) + "' and tenkhoanthu = '" + kt2 + "'"), "SumOfsotienthu"); st2 = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = '" + kt2 + "'"), "SumOfsotienthu"); } if (kt3 != "") { item["SL5"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and ngaythu = '" + DateTime.Parse(item["ngaythu"].ToString()) + "' and tenkhoanthu = '" + kt3 + "'"), "SumOfsotienthu"); st3 = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = '" + kt3 + "'"), "SumOfsotienthu"); } if (kt4 != "") { item["SL6"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and ngaythu = '" + DateTime.Parse(item["ngaythu"].ToString()) + "' and tenkhoanthu = '" + kt4 + "'"), "SumOfsotienthu"); st4 = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = '" + kt4 + "'"), "SumOfsotienthu"); } if (kt5 != "") { item["SL7"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = '" + kt5 + "'"), "SumOfsotienthu"); st5 = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = '" + kt5 + "'"), "SumOfsotienthu"); } item["SL8"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu <> '" + kt1 + "' and tenkhoanthu <> '" + kt2 + "'and tenkhoanthu <> '" + kt3 + "'and tenkhoanthu <> '" + kt4 + "' and tenkhoanthu <> '" + kt5 + "'"), "SumOfsotienthu"); st6 = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu <> '" + kt1 + "' and tenkhoanthu <> '" + kt2 + "'and tenkhoanthu <> '" + kt3 + "'and tenkhoanthu <> '" + kt4 + "' and tenkhoanthu <> '" + kt5 + "'"), "SumOfsotienthu"); item["SL10"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = 'Tiền ăn'"), "SumOfsothu"); item["SL11"] = dcts.TinhToan(dt.Select("tenphong = '" + item["lop"] + "' and thang = " + double.Parse(item["thang"].ToString()) + " and tenkhoanthu = 'Tiền ăn'"), "SumOfsotienthu"); st = st1 + st2 + st3 + st4 + st5 + st6; item["SL9"] = st; } foreach (DataRow item in dts.qrThuTT.Rows) { item["siso"] = siso(item["lop"].ToString()); } Reports.SoNKBG rpt = new Reports.SoNKBG(); frmHienThi frm = new frmHienThi(); rpt.tendv.Value = thongtinketxuat.Default.tendv.ToString(); rpt.thukho.Value = thongtinketxuat.Default.thukho.ToString(); rpt.ktoan.Value = thongtinketxuat.Default.ptkt.ToString(); rpt.ttdv.Value = thongtinketxuat.Default.ttdv.ToString(); rpt.KT1.Value = kt1; rpt.KT2.Value = kt2; rpt.KT3.Value = kt3; rpt.KT4.Value = kt4; rpt.KT5.Value = kt5; frm.printControl1.PrintingSystem = rpt.PrintingSystem; rpt.DataSource = dts; rpt.CreateDocument(); frm.ShowDialog(); this.Close(); }
private void labelX21_Click(object sender, EventArgs e) { try { if (ckbNamLV.Checked == true) { Program.openfrm = "Cài đặt"; this.Visible = false; Form frm = new KPBT.Forms.frmThoai_DOINAM(); frm.ShowDialog(); this.Close(); } else { System.Globalization.CultureInfo cultuere = new System.Globalization.CultureInfo("vi-VN"); cultuere.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy"; string pathlv = ""; pathlv = fd + @"\QLDD" + cbnam.Text + ".mdb"; if (File.Exists(pathlv) == true) { MessageBox.Show("Năm dữ liệu này đã tồn tại, bạn tạo năm khác!", "Thông báo"); } else { if (MessageBox.Show("Bạn có muốn tạo năm làm việc tại đường dẫn " + pathlv + " không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { File.Copy(dlmau, pathlv, true); cn2 = DC1.Ketnoi_Database(pathlv); if (ckbDM.Checked == true) { #region Danh mục lớp string sqldelctmt = "Delete * From phong"; OleDbCommand cmddelctmt = new OleDbCommand(sqldelctmt, cn2); cmddelctmt.ExecuteNonQuery(); string sql1 = " Select * From phong"; OleDbCommand cmd1 = new OleDbCommand(sql1, cn1); OleDbDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { string sqlinctmt = "Insert into phong (tenphong,nhatre,ttkhac,loptren)" + " Values (@tenphong,@nhatre,@ttkhac,@loptren)"; OleDbCommand cmdinctmt = new OleDbCommand(sqlinctmt, cn2); cmdinctmt.Parameters.Add("@tenphong", OleDbType.VarChar).Value = dr1["tenphong"].ToString(); cmdinctmt.Parameters.Add("@nhatre", OleDbType.VarChar).Value = dr1["nhatre"].ToString(); cmdinctmt.Parameters.Add("@ttkhac", OleDbType.VarChar).Value = dr1["ttkhac"].ToString(); cmdinctmt.Parameters.Add("@loptren", OleDbType.VarChar).Value = dr1["loptren"].ToString(); cmdinctmt.ExecuteNonQuery(); } dr1.Close(); #endregion #region Danh mục Cán bộ quản lý lớp string sqldelch = "Delete * From canbo"; OleDbCommand cmddelch = new OleDbCommand(sqldelch, cn2); cmddelch.ExecuteNonQuery(); string sql2 = " Select * From canbo"; OleDbCommand cmd2 = new OleDbCommand(sql2, cn1); OleDbDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { string sqlinch = "Insert into canbo (macb,tencb,dccb,phongban)" + " Values (@macb,@tencb,@dccb,@phongban)"; OleDbCommand cmdinch = new OleDbCommand(sqlinch, cn2); cmdinch.Parameters.Add("@macb", OleDbType.VarChar).Value = dr2["macb"].ToString(); cmdinch.Parameters.Add("@tencb", OleDbType.VarChar).Value = dr2["tencb"].ToString(); cmdinch.Parameters.Add("@dccb", OleDbType.VarChar).Value = dr2["dccb"].ToString(); cmdinch.Parameters.Add("@phongban", OleDbType.VarChar).Value = dr2["phongban"].ToString(); cmdinch.ExecuteNonQuery(); } dr2.Close(); #endregion #region Danh mục Kho string sqldelkh = "Delete * From kho"; OleDbCommand cmddelkh = new OleDbCommand(sqldelkh, cn2); cmddelkh.ExecuteNonQuery(); string sql4 = " Select * From kho"; OleDbCommand cmd4 = new OleDbCommand(sql4, cn1); OleDbDataReader dr4 = cmd4.ExecuteReader(); while (dr4.Read()) { string sqlinkh = "Insert into kho (tenkho,dd)" + " Values (@tenkho,@dd)"; OleDbCommand cmdinkh = new OleDbCommand(sqlinkh, cn2); cmdinkh.Parameters.Add("@tenkho ", OleDbType.VarChar).Value = dr4["tenkho"].ToString(); cmdinkh.Parameters.Add("@dd", OleDbType.VarChar).Value = dr4["dd"].ToString(); cmdinkh.ExecuteNonQuery(); } dr4.Close(); #endregion #region Danh mục thực phẩm string sqldellk = "Delete * From dmtp"; OleDbCommand cmddellk = new OleDbCommand(sqldellk, cn2); cmddellk.ExecuteNonQuery(); string sql5 = " Select * From dmtp"; OleDbCommand cmd5 = new OleDbCommand(sql5, cn1); OleDbDataReader dr5 = cmd5.ExecuteReader(); while (dr5.Read()) { string sqlinlk = "Insert into dmtp (matp,tentp,donvitinh,dongia,sogam,chokho,tilethai,nangluong,protein,chatbeo,carbohydrat,chatxo,choleterol,canxi,phospho,sat,natri,kali,betacaroten,vitamina,vitaminb,vitaminc)" + " Values (@matp,@tentp,@donvitinh,@dongia,@sogam,@chokho,@tilethai,@nangluong,@protein,@chatbeo,@carbohydrat,@chatxo,@choleterol,@canxi,@phospho,@sat,@natri,@kali,@betacaroten,@vitamina,@vitaminb,@vitaminc)"; OleDbCommand cmdinlk = new OleDbCommand(sqlinlk, cn2); cmdinlk.Parameters.Add("@matp", OleDbType.VarChar).Value = dr5["matp"].ToString(); cmdinlk.Parameters.Add("@tentp", OleDbType.VarChar).Value = dr5["tentp"].ToString(); cmdinlk.Parameters.Add("@donvitinh", OleDbType.VarChar).Value = dr5["donvitinh"].ToString(); cmdinlk.Parameters.Add("@dongia", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["dongia"].ToString()); cmdinlk.Parameters.Add("@sogam", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["sogam"].ToString()); cmdinlk.Parameters.Add("@chokho", OleDbType.VarChar).Value = dr5["chokho"].ToString(); cmdinlk.Parameters.Add("@tilethai", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["tilethai"].ToString()); cmdinlk.Parameters.Add("@nangluong", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["nangluong"].ToString()); cmdinlk.Parameters.Add("@protein", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["protein"].ToString()); cmdinlk.Parameters.Add("@chatbeo", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["chatbeo"].ToString()); cmdinlk.Parameters.Add("@carbohydrat", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["carbohydrat"].ToString()); cmdinlk.Parameters.Add("@chatxo", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["chatxo"].ToString()); cmdinlk.Parameters.Add("@choleterol", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["choleterol"].ToString()); cmdinlk.Parameters.Add("@canxi", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["canxi"].ToString()); cmdinlk.Parameters.Add("@phospho", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["phospho"].ToString()); cmdinlk.Parameters.Add("@sat", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["sat"].ToString()); cmdinlk.Parameters.Add("@natri", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["natri"].ToString()); cmdinlk.Parameters.Add("@kali", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["kali"].ToString()); cmdinlk.Parameters.Add("@betacaroten", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["betacaroten"].ToString()); cmdinlk.Parameters.Add("@vitamina", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["vitamina"].ToString()); cmdinlk.Parameters.Add("@vitaminb", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["vitaminb"].ToString()); cmdinlk.Parameters.Add("@vitaminc", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr5["vitaminc"].ToString()); cmdinlk.ExecuteNonQuery(); } dr5.Close(); #endregion #region Danh mục khoản thu string sqldelng = "Delete * From dmthu"; OleDbCommand cmddelng = new OleDbCommand(sqldelng, cn2); cmddelng.ExecuteNonQuery(); string sql6 = " Select * From dmthu"; OleDbCommand cmd6 = new OleDbCommand(sql6, cn1); OleDbDataReader dr6 = cmd6.ExecuteReader(); while (dr6.Read()) { string sqlinng = "Insert into dmthu (makhthu,tenkhoanthu,soluong,sotien)" + " Values (@makhthu,@tenkhoanthu,@soluong,@sotien)"; OleDbCommand cmdinng = new OleDbCommand(sqlinng, cn2); cmdinng.Parameters.Add("@makhthu", OleDbType.VarChar).Value = dr6["makhthu"].ToString(); cmdinng.Parameters.Add("@tenkhoanthu", OleDbType.VarChar).Value = dr6["tenkhoanthu"].ToString(); cmdinng.Parameters.Add("@soluong", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr6["soluong"].ToString()); cmdinng.Parameters.Add("@sotien", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr6["sotien"].ToString()); cmdinng.ExecuteNonQuery(); } dr6.Close(); #endregion #region Hệ thống string sqldelht = "Delete * From ttdv"; OleDbCommand cmddelht = new OleDbCommand(sqldelht, cn2); cmddelht.ExecuteNonQuery(); string sql15 = " Select * From ttdv"; OleDbCommand cmd15 = new OleDbCommand(sql15, cn1); OleDbDataReader dr15 = cmd15.ExecuteReader(); while (dr15.Read()) { string sqlinda = "Insert into ttdv (tendv,tenct,dcdv,nlb,nnhanhang,thukho,ketoan," + " kttruong,ttdv,MHTT,MA,mqhns,bophan,diadanh,thuquy,MASANG,MATOI,MUCHT,Namhoc"; if (dr15["nkxtu"].ToString() != "") { sqlinda = sqlinda + ",nkxtu"; } if (dr15["nkxden"].ToString() != "") { sqlinda = sqlinda + ",nkxden"; } sqlinda = sqlinda + ")" + " Values (@tendv,@tenct,@dcdv,@nlb,@nnhanhang,@thukho,@ketoan," + " @kttruong,@ttdv,@MHTT,@MA,@mqhns,@bophan,@diadanh,@thuquy,@MASANG,@MATOI,@MUCHT,@Namhoc"; if (dr15["nkxtu"].ToString() != "") { sqlinda = sqlinda + ",@nkxtu"; } if (dr15["nkxden"].ToString() != "") { sqlinda = sqlinda + ",@nkxden"; } sqlinda = sqlinda + ")"; OleDbCommand cmdinda = new OleDbCommand(sqlinda, cn2); cmdinda.Parameters.Add("@tendv", OleDbType.VarChar).Value = dr15["tendv"].ToString(); cmdinda.Parameters.Add("@tenct", OleDbType.VarChar).Value = dr15["tenct"].ToString(); cmdinda.Parameters.Add("@dcdv", OleDbType.VarChar).Value = dr15["dcdv"].ToString(); cmdinda.Parameters.Add("@nlb", OleDbType.VarChar).Value = dr15["nlb"].ToString(); cmdinda.Parameters.Add("@nnhanhang", OleDbType.VarChar).Value = dr15["nnhanhang"].ToString(); cmdinda.Parameters.Add("@thukho", OleDbType.VarChar).Value = dr15["thukho"].ToString(); cmdinda.Parameters.Add("@ketoan", OleDbType.VarChar).Value = dr15["ketoan"].ToString(); cmdinda.Parameters.Add("@kttruong", OleDbType.VarChar).Value = dr15["kttruong"].ToString(); cmdinda.Parameters.Add("@ttdv", OleDbType.VarChar).Value = dr15["ttdv"].ToString(); cmdinda.Parameters.Add("@MHTT", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr15["MHTT"].ToString()); cmdinda.Parameters.Add("@MA", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr15["MA"].ToString()); cmdinda.Parameters.Add("@mqhns", OleDbType.VarChar).Value = dr15["mqhns"].ToString(); cmdinda.Parameters.Add("@bophan", OleDbType.VarChar).Value = dr15["bophan"].ToString(); cmdinda.Parameters.Add("@diadanh", OleDbType.VarChar).Value = dr15["diadanh"].ToString(); cmdinda.Parameters.Add("@thuquy", OleDbType.VarChar).Value = dr15["thuquy"].ToString(); cmdinda.Parameters.Add("@MASANG", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr15["MASANG"].ToString()); cmdinda.Parameters.Add("@MATOI", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr15["MATOI"].ToString()); cmdinda.Parameters.Add("@MUCHT", OleDbType.Double).Value = classdc.dungchung.kieudouble(dr15["MUCHT"].ToString()); cmdinda.Parameters.Add("@Namhoc", OleDbType.VarChar).Value = dr15["Namhoc"].ToString(); if (dr15["nkxtu"].ToString() != "") { cmdinda.Parameters.Add("@nkxtu", OleDbType.Date).Value = Convert.ToDateTime(dr15["nkxtu"].ToString(), cultuere); } if (dr15["nkxden"].ToString() != "") { cmdinda.Parameters.Add("@nkxden", OleDbType.Date).Value = Convert.ToDateTime(dr15["nkxden"].ToString(), cultuere); } cmdinda.ExecuteNonQuery(); } dr15.Close(); #endregion } Settings1.Default.namlv = pathlv; Settings1.Default.Save(); DC1.namdllv = pathlv; Settings1.Default.thumucdoi = fd; Settings1.Default.Save(); Settings1.Default.namdoi = "QLDD" + cbnam.Text + ".mdb"; Settings1.Default.Save(); Connect.Reconnect(); //MessageBox.Show("Năm dữ liệu đã được tạo ra!", "Thông báo"); this.Visible = false; Form frm = new KPBT.Forms.frmXNBQ(); frm.ShowDialog(); this.Close(); } } } } catch { MessageBox.Show("Hay kiểm tra lại các thông tin!", "Thông báo"); } }
public frmTaoNamMoi() { InitializeComponent(); cn1 = DC1.Ketnoi_Database(DC1.namdllv); }
double slxuat(string matp) { double slx = 0; string sql = "Select nhxu.* From nhxu inner join nxct on nhxu.idnxct = nxct.idnxct Where nhxu.matp = '" + matp + "' and nxct.ntnx = #" + DC1.thaydoi(MtbNgayTT.Text) + "#"; OleDbDataReader dr = Connect.TruyVandr(sql); while (dr.Read()) { slx += classdc.dungchung.kieudouble(dr["slxu"].ToString()) + classdc.dungchung.kieudouble(dr["slxuccnt"].ToString()) + classdc.dungchung.kieudouble(dr["slxubpnt"].ToString()) + classdc.dungchung.kieudouble(dr["slxumg"].ToString()) + classdc.dungchung.kieudouble(dr["slxuccmg"].ToString()) + classdc.dungchung.kieudouble(dr["slxubpmg"].ToString()); } dr.Close(); return(slx); }