public string TaoSolieu() { Cursor = Cursors.WaitCursor; string mmyy = "", s = ""; for (int i = Convert.ToInt16(tu.Value); i <= Convert.ToInt16(den.Value); i++) { mmyy = i.ToString().PadLeft(2, '0') + yyyy.Value.ToString().PadLeft(4, '0').Substring(2, 2); if (m_v.bMmyy(mmyy)) { m_v.modify_tables_vp_mmyy(mmyy); m_v.modify_tables_vp(); } else { s += mmyy.Substring(0, 2) + "/20" + mmyy.Substring(2, 2) + ";"; } } Cursor = Cursors.Default; return(s); }
private void butCapnhat_Click(object sender, EventArgs e) { decimal l_sttt = 0; mmyy = thang.Value.ToString().PadLeft(2, '0') + nam.Value.ToString().Substring(2); user = m_v.user + mmyy; user_sau = m_v.user + (thang.Value + 1).ToString().PadLeft(2, '0') + nam.Value.ToString().Substring(2); i_makho = int.Parse(cboKho.SelectedValue.ToString()); i_makho_nhap = int.Parse(cboKhoNhap.SelectedValue.ToString()); i_makp = int.Parse(cboTutruc.SelectedValue.ToString()); DataSet dsdm = get_dmbd(); DataSet dstutruc_sau = get_tutruc_sau(); DataRow row = null; this.Refresh(); if (!chkTutruc.Checked) { #region Chuyển STTT tồn đầu nhà thuốc(để không trùng với STTT kho chẳn để sửa giá các kho) foreach (DataRow r in get_tondau_chuaxuat().Tables[0].Rows) { l_sttt = m_v.get_id_tonkho; if (m_v.upd_theodoi(mmyy, l_sttt, int.Parse(r["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r["handung"].ToString(), r["losx"].ToString(), "", "", "", 0, 0, 0, decimal.Parse(r["giamua"].ToString()), decimal.Parse(r["giaban"].ToString()), decimal.Parse(r["gianovat"].ToString()), 0, 0)) { m_v.execute_data("update " + user + ".d_tonkhoct set stt=" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and makho=" + i_makho + " and stt=" + decimal.Parse(r["stt"].ToString())); row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } } this.Refresh(); } // foreach (DataRow r in get_tondau_daxuat_khongcotrongtondaukhonhap().Tables[0].Rows) { l_sttt = m_v.get_id_tonkho; if (m_v.upd_theodoi(mmyy, l_sttt, int.Parse(r["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r["handung"].ToString(), r["losx"].ToString(), "", "", "", 0, 0, 0, decimal.Parse(r["giamua"].ToString()), decimal.Parse(r["giaban"].ToString()), decimal.Parse(r["gianovat"].ToString()), 0, 0)) { m_v.execute_data("update " + user + ".d_tonkhoct set stt=" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and makho=" + i_makho + " and stt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user + ".d_xuatct set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatll where khox=" + i_makho + ") and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } } this.Refresh(); } // decimal d_tondau = 0; foreach (DataRow r in get_tondau_daxuat_cotrongtondaukhonhap().Tables[0].Rows) { l_sttt = m_v.get_id_tonkho; DataRow rr = m_v.getrowbyid(get_tondau_khonhap().Tables[0], "stt=" + decimal.Parse(r["stt"].ToString())); if (rr != null) { if (decimal.Parse(rr["tondau"].ToString()) >= decimal.Parse(rr["slxuat"].ToString())) { m_v.upd_theodoi(mmyy, l_sttt, int.Parse(r["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r["handung"].ToString(), r["losx"].ToString(), "", "", "", 0, 0, 0, decimal.Parse(r["giamua"].ToString()), decimal.Parse(r["giaban"].ToString()), decimal.Parse(r["gianovat"].ToString()), 0, 0); if (!m_v.upd_tonkhoct(mmyy, i_makho_nhap, l_sttt, int.Parse(rr["mabd"].ToString()), decimal.Parse(rr["slnhap"].ToString()), "slnhap")) { MessageBox.Show(lan.Change_language_MessageText("Không cập nhật được thông tin tồn kho !"), m_v.s_AppName); return; } m_v.execute_data("update " + user + ".d_tonkhoct set slnhap=0 where makho=" + i_makho_nhap + " and stt=" + decimal.Parse(rr["stt"].ToString())); m_v.execute_data("update " + user + ".d_tonkhoth set slnhap=0 where makho=" + i_makho_nhap + " and mabd=" + int.Parse(rr["mabd"].ToString())); m_v.upd_tonkhoth(mmyy, i_makho_nhap, int.Parse(rr["manguon"].ToString()), int.Parse(rr["mabd"].ToString()), decimal.Parse(rr["slnhap"].ToString()), "slnhap"); m_v.execute_data("update " + user + ".d_tonkhoct set stt=" + l_sttt + " where mabd=" + int.Parse(rr["mabd"].ToString()) + " and makho=" + i_makho + " and stt=" + decimal.Parse(rr["stt"].ToString())); m_v.execute_data("update " + user + ".d_xuatct set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatll where khox=" + i_makho + ") and mabd=" + int.Parse(rr["mabd"].ToString()) + " and sttt=" + decimal.Parse(rr["stt"].ToString())); row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } this.Refresh(); } else { d_tondau = decimal.Parse(rr["tondau"].ToString()); decimal d_soluong = 0; //Upd so luong nhap m_v.upd_theodoi(mmyy, l_sttt, int.Parse(r["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r["handung"].ToString(), r["losx"].ToString(), "", "", "", 0, 0, 0, decimal.Parse(r["giamua"].ToString()), decimal.Parse(r["giaban"].ToString()), decimal.Parse(r["gianovat"].ToString()), 0, 0); if (!m_v.upd_tonkhoct(mmyy, i_makho_nhap, l_sttt, int.Parse(rr["mabd"].ToString()), decimal.Parse(rr["slnhap"].ToString()), "slnhap")) { MessageBox.Show(lan.Change_language_MessageText("Không cập nhật được thông tin tồn kho !"), m_v.s_AppName); return; } m_v.execute_data("update " + user + ".d_tonkhoct set slnhap=0 where makho=" + i_makho_nhap + " and stt=" + decimal.Parse(rr["stt"].ToString())); m_v.execute_data("update " + user + ".d_tonkhoth set slnhap=0 where makho=" + i_makho_nhap + " and mabd=" + int.Parse(rr["mabd"].ToString())); m_v.upd_tonkhoth(mmyy, i_makho_nhap, int.Parse(rr["manguon"].ToString()), int.Parse(rr["mabd"].ToString()), decimal.Parse(rr["slnhap"].ToString()), "slnhap"); m_v.execute_data("update " + user + ".d_tonkhoct set stt=" + l_sttt + " where mabd=" + int.Parse(rr["mabd"].ToString()) + " and makho=" + i_makho + " and stt=" + decimal.Parse(rr["stt"].ToString())); m_v.execute_data("update " + user + ".d_xuatct set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatll where khox=" + i_makho + ") and mabd=" + int.Parse(rr["mabd"].ToString()) + " and sttt=" + decimal.Parse(rr["stt"].ToString())); // sql = "select b.sttt, b.mabd, b.soluong from " + user + ".d_ngtrull a, " + user + ".d_ngtruct b where a.id=b.id and b.makho=" + i_makho_nhap + " and b.sttt=" + decimal.Parse(rr["stt"].ToString()); foreach (DataRow r1 in m_v.get_data(sql).Tables[0].Rows) { if (decimal.Parse(r1["soluong"].ToString()) <= d_tondau) { d_tondau -= decimal.Parse(r1["soluong"].ToString()); d_soluong += decimal.Parse(r1["soluong"].ToString()); m_v.execute_data("update " + user + ".d_tonkhoct set slxuat=" + d_soluong + " where makho=" + i_makho_nhap + " and stt=" + decimal.Parse(rr["stt"].ToString())); m_v.execute_data("update " + user + ".d_tonkhoth set slxuat=" + d_soluong + " where makho=" + i_makho_nhap + " and mabd=" + int.Parse(rr["mabd"].ToString())); } else { m_v.execute_data("update " + user + ".d_ngtruct set sttt=" + l_sttt + " where makho=" + i_makho_nhap + " and mabd=" + int.Parse(r1["mabd"].ToString()) + " and sttt=" + decimal.Parse(r1["sttt"].ToString())); if (!m_v.upd_tonkhoct(mmyy, i_makho_nhap, l_sttt, int.Parse(r1["mabd"].ToString()), decimal.Parse(r1["soluong"].ToString()), "slxuat")) { MessageBox.Show(lan.Change_language_MessageText("Không cập nhật được thông tin tồn kho !"), m_v.s_AppName); return; } m_v.upd_tonkhoth(mmyy, i_makho_nhap, int.Parse(rr["manguon"].ToString()), int.Parse(r1["mabd"].ToString()), decimal.Parse(r1["soluong"].ToString()), "slxuat"); } row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r1["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } this.Refresh(); } // sql = " select b.sttt, b.mabd, b.soluong from " + user + ".d_xuatll a, " + user + ".d_xuatct b where a.id=b.id and a.khox=" + i_makho_nhap + " and b.sttt=" + decimal.Parse(rr["stt"].ToString()); foreach (DataRow r1 in m_v.get_data(sql).Tables[0].Rows) { if (decimal.Parse(r1["soluong"].ToString()) <= d_tondau) { d_tondau -= decimal.Parse(r1["soluong"].ToString()); d_soluong += decimal.Parse(r1["soluong"].ToString()); m_v.execute_data("update " + user + ".d_tonkhoct set slxuat=" + d_soluong + " where makho=" + i_makho_nhap + " and stt=" + decimal.Parse(rr["stt"].ToString())); m_v.execute_data("update " + user + ".d_tonkhoth set slxuat=" + d_soluong + " where makho=" + i_makho_nhap + " and mabd=" + int.Parse(rr["mabd"].ToString())); } else { m_v.execute_data("update " + user + ".d_xuatct set sttt=" + l_sttt + " where id in(select id from " + user + ".d_xuatll where khox=" + i_makho_nhap + ") and mabd=" + int.Parse(r1["mabd"].ToString()) + " and sttt=" + decimal.Parse(r1["sttt"].ToString())); if (!m_v.upd_tonkhoct(mmyy, i_makho_nhap, l_sttt, int.Parse(r1["mabd"].ToString()), decimal.Parse(r1["soluong"].ToString()), "slxuat")) { MessageBox.Show(lan.Change_language_MessageText("Không cập nhật được thông tin tồn kho !"), m_v.s_AppName); return; } m_v.upd_tonkhoth(mmyy, i_makho_nhap, int.Parse(rr["manguon"].ToString()), int.Parse(r1["mabd"].ToString()), decimal.Parse(r1["soluong"].ToString()), "slxuat"); } row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r1["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } this.Refresh(); } } } } #endregion } else { #region Chuyển STTT tồn đầu tủ trực (để không trùng với STTT kho lẻ) foreach (DataRow r in get_tondau_tutruc_chuaxuat().Tables[0].Rows) { l_sttt = m_v.get_id_tonkho; if (m_v.upd_theodoi(mmyy, l_sttt, int.Parse(r["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r["handung"].ToString(), r["losx"].ToString(), "", "", "", 0, 0, 0, decimal.Parse(r["giamua"].ToString()), decimal.Parse(r["giaban"].ToString()), decimal.Parse(r["gianovat"].ToString()), 0, 0)) { m_v.execute_data("update " + user + ".d_tutrucct set stt=" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and makp=" + i_makp + " and makho=" + i_makho_nhap + " and stt=" + decimal.Parse(r["stt"].ToString())); if (m_v.bMmyy(user_sau.Substring(6))) { row = m_v.getrowbyid(dstutruc_sau.Tables[0], "mabd=" + int.Parse(r["mabd"].ToString()) + " and stt=" + decimal.Parse(r["stt"].ToString())); if (row != null) { //m_v.execute_data("delete from " + user_sau + ".d_tutrucct where mabd=" + int.Parse(r["mabd"].ToString()) + " and makho=" + i_makho_nhap + " and stt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user_sau + ".d_theodoi set id =" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and id=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user_sau + ".d_tutrucct set stt=" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and makp=" + i_makp + " and makho=" + i_makho_nhap + " and stt=" + decimal.Parse(r["stt"].ToString())); //m_v.execute_data("insert into " + user_sau + ".d_tutrucct values (" + i_makp + "," + i_makho_nhap + "," + l_sttt + "," + int.Parse(r["mabd"].ToString()) + "," + decimal.Parse(row["tondau"].ToString()) + "," + decimal.Parse(row["slnhap"].ToString()) + "," + decimal.Parse(row["slxuat"].ToString()) + ")"); m_v.execute_data("update " + user_sau + ".d_thucxuat set sttt=" + l_sttt + " where id in (select id from " + user_sau + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user_sau + ".d_xuatsdct set sttt=" + l_sttt + " where id in (select id from " + user_sau + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user + ".d_bucstt set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); } } row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } } this.Refresh(); } // foreach (DataRow r in get_tondau_tutruc_daxuat().Tables[0].Rows) { l_sttt = m_v.get_id_tonkho; if (m_v.upd_theodoi(mmyy, l_sttt, int.Parse(r["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r["handung"].ToString(), r["losx"].ToString(), "", "", "", 0, 0, 0, decimal.Parse(r["giamua"].ToString()), decimal.Parse(r["giaban"].ToString()), decimal.Parse(r["gianovat"].ToString()), 0, 0)) { m_v.execute_data("update " + user + ".d_tutrucct set stt=" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and makp=" + i_makp + " and makho=" + i_makho_nhap + " and stt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user + ".d_thucxuat set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user + ".d_xuatsdct set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user + ".d_bucstt set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); if (m_v.bMmyy(user_sau.Substring(6))) { row = m_v.getrowbyid(dstutruc_sau.Tables[0], "mabd=" + int.Parse(r["mabd"].ToString()) + " and stt=" + decimal.Parse(r["stt"].ToString())); if (row != null) { //m_v.execute_data("delete from " + user_sau + ".d_tutrucct where mabd=" + int.Parse(r["mabd"].ToString()) + " and makho=" + i_makho_nhap + " and stt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user_sau + ".d_theodoi set id =" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and id=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user_sau + ".d_tutrucct set stt=" + l_sttt + " where mabd=" + int.Parse(r["mabd"].ToString()) + " and makp=" + i_makp + " and makho=" + i_makho_nhap + " and stt=" + decimal.Parse(r["stt"].ToString())); //m_v.execute_data("insert into " + user_sau + ".d_tutrucct values (" + i_makp + "," + i_makho_nhap + "," + l_sttt + "," + int.Parse(r["mabd"].ToString()) + "," + decimal.Parse(row["tondau"].ToString()) + "," + decimal.Parse(row["slnhap"].ToString()) + "," + decimal.Parse(row["slxuat"].ToString()) + ")"); m_v.execute_data("update " + user_sau + ".d_thucxuat set sttt=" + l_sttt + " where id in (select id from " + user_sau + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user_sau + ".d_xuatsdct set sttt=" + l_sttt + " where id in (select id from " + user_sau + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); m_v.execute_data("update " + user + ".d_bucstt set sttt=" + l_sttt + " where id in (select id from " + user + ".d_xuatsdll where makho=" + i_makho_nhap + " and makp=" + i_makp + " and loai = 2) and mabd=" + int.Parse(r["mabd"].ToString()) + " and sttt=" + decimal.Parse(r["stt"].ToString())); } } row = m_v.getrowbyid(dsdm.Tables[0], "id=" + int.Parse(r["mabd"].ToString())); if (row != null) { lShow.Text = row["ten"].ToString() + " - - - - " + l_sttt.ToString(); } } this.Refresh(); } #endregion } MessageBox.Show(lan.Change_language_MessageText("Đã cập nhật thành công!"), m_v.s_AppName); }
private void btOK_Click(object sender, EventArgs e) { // chuyển tồn từ tháng được chọn sang tháng hiện tại // string angay1 = txtTN.Text; //string athang1 = angay1.Substring(3, 2); // string anam = m_v.s_curyyyy; if (!kiemTra()) { return; } string ammyy1 = txtTuMM.Value.ToString().PadLeft(2, '0') + txtTuYYYY.Value.ToString().Substring(2, 2); string ammyy = txtDenMM.Value.ToString().PadLeft(2, '0') + txtDenYYYY.Value.ToString().Substring(2, 2); DataSet ds = new DataSet(); string sql = "", sql1 = ""; Object ob = MessageBox.Show("Bạn có muốn chuyển tồn tháng " + txtTuMM.Value.ToString() + " năm " + txtTuYYYY.Value.ToString(), LibVP.AccessData.Msg, MessageBoxButtons.YesNo); if ((txtTuMM.Value == txtDenMM.Value) && (txtDenYYYY.Value == txtTuYYYY.Value)) { MessageBox.Show("Chuyển số liệu thành công !"); } else { if (ob.ToString() == "Yes") { if (m_v.bMmyy(ammyy1))//gam 12/09/2011 { sql1 = "select * from medibv" + ammyy1 + ".v_tontamung"; } else { MessageBox.Show(lanque.Change_language_MessageText("Số liệu tháng " + ammyy1.Substring(0, 2) + " năm " + ammyy1.Substring(2, 2) + " chưa tạo số liệu")); return; } try { ds = m_v.get_data(sql1); } catch { ds = null; } if (!m_v.bMmyy(ammyy))//gam 12/09/2011 { MessageBox.Show(lanque.Change_language_MessageText("Số liệu tháng " + ammyy.Substring(0, 2) + " năm " + ammyy.Substring(2, 2) + " chưa tạo số liệu")); return; } if (ds.Tables[0].Rows.Count == 0) { // kiểm tra nếu tháng này không có bảng v_tontamung thì insert từ bảng v_tamung sql = "insert into medibv" + ammyy + ".v_tontamung (id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra) "; sql += "select id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra from medibv" + ammyy1 + ".v_tamung a where a.done=0 and a.id not in (select id from medibv" + ammyy + ".v_tontamung) "; } else { // nếu có bảng v_tontamung nhưng không có dữ liệu thì insert từ bảng v_tamung if (ds.Tables[0].Rows.Count == 0) { sql = "insert into medibv" + ammyy + ".v_tontamung (id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra) "; sql += "select id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra from medibv" + ammyy1 + ".v_tamung a where a.done=0 and a.id not in (select id from medibv" + ammyy + ".v_tontamung) "; } // bảng v_tontamung có data thì insert từ v_tontamung và v_tamung else { sql = "insert into medibv" + ammyy + ".v_tontamung (id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra) "; sql += "select id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra from medibv" + ammyy1 + ".v_tontamung a where a.done=0 and a.id not in (select id from medibv" + ammyy + ".v_tontamung) "; sql += "union all select id,mabn,mavaovien,maql,idkhoa,quyenso,sobienlai,ngay,loai,makp,madoituong,sotien,ketoan,done,lanin,loaibn,idttrv,datru,userid,ngayud,ngaytra from medibv" + ammyy1 + ".v_tamung a where a.done=0 and a.id not in (select id from medibv" + ammyy + ".v_tontamung) "; } } try { m_v.execute_data(sql); } catch { MessageBox.Show("Chuyển số liệu không thành công !"); } MessageBox.Show("Chuyển số liệu thành công !"); } else { //MessageBox.Show("Yeu cau khong chuyen da chap nhan"); } }// end if((txtTuMM.Value == txtDenMM.Value) && (txtDenYYYY.Value == txtTuYYYY.Value)) }