void frm_DoWorkCompleted(object sender, RunWorkerCompletedEventArgs e)
{
butOk.Enabled = true;
butCancel.Enabled = true;
Cursor = Cursors.Default;
DoWorkCompleteParam rs = (DoWorkCompleteParam)e.Result;
((Form)sender).Close();
if (rs.errocode == 0)
{
//if (s != "") MessageBox.Show(lan.Change_language_MessageText("Những tháng sau chưa tạo số liệu :")+"\n" + s,LibMedi.AccessData.Msg);
MessageBox.Show(lan.Change_language_MessageText("Xong !"), LibMedi.AccessData.Msg);
}
else
{
MessageBox.Show(rs.ErrMes, LibMedi.AccessData.Msg);
}
}
void frm_DoWork(BackgroundWorker sender, DoWorkEventArgs e)
{
DoWorkParam arg = (DoWorkParam)e.Argument;
DoWorkCompleteParam result = new DoWorkCompleteParam();
e.Result = result;
string mmyy = "";//, s = "", sql = "";
string s_user = arg.m.user, xxx = "";
#region old
//if (i_userid == 0)
//{
// CreateTable ct = new CreateTable();
// try
// {
// ct.Create_table();
// MessageBox.Show(lan.Change_language_MessageText("Create table ok!"), LibMedi.AccessData.Msg);
// }
// catch { }
// try
// {
// ct.Create_table_mmyy(tu.Value.ToString().PadLeft(2, '0') + yyyy.Value.ToString().Substring(2));
// MessageBox.Show(lan.Change_language_MessageText("Create table mmyy ok!"), LibMedi.AccessData.Msg);
// }
// catch { }
//}
//m.Tao_Table(tu.Value.ToString().PadLeft(2, '0') + yyyy.Value.ToString().Substring(2));//linh 09072012
//m.Tao_Partition();
//if (b_taomoi)
//{
// m.tao_schema(tu.Value.ToString().PadLeft(2, '0') + yyyy.Value.ToString().Substring(2), i_userid);
//}
//else
//{
// 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);
// m.Tao_Partition(mmyy);
// if (m.bMmyy(mmyy))
// {
// //m.f_tangid_medibv_mmyy(mmyy);
// //linh 31052012
// //if(txtfile.Visible==false)
// m.f_capnhat_db_danhmuc("medisoft.exe");
// m.modify_schema(mmyy, i_userid);
// //else
// // 7 m.modify_schema(mmyy, i_userid,txtfile.Text);
// //
// xxx = s_user + mmyy;
// sql = "update " + xxx + ".d_xuatsdct set gia_bh=(select max(gia_bh) as gia_bh from " + s_user + ".d_dmbd where " + xxx + ".d_xuatsdct.mabd=" + s_user + ".d_dmbd.id) where gia_bh=0 and mabd in(select id from " + s_user + ".d_dmbd and gia_bh>0) ";
// m.execute_data(sql);
// sql = "update " + xxx + ".d_thucxuat set gia_bh=(select max(gia_bh) as gia_bh from " + s_user + ".d_dmbd where " + xxx + ".d_thucxuat.mabd=" + s_user + ".d_dmbd.id) where gia_bh=0 and mabd in(select id from " + s_user + ".d_dmbd and gia_bh>0) ";
// m.execute_data(sql);
// sql = "update " + xxx + ".d_tienthuoc set gia_bh=(select max(gia_bh) as gia_bh from " + s_user + ".d_dmbd where " + xxx + ".d_tienthuoc.mabd=" + s_user + ".d_dmbd.id) where gia_bh=0 and mabd in(select id from " + s_user + ".d_dmbd and gia_bh>0) ";
// m.execute_data(sql);
// sql = "CREATE TABLE " + s_user + ".dmloaict";
// sql += "(";
// sql += "id numeric(3) NOT NULL,";
// sql += "stt numeric(3),";
// sql += "ten text,";
// sql += "userid numeric(5),";
// sql += "ngayud timestamp without time zone DEFAULT now(),";
// sql += "chuyendi text DEFAULT '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::text,";
// sql += "CONSTRAINT pk_dmloaict PRIMARY KEY (id)";
// sql += ")";
// sql += "WITH (OIDS=TRUE);";
// sql += "ALTER TABLE " + s_user + ".dmloaict OWNER TO medisoft;\n";
// m.execute_data(sql);
// sql = "CREATE TABLE " + s_user + ".hachungtu";
// sql += "(";
// sql += "mabn character varying(10) NOT NULL,";
// sql += "mavaovien numeric(21) NOT NULL,";
// sql += "id_loaict numeric(3) NOT NULL,";
// sql += "duongdan text,";
// sql += "userid numeric(7),";
// sql += "ngayud timestamp without time zone DEFAULT now(),";
// sql += "chuyendi text DEFAULT '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::text,";
// sql += "CONSTRAINT pk_hachungtu PRIMARY KEY (mabn, mavaovien, id_loaict),";
// sql += "CONSTRAINT fk_hachungtu_dmloaict FOREIGN KEY (id_loaict) ";
// sql += "REFERENCES " + s_user + ".dmloaict (id) MATCH SIMPLE ";
// sql += "ON UPDATE NO ACTION ON DELETE NO ACTION ";
// sql += ")";
// sql += "WITH (OIDS=TRUE);";
// sql += "ALTER TABLE " + s_user + ".hachungtu OWNER TO medisoft;\n";
// m.execute_data(sql);
// #region cao vu 13/03/2013
// m.execute("alter table " + xxx + ".tttiepdon add mabsgioithieu varchar2(4) default '0'");
// m.execute("alter table " + xxx + ".tttiepdon add manvsale varchar2(4) default '0'");
// m.execute("alter table " + xxx + ".tttiepdon add idvung numeric(3) default 0");
// m.execute("create table " + s_user + ".dmvungsale"
// + "(id numeric(3) not null,"
// + "ten varchar2(254),"
// + "constraint pk_dmvungsale primary key(id));");
// m.execute("insert into " + s_user + ".dmvungsale(id,ten) values('0','KXD');");
// m.execute("alter table " + s_user + ".dmbschidinh drop column id;");
// m.execute("alter table " + s_user + ".dmbschidinh add column id serial;");
// m.execute("alter table " + s_user + ".dmbschidinh add constraint pk_dmbschidinh primary key(id);");
// m.execute("alter table " + s_user + ".dmbschidinh add mabs varchar2(4);");
// m.execute("alter table " + s_user + ".dmbschidinh add mabv varchar2(10) default '0';");
// m.execute("insert into " + s_user + ".tenvien(mabv,tenbv) values('0','KXD');");
// m.execute("alter table " + s_user + ".dmbschidinh add constraint fk_dmbschidinh_tenvien foreign key(mabv)"
// + " references " + s_user + ".tenvien(mabv);");
// m.execute("alter table " + s_user + ".dmbschidinh add manv varchar2(4) default '0';");
// m.execute("alter table " + s_user + ".dmbschidinh add constraint fk_dmbschidinh_dmbs foreign key(manv)"
// + " references " + s_user + ".dmbs(ma); ");
// m.execute("alter table " + s_user + ".dmbschidinh add idvung number(3) default 0;");
// m.execute("alter table " + s_user + ".dmbschidinh add constraint fk_dmbschidinh_dmvungsale foreign key(idvung)"
// + " references " + s_user + ".dmvungsale(idvung);");
// //
// sql = "CREATE TABLE medibv.thuchienylenh (id numeric(22) NOT NULL DEFAULT 0, ngay timestamp(3) ";
// sql += "without time zone DEFAULT now(), manv character varying(4), mach numeric(3) default 0,nhietdo ";
// sql += "numeric default 0, huyetap character varying(10), nhiptho numeric(3) default 0, dienbien text, thuchien ";
// sql += "text, chuyendi varchar(300) default lpad('0',300,'0'), makp varchar(3), userid int default 0, CONSTRAINT ";
// sql += "pk_thuchienylenh PRIMARY KEY (id)) WITH (OIDS=FALSE);";
// m.execute_data(sql);
// sql = "alter table "+xxx+".v_tamungcd add column no numeric(1) default 0;";
// m.execute_data(sql);
// #endregion
// }
// else s += mmyy.Substring(0, 2) + "/20" + mmyy.Substring(2, 2) + ";";
// }
//}
//f_capnhat_datinhchenhlech();
//f_capnhat_ngayylenh();//
//f_capnhat_xuatvien_paid();//
//m.CapNhat_dk_VuKeHoach();
////Thuy 02.06.2012
//m.modify_schema();
////end 02.06.2012
#endregion
CrTa = new CreateTableMMYY(arg.m);
AlTa = new AlterTableMMYY(arg.m);
for (int i = Convert.ToInt16(arg.tu); i <= Convert.ToInt16(arg.den); i++)
{
sender.ReportProgress(0);
mmyy = i.ToString().PadLeft(2, '0') + yyyy.Value.ToString().PadLeft(4, '0').Substring(2, 2);
xxx = s_user + mmyy;
if (mmyy.IndexOf("/") != -1)
{
result.errocode = 1;
result.ErrMes = "Tháng / năm " + mmyy + " không hợp lệ !";
return;
}
if (arg.m.bMmyy(mmyy))
{
//update lấy từ Bác đưa lần 1
// AlTa.AlterTable_MMYY(xxx);
AlTa.AlterTable_MMYY_Asyn(xxx, sender);
//Update lấy từ Bác lần 2
//AlTa.AlterTable_MMYY1(xxx, s_user);
//AlTa.AlterTable_MMYY2(xxx, s_user);
//Alter thêm từ ngày 27/09/2013
// AlTa.Altertable_MMYY3(xxx, s_user);
AlTa.Altertable_MMYY3_Asyn(xxx, s_user, sender);
}
else
{
sender.ReportProgress(0, "Chuẩn bị tạo schema " + xxx + "....");
sender.ReportProgress(5, "Tạo schema " + xxx + "....");
CrTa.CreateTable_MMYY_Asyn(xxx, sender);
//cap nhat cac file bo sung sau: binh 081113
// sender.ReportProgress(60, "Cập nhật Schema gốc...");
AlTa.Altertable_MMYY3_Asyn(xxx, s_user, sender);
arg.m.upd_table(mmyy, arg.user_id);
//
}
sender.ReportProgress(90, "Cập nhật function " + mmyy + "....");
arg.m.tao_function(mmyy);
sender.ReportProgress(99);
}
}
