void btKet_Chuyen_Click(object sender, EventArgs e) { //KetChuyen frmKetChuyen_Run frm = new frmKetChuyen_Run(); frm.Tag = "Ket_Chuyen"; frm.numThang1.Value = Element.sysNgay_Ct1.Month; frm.numThang2.Value = Element.sysNgay_Ct2.Month; frm.Load(); if (!frm.isAccept) { return; } dteNgay_Ct1 = Library.StrToDate("01/" + frm.numThang1.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = Library.StrToDate("01/" + frm.numThang2.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = dteNgay_Ct2.AddMonths(1).AddDays(-1); iKetchuyen = true; EpointProcessBox.Show(this); }
void frmDmKetChuyen_View_KeyDown(object sender, KeyEventArgs e) { if (e.Control && e.KeyCode == Keys.A) { for (int i = 0; i < dtKetChuyen.Rows.Count; i++) { dtKetChuyen.Rows[i]["SELECT"] = true; } } else if (e.Control && e.KeyCode == Keys.U) { for (int i = 0; i < dtKetChuyen.Rows.Count; i++) { dtKetChuyen.Rows[i]["SELECT"] = false; } } else if (!e.Control && e.KeyCode == Keys.F10) { //KetChuyen frmKetChuyen_Run frm = new frmKetChuyen_Run(); frm.Tag = "Ket_Chuyen"; frm.numThang1.Value = Element.sysNgay_Ct1.Month; frm.numThang2.Value = Element.sysNgay_Ct2.Month; frm.Load(); if (!frm.isAccept) { return; } dteNgay_Ct1 = Library.StrToDate("01/" + frm.numThang1.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = Library.StrToDate("01/" + frm.numThang2.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = dteNgay_Ct2.AddMonths(1).AddDays(-1); iKetchuyen = true; EpointProcessBox.Show(this); } else if (e.Control && e.KeyCode == Keys.F10) { //KetChuyen_Delete(); frmKetChuyen_Run frm = new frmKetChuyen_Run(); frm.Tag = "Ket_Chuyen"; frm.numThang1.Value = Element.sysNgay_Ct1.Month; frm.numThang2.Value = Element.sysNgay_Ct2.Month; frm.Load(); if (!frm.isAccept) { return; } dteNgay_Ct1 = Library.StrToDate("01/" + frm.numThang1.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = Library.StrToDate("01/" + frm.numThang2.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = dteNgay_Ct2.AddMonths(1).AddDays(-1); iKetchuyen = false; EpointProcessBox.Show(this); } else if (e.KeyCode == Keys.Space) { ((DataRowView)bdsKetChuyen.Current).Row["Select"] = !(bool)((DataRowView)bdsKetChuyen.Current).Row["Select"]; } }
private void KetChuyenPb() { dgvKetChuyenPb.EndEdit(); bdsKetChuyenPb.EndEdit(); if (Common.GetPartitionCurrent() != 0 && Common.GetPartitionCurrent() != Element.sysWorkingYear) { Common.MsgCancel("Phải chuyển về phân vùng dữ liệu " + Element.sysWorkingYear.ToString() + "!"); return; } frmKetChuyen_Run frm = new frmKetChuyen_Run(); frm.Tag = "Ket_Chuyen"; frm.numThang1.Value = this.numThang1.Value; frm.numThang2.Value = this.numThang2.Value; frm.Load(); if (!frm.isAccept) { return; } DateTime dteNgay_Ct1 = Library.StrToDate("01/" + frm.numThang1.Value + "/" + Element.sysWorkingYear); DateTime dteNgay_Ct2 = Library.StrToDate("01/" + frm.numThang2.Value + "/" + Element.sysWorkingYear); dteNgay_Ct2 = dteNgay_Ct2.AddMonths(1).AddDays(-1); if (!Common.CheckDataLocked(dteNgay_Ct1)) { Common.MsgCancel("Dữ liệu đã khóa, liên hệ với nhà quản trị!"); return; } foreach (DataRow dr in dtKetChuyenPb.Rows) { if ((bool)dr["SELECT"] == false) { continue; } Hashtable ht = new Hashtable(); ht["NGAY_CT1"] = dteNgay_Ct1; ht["NGAY_CT2"] = dteNgay_Ct2; ht["STT"] = dr["Stt"]; ht["TK"] = dr["Tk"]; ht["TK_DU_DEN"] = dr["Tk_Du_Den"]; ht["DIEN_GIAI"] = dr["Dien_Giai"]; ht["NO_CO_AUTO"] = dr["No_Co_Auto"]; ht["PS_DU"] = dr["Ps_Du"]; ht["LOAI_KC"] = dr["Loai_Kc"]; ht["MA_CT"] = "TD"; ht["MA_DVCS"] = Element.sysMa_DvCs; Common.ShowStatus(Languages.GetLanguage("In_Process") + (string)dr["Dien_Giai"]); //SQLExec.Execute("Sp_KetChuyen_Delete", ht, CommandType.StoredProcedure); if ((string)dr["Loai_Kc"] == "1") { SQLExec.Execute("Sp_KetChuyenPb1", ht, CommandType.StoredProcedure); } else if ((string)dr["Loai_Kc"] == "2") { SQLExec.Execute("Sp_KetChuyenPb2", ht, CommandType.StoredProcedure); } dr["Select"] = false; } Common.EndShowStatus(); Common.MsgOk(Languages.GetLanguage("End_Process")); }