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))
}