public static void Sync_Send_Data() { //Sync Hashtable htPara = new Hashtable(); if (Collection.Parameters.ContainsKey("SYNC_SERVER")) { htPara.Add("SERVER", Collection.Parameters["SYNC_SERVER"]); } if (Collection.Parameters.ContainsKey("SYNC_DBSOURCE")) { htPara.Add("DBSOURCE", Collection.Parameters["SYNC_DBSOURCE"]); } if (Collection.Parameters.ContainsKey("SYNC_DBDEST")) { htPara.Add("DBDEST", Collection.Parameters["SYNC_DBDEST"]); } if (Collection.Parameters.ContainsKey("SYNC_USER")) { htPara.Add("USER", Collection.Parameters["SYNC_USER"]); } if (Collection.Parameters.ContainsKey("SYNC_PASS")) { htPara.Add("PASS", Collection.Parameters["SYNC_PASS"]); } htPara.Add("MA_DVCS", Element.sysMa_DvCs); //Begin Sync List string strSQLExec_List = "SELECT *, " + " CAST(0 AS BIT) AS Is_Receive " + //--Is_Send: đã lưu trong CSDL " FROM SYSSYNCLIST ORDER BY Stt"; DataTable dtTranList = SQLExec.ExecuteReturnDt(strSQLExec_List); foreach (DataRow dr in dtTranList.Rows) { if ((bool)dr["IS_SEND"]) { htPara["TABLE_NAME"] = dr["Table_Name"].ToString(); htPara["NAM"] = Element.sysWorkingYear; //EpointProcessBox.AddMessage("Sync List "); SQLExec.Execute("sp_Sync_Send_List", htPara, CommandType.StoredProcedure); } } //Begin Sync Voucher string strSQLExec_Voucher = "SELECT *, " + " CAST(0 AS BIT) AS Is_Receive " + //--Is_Send: đã lưu trong CSDL " FROM SYSSYNCVOUCHER ORDER BY Stt"; DataTable dtTranVoucher = SQLExec.ExecuteReturnDt(strSQLExec_Voucher); foreach (DataRow dr in dtTranVoucher.Rows) { if ((bool)dr["IS_SEND"]) { htPara["MA_CT"] = dr["Ma_Ct"].ToString(); htPara["TABLE_NAME"] = dr["Table_Name"].ToString(); htPara["NAM"] = Element.sysWorkingYear; //EpointProcessBox.AddMessage("Sync Voucher "); SQLExec.Execute("sp_Sync_Send_Voucher", htPara, CommandType.StoredProcedure); } } //EpointProcessBox.AddMessage(Languages.GetLanguage("End_Process")); }
private void FillThanhToanFromEditCt() { double dbTien; double dbTien_Nt; Voucher.Update_Detail(this.frmEditCt); string strSQLExec = "\r\n\t\t\t\t\tSELECT TOP 0 Stt_PT, Ma_Ct_PT, Ngay_Ct_PT, So_Ct_PT, Tk, Ma_Dt, Ma_Tte_PT, Ty_Gia_PT, Tien_PT, Tien_PT_Nt, Dien_Giai_PT, CAST(0 AS BIT) AS Is_UngTruoc \r\n\t\t\t\t\t FROM vw_ThanhToan \r\n\t\t\t\t\t\tWHERE 0 = 1"; this.dtThanhToan = SQLExec.ExecuteReturnDt(strSQLExec); string strTkHanTt = "," + ((string)Parameters.GetParaValue("TK_HANTT_LIST")); DataRow[] rowArray = this.frmEditCt.dtEditCt.Select("Deleted = false"); bool bIs_UngTruoc = false; foreach (DataRow row in rowArray) { string strTk_No; string strTk_Co; string strMa_Dt; string strMa_Dt_Co; if (row.Table.Columns.Contains("TIEN")) { strTk_No = ((string)row["Tk_No"]).Trim(); strTk_Co = ((string)row["Tk_Co"]).Trim(); strMa_Dt = ((string)row["Ma_Dt"]).Trim(); string strMa_Ct = ((string)row["Ma_Ct"]).Trim(); dbTien = Convert.ToDouble(row["Tien"]); dbTien_Nt = Convert.ToDouble(row["Tien_Nt"]); if (row.Table.Columns.Contains("Is_UngTruoc")) { bIs_UngTruoc = (bool)row["Is_UngTruoc"]; } if (row.Table.Columns.Contains("Ma_Dt_Co") && (((string)row["Ma_Dt_Co"]) != string.Empty)) { strMa_Dt_Co = (string)row["Ma_Dt_Co"]; } else { strMa_Dt_Co = strMa_Dt; } if ((strTk_No != string.Empty) && (strTk_Co != string.Empty)) { if (strTkHanTt.Contains("," + strTk_No.Substring(0, 3)) && (this.frmEditCt.dtEditCt.Select("Tk_No LIKE '" + strTk_No + "%' AND Han_Tt = 0").Length > 0)) { this.SaveToHanTt(strTk_No, strMa_Dt, dbTien, dbTien_Nt, "N", bIs_UngTruoc); } if (strTkHanTt.Contains("," + strTk_Co.Substring(0, 3))) { if ((strMa_Ct == "BT") && this.frmEditCt.dtEditCt.Columns.Contains("Han_Tt_Co")) { if (this.frmEditCt.dtEditCt.Select("Tk_Co LIKE '" + strTk_Co + "%' AND Han_Tt_Co = 0").Length > 0) { this.SaveToHanTt(strTk_Co, strMa_Dt_Co, dbTien, dbTien_Nt, "C", bIs_UngTruoc); } } else if (this.frmEditCt.dtEditCt.Select("Tk_Co LIKE '" + strTk_Co + "%' AND Han_Tt = 0").Length > 0) { this.SaveToHanTt(strTk_Co, strMa_Dt_Co, dbTien, dbTien_Nt, "C", bIs_UngTruoc); } } } } if (row.Table.Columns.Contains("TIEN3")) { strTk_No = ((string)row["Tk_No3"]).Trim(); strTk_Co = ((string)row["Tk_Co3"]).Trim(); strMa_Dt = ((string)row["Ma_Dt"]).Trim(); dbTien = Convert.ToDouble(row["Tien3"]); dbTien_Nt = Convert.ToDouble(row["Tien_Nt3"]); if (row.Table.Columns.Contains("Ma_Dt_Co") && (((string)row["Ma_Dt_Co"]) != string.Empty)) { strMa_Dt_Co = (string)row["Ma_Dt_Co"]; } else { strMa_Dt_Co = strMa_Dt; } if ((strTk_No != string.Empty) && (strTk_Co != string.Empty)) { if (strTkHanTt.Contains("," + strTk_No.Substring(0, 3)) && (this.frmEditCt.dtEditCt.Select("Tk_No LIKE '" + strTk_No + "%' AND Han_Tt = 0").Length > 0)) { this.SaveToHanTt(strTk_No, strMa_Dt, dbTien, dbTien_Nt, "N", bIs_UngTruoc); } if (strTkHanTt.Contains("," + strTk_Co.Substring(0, 3)) && (this.frmEditCt.dtEditCt.Select("Tk_Co LIKE '" + strTk_Co + "%' AND Han_Tt = 0").Length > 0)) { this.SaveToHanTt(strTk_Co, strMa_Dt_Co, dbTien, dbTien_Nt, "C", bIs_UngTruoc); } } } } foreach (DataRow row in this.dtThanhToan.Rows) { dbTien = Convert.ToDouble(row["Tien_PT"]); dbTien_Nt = Convert.ToDouble(row["Tien_PT_Nt"]); if ((dbTien != dbTien_Nt) && (dbTien_Nt != 0.0)) { row["Ty_Gia_PT"] = Math.Round((double)(dbTien / dbTien_Nt), 0, MidpointRounding.AwayFromZero); } } this.dgvThanhToan.DataSource = this.bdsThanhToan; this.bdsThanhToan.DataSource = this.dtThanhToan; }
private void KetChuyen() { dgvKetChuyen.EndEdit(); bdsKetChuyen.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 = Element.sysNgay_Ct1.Month; //frm.numThang2.Value = Element.sysNgay_Ct2.Month; //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); EpointProcessBox.setMaxValue(dgvKetChuyen.Rows.Count); if (!Common.CheckDataLocked(dteNgay_Ct1)) { //Common.MsgCancel("Dữ liệu đã khóa, liên hệ với nhà quản trị!"); EpointProcessBox.AddMessage(EpointMessage.GetMessage("DATALOCK")); return; } foreach (DataRow dr in dtKetChuyen.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["MA_CT"] = "TD"; ht["CREATE_LOG"] = "30" + dteNgay_Ct2.Year.ToString() + ":120000:" + Element.sysUser_Id; ht["MA_DVCS"] = Element.sysMa_DvCs; //Common.ShowStatus(Languages.GetLanguage("In_Process") + (string)dr["Dien_Giai"]); EpointProcessBox.AddMessage(Languages.GetLanguage("In_Process") + (string)dr["Dien_Giai"]); SQLExec.Execute("Sp_KetChuyen_Delete", ht, CommandType.StoredProcedure); SQLExec.Execute("Sp_KetChuyen", ht, CommandType.StoredProcedure); dr["Select"] = false; } //Common.EndShowStatus(); //Common.MsgOk(Languages.GetLanguage("End_Process")); EpointProcessBox.AddMessage(Languages.GetLanguage("End_Process")); }
public override bool Save() { Common.GatherMemvar(this, ref drEdit); //Kiem tra Valid tren Form if (!FormCheckValid()) { return(false); } drEdit["Nam"] = Element.sysWorkingYear; drEdit["Ma_DvCs"] = Element.sysMa_DvCs; if (enuNew_Edit == enuEdit.New) { drEdit["Create_Log"] = Common.GetCurrent_Log(); } else { drEdit["LastModify_Log"] = Common.GetCurrent_Log(); } if (this.enuNew_Edit == enuEdit.New) { drEdit["Stt"] = Common.GetNewStt("08", true); while (DataTool.SQLCheckExist("vw_HanTt", "Stt", drEdit["Stt"])) { drEdit["Stt"] = Common.GetNewStt("08", true); } } if (txtMa_Tte.Text == Element.sysMa_Tte) { drEdit["Ty_Gia"] = 1; drEdit["Tien_No_Nt0"] = 0; drEdit["Tien_Tt_Nt0"] = 0; drEdit["Tien_No_Nt"] = 0; } if (!DataTool.SQLUpdate(this.enuNew_Edit, "GLDUDAUHANTT", ref drEdit)) { return(false); } if (Common.InlistLike(txtTk.Text, this.Tk_List)) { Hashtable htPara = new Hashtable(); htPara["MA_DVCS"] = Element.sysMa_DvCs; htPara["STT"] = drEdit["Stt"].ToString(); htPara["IS_UPDATE"] = "N"; SQLExec.Execute("sp_UpdateSdHantt", htPara, CommandType.StoredProcedure); } // if (chkIs_UngTruoc.Checked) // {//Ứng trước // if (enuNew_Edit == enuEdit.Edit) // { // string strSQLExec = @"IF EXISTS (SELECT Stt FROM vw_HanTt WHERE Stt = '" + (string)drEdit["Stt"] + @"' AND Is_SoDuDau = 1) // DELETE vw_HanTt WHERE Stt = '" + (string)drEdit["Stt"] + @"' AND Is_SoDuDau = 1"; // SQLExec.Execute(strSQLExec); // } // if (!DataTool.SQLUpdate(this.enuNew_Edit, "R80UNGTRUOC", ref drEdit)) // return false; // } // else // {// HanTt // if (enuNew_Edit == enuEdit.Edit) // { // string strSQLExec = @"IF EXISTS (SELECT Stt FROM R80UNGTRUOC WHERE Stt = '" + (string)drEdit["Stt"] + @"' AND Is_SoDuDau = 1) // DELETE R80UNGTRUOC WHERE Stt = '" + (string)drEdit["Stt"] + @"' AND Is_SoDuDau = 1"; // SQLExec.Execute(strSQLExec); // } // if (!DataTool.SQLUpdate(this.enuNew_Edit, "vw_HanTt", ref drEdit)) // return false; // } return(true); }
private void Ma_Tte_Valid() { string strMa_Tte = txtMa_Tte.Text.Trim(); if (Common.Inlist(this.strMa_Ct, (string)Epoint.Systems.Librarys.Parameters.GetParaValue("CT_LOCKED_EXCHANGE"))) { numTy_Gia.Enabled = false; } else { numTy_Gia.Enabled = true; } if (Element.sysMa_Tte == strMa_Tte) { numTy_Gia.Value = 1; numTy_Gia.bReadOnly = true; this.pnlTTien.Visible = false; this.pnlTTien_Nt.Left = this.pnlTTien.Right - this.pnlTTien_Nt.Width; if (dgvEditCt1.Columns.Contains("TIEN")) { dgvEditCt1.Columns["TIEN"].Visible = false; } //if (dgvEditCt2.Columns.Contains("TIEN3")) // dgvEditCt2.Columns["TIEN3"].Visible = false; if (dgvEditCt1.Columns.Contains("TIEN5")) { dgvEditCt1.Columns["TIEN5"].Visible = false; } } else { numTy_Gia.bReadOnly = false; if (dteNgay_Ct.Text != Library.DateToStr((DateTime)drEditPh["Ngay_Ct"]) || txtMa_Tte.bTextChange) { Hashtable ht = new Hashtable(); ht.Add("NGAY_CT", Library.StrToDate(dteNgay_Ct.Text)); ht.Add("MA_TTE", strMa_Tte); numTy_Gia.Value = Convert.ToDouble(SQLExec.ExecuteReturnValue("sp_GetTyGia", ht, CommandType.StoredProcedure)); } this.pnlTTien.Visible = true; this.pnlTTien_Nt.Left = this.pnlTTien.Left - this.pnlTTien_Nt.Width; if (dgvEditCt1.Columns.Contains("TIEN")) { dgvEditCt1.Columns["TIEN"].Visible = true; } //if (dgvEditCt2.Columns.Contains("TIEN3")) // dgvEditCt2.Columns["TIEN3"].Visible = true; if (dgvEditCt1.Columns.Contains("TIEN5")) { dgvEditCt1.Columns["TIEN5"].Visible = true; } } if (dteNgay_Ct.Text != Library.DateToStr((DateTime)drEditPh["Ngay_Ct"]) || txtMa_Tte.bTextChange || numTy_Gia.bTextChange) { Voucher.Update_Detail(this); Voucher.Calc_Tien_All(this); Voucher.Adjust_TThue_Vat(this, true); if (txtMa_Tte.bTextChange) { txtMa_Tte.bTextChange = false; } } numTTien_Nt.Scale = numTTien_Nt0.Scale = numTTien_Nt3.Scale = strMa_Tte == Element.sysMa_Tte ? 0 : 2; Voucher.FormatTien_Nt(dgvEditCt1, strMa_Tte); dgvEditCt1.ResizeGridView(); }
/* * public virtual void Import_Excel() * { * string strTableName = "INDUDAU"; * * int iSttIdent = (Int32)SQLExec.ExecuteReturnValue("SELECT ISNULL(MAX(Ident00),1) FROM " + strTableName); * OpenFileDialog ofdlg = new OpenFileDialog(); * * ofdlg.DefaultExt = "xls"; * ofdlg.Filter = "*.xls|*.xls"; * * if (ofdlg.ShowDialog() != DialogResult.OK) * return; * * string probeConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0; * Data Source= " + ofdlg.FileName + ";" + * "Extended Properties=\"Excel 8.0;HDR=YES\""; * * using (OleDbConnection probeConn = new OleDbConnection(probeConnStr)) * { * probeConn.Open(); * string probe = "SELECT * FROM [Sheet1$] " + //Sheet1$A1:A65536 * "Where Ma_Kho IS NOT NULL AND Ma_Vt IS NOT NULL"; * * using (OleDbDataAdapter oleDbDapter = new OleDbDataAdapter(probe, probeConn)) * { * DataTable tbExcel = new DataTable(); * oleDbDapter.Fill(tbExcel); * * DataTable dtStruct = DataTool.SQLGetDataTable(strTableName, "TOP 0 * ", " 0 = 1", null); * DataTable dtStruct2 = dtStruct.Clone(); * DataRow drNewRow = dtStruct.NewRow(); * dtStruct.Rows.Add(drNewRow); * * foreach (DataColumn dc in dtStruct2.Columns) * if (dc.DataType.ToString() == "System.Byte[]") * { * dtStruct.Columns.Remove(dc.ColumnName); * dtStruct.AcceptChanges(); * } * * * //if (drNewRow.Table.Columns.Contains("Hinh")) * //{ * // drNewRow.Table.Columns.Remove("Hinh"); * // drNewRow.Table.AcceptChanges(); * //} * * Common.SetDefaultDataRow(ref drNewRow); * * string strMsg = (Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có muốn ghi đè lên dữ liệu đã tồn tại không" : "Do you want to override exists data"); * bool bIs_Overide = Common.MsgYes_No(strMsg); * * foreach (DataRow drExcel in tbExcel.Rows) * { * Common.CopyDataRow(drExcel, drNewRow); * string strStt = iSttIdent.ToString().Trim().PadLeft(10, '0'); * drNewRow["Stt"] = Element.sysMa_DvCs + "80" + strStt; * drNewRow.AcceptChanges(); * * //if (bIs_Overide && DataTool.SQLCheckExist(strTableName, "Stt", (string)drExcel["Stt"])) * // DataTool.SQLUpdate(enuEdit.Edit, strTableName, ref drNewRow); * //else * DataTool.SQLUpdate(enuEdit.New, strTableName, ref drNewRow); * iSttIdent++; * } * } * } * * //Type type = this.GetType(); * //type.InvokeMember("FillData", BindingFlags.InvokeMethod, null, this, null); * FillData(); * Common.MsgOk(Languages.GetLanguage("End_Process")); * } * */ private void Import_Excel() { string strTableName = "INDUDAU"; //OpenFileDialog dialog = new OpenFileDialog //{ // DefaultExt = "xls", // Filter = "*.xls|*.xls" //}; OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = "xls files (*.xls;*.xlsx)|*.xls;*.xlsx"; dialog.RestoreDirectory = true; if (dialog.ShowDialog() == DialogResult.OK) { string strConnectString = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + dialog.FileName; int num = 0; using (OdbcConnection connection = new OdbcConnection(strConnectString)) { connection.Open(); string selectCommandText = "SELECT * FROM [Sheet1$] Where Ma_Kho IS NOT NULL AND Ma_Vt IS NOT NULL "; using (OdbcDataAdapter adapter = new OdbcDataAdapter(selectCommandText, connection)) { DataTable dataTable = new DataTable(); adapter.Fill(dataTable); DataTable table2 = DataTool.SQLGetDataTable(strTableName, "TOP 0 * ", " 0 = 1", null); DataTable table3 = table2.Clone(); DataRow row = table2.NewRow(); table2.Rows.Add(row); Common.SetDefaultDataRow(ref row); bool flag = false; bool flag2 = false; foreach (DataRow row2 in dataTable.Rows) { Common.CopyDataRow(row2, row); row.AcceptChanges(); row["Stt"] = Common.GetNewStt("08", true); if (DataTool.SQLCheckExist(strTableName, new string[] { "Ma_DvCs", "Ma_Kho", "Ma_Vt" }, new object[] { Element.sysMa_DvCs, row["Ma_Kho"], row["Ma_Vt"] })) { if (!flag) { string strMsg = (Element.sysLanguage == enuLanguageType.Vietnamese) ? "Bạn có ghi đè dữ liệu đã tồn tại ?" : "Do you want to override exists data ?"; flag2 = Common.MsgYes_No(strMsg); flag = true; } if (flag2) { if (row.Table.Columns.Contains("Ident00")) { DataRow row3 = SQLExec.ExecuteReturnDt("SELECT * FROM " + strTableName + " WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Kho = '" + row["Ma_Kho"].ToString() + "' AND Ma_Vt = '" + row["Ma_Vt"].ToString() + "'").Rows[0]; if (row != null) { row["Ident00"] = row3["Ident00"]; } } DataTool.SQLUpdate(enuEdit.Edit, strTableName, ref row); num++; } } else { DataTool.SQLUpdate(enuEdit.New, strTableName, ref row); num++; } } } } SQLExec.Execute("update INDUDAU set Ma_Kho = RTRIM(LTRIM(Ma_Kho)) , Ma_Vt = RTRIM(LTRIM(Ma_Vt))"); this.EnterValid(); Common.MsgOk(Languages.GetLanguage("End_Process") + " " + num.ToString() + " dòng được cập nhật"); } /* * if (dialog.ShowDialog() == DialogResult.OK) * { * string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;\r\n\t\t\t\t\t\tData Source= " + dialog.FileName + ";Extended Properties=\"Excel 8.0;HDR=YES\""; * int num = 0; * using (OleDbConnection connection = new OleDbConnection(connectionString)) * { * connection.Open(); * string selectCommandText = "SELECT * FROM [Sheet1$] Where Ma_Kho IS NOT NULL AND Ma_Vt IS NOT NULL "; * using (OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommandText, connection)) * { * DataTable dataTable = new DataTable(); * adapter.Fill(dataTable); * DataTable table2 = DataTool.SQLGetDataTable(strTableName, "TOP 0 * ", " 0 = 1", null); * DataTable table3 = table2.Clone(); * DataRow row = table2.NewRow(); * table2.Rows.Add(row); * Common.SetDefaultDataRow(ref row); * bool flag = false; * bool flag2 = false; * foreach (DataRow row2 in dataTable.Rows) * { * Common.CopyDataRow(row2, row); * row.AcceptChanges(); * row["Stt"] = Common.GetNewStt("08", true); * if (DataTool.SQLCheckExist(strTableName, new string[] { "Ma_DvCs", "Ma_Kho", "Ma_Vt" }, new object[] { Element.sysMa_DvCs, row["Ma_Kho"], row["Ma_Vt"] })) * { * if (!flag) * { * string strMsg = (Element.sysLanguage == enuLanguageType.Vietnamese) ? "Bạn có ghi đè dữ liệu đã tồn tại ?" : "Do you want to override exists data ?"; * flag2 = Common.MsgYes_No(strMsg); * flag = true; * } * if (flag2) * { * if (row.Table.Columns.Contains("Ident00")) * { * DataRow row3 = SQLExec.ExecuteReturnDt("SELECT * FROM " + strTableName + " WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Kho = '" + row["Ma_Kho"].ToString() + "' AND Ma_Vt = '" + row["Ma_Vt"].ToString() + "'").Rows[0]; * if (row != null) * { * row["Ident00"] = row3["Ident00"]; * } * } * DataTool.SQLUpdate(enuEdit.Edit, strTableName, ref row); * num++; * } * } * else * { * DataTool.SQLUpdate(enuEdit.New, strTableName, ref row); * num++; * } * } * } * } * * SQLExec.Execute("update INDUDAU set Ma_Kho = RTRIM(LTRIM(Ma_Kho)) , Ma_Vt = RTRIM(LTRIM(Ma_Vt))"); * * this.EnterValid(); * Common.MsgOk(Languages.GetLanguage("End_Process") + " " + num.ToString() + " dòng được cập nhật"); * } */ }
private void DeletePXKDetail() { if (bdsPXK.Position < 0) { return; } DataRow drCurrent = ((DataRowView)bdsPXKDetail.Current).Row; if (!Common.CheckPermission(this.Object_ID, enuPermission_Type.Allow_Edit)) { EpointMessage.MsgOk("Không có quyền sửa Phiếu xuất"); return; } if (Voucher.CheckDataLockedCtHanTtHD((string)drCurrent["Stt"])) { //if (!Common.MsgYes_No("Chứng từ đã được thanh toán . Bạn có muốn xóa thanh toán của chứng từ này !")) // return; if (strOptionMsg == "Y") { EpointMessage.MsgOk(" Chứng từ đã được thanh toán. không thể xóa!"); return; } else { if (!Common.MsgYes_No("Các chứng từ thanh toán thuộc phiếu xuất kho sẽ bị hủy !" + Languages.GetLanguage("SURE_DELETE"))) { return; } } } else if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE") + " Chi tiết phiếu xuất")) { return; } Hashtable htPara = new Hashtable(); htPara["MA_PX"] = drCurrent["MA_PX"].ToString(); htPara["STT"] = drCurrent["STT"].ToString(); htPara["USERID"] = Element.sysUser_Id; htPara["MA_DVCS"] = Element.sysMa_DvCs; //if (DataTool.SQLDelete("OM_PXKDetail",drCurrent)) if (SQLExec.Execute("sp_Delete_PXKDetail", htPara, CommandType.StoredProcedure)) { bdsPXKDetail.RemoveAt(bdsPXKDetail.Position); dtPXKDetail.AcceptChanges(); FillData(); //bdsPXK.Position = bdsPXK.Find("Ma_PX", this.strMa_PX); } else { EpointMessage.MsgOk("Không xóa được chi tiết"); } }
private string Tao_Pt() { int Stt0 = 0; string strSo_Ct = string.Empty; string strSo_Ct_New = string.Empty; string strCreate_Log = string.Empty; string strCt_Di_Kem = string.Empty; string strQueryPh = string.Empty; string strQueryCthd = string.Empty; string iStt = string.Empty; try { #region GetNew_SoCt DataRow drDmct = DataTool.SQLGetDataRowByID("SYSDMCT", "Ma_Ct", "PTT"); DataRow dr = SQLExec.ExecuteReturnDt("SELECT Ma_DvCs FROM SYSDMDVCS WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' ").Rows[0]; DateTime dteNgay_Ct_tt = Library.StrToDate(dteNgay_Ct_TT.Text); string strSQLExec = "SELECT So_Ct FROM GLVOUCHER (NOLOCK) WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Ct = 'PTT' AND MONTH(Ngay_Ct) =" + dteNgay_Ct_tt.Month.ToString() + " AND Ngay_Ct ='" + Library.DateToStr(dteNgay_Ct_tt) + "' AND So_Ct <> '' "; //+ " AND DAY(Ngay_Ct) =" + dteNgay_Ct1.Day.ToString() DataTable dt = SQLExec.ExecuteReturnDt(strSQLExec); if (dt.Rows.Count > 0) { string strSQL = "SELECT ISNULL(MAX(So_Ct),'') FROM GLVOUCHER (NOLOCK) WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Ct = 'PTT' AND MONTH(Ngay_Ct) =" + dteNgay_Ct_tt.Month.ToString() + " AND YEAR(Ngay_Ct) =" + dteNgay_Ct_tt.Year.ToString() + ""; strSo_Ct = SQLExec.ExecuteReturnValue(strSQL).ToString(); Hashtable htPara = new Hashtable(); htPara.Add("TABLENAME", "GLVOUCHER"); htPara.Add("COLUMNNAME", "So_Ct"); htPara.Add("CURRENTID", strSo_Ct); htPara.Add("KEY", "Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Ct = 'PTT' AND Ngay_Ct ='" + Library.DateToStr(dteNgay_Ct_tt) + "' AND YEAR(Ngay_Ct) = " + dteNgay_Ct_tt.Year + ""); htPara.Add("PREFIXLEN", Convert.ToInt32(drDmct["PrefixLen"])); htPara.Add("SUFFIXLEN", Convert.ToInt32(drDmct["SubfixLen"])); strSo_Ct_New = (string)SQLExec.ExecuteReturnValue("sp_GetNewID", htPara, CommandType.StoredProcedure); //strSo_Ct_New = drDmct["Prefix"].ToString() + dteNgay_Ct_tt.Month.ToString("00") + dteNgay_Ct_tt.Day.ToString("00") + strSo_Ct_New.Substring(strSo_Ct_New.Length - 4, 4); } else { strSo_Ct_New = "PTT" + dteNgay_Ct_tt.Month.ToString("00") + dteNgay_Ct_tt.Day.ToString("00") + "0001"; } #endregion strCreate_Log = Common.GetCurrent_Log(); bool bSttValid = false; while (!bSttValid) { iStt = Common.GetNewStt("01", true); string strPH = @"SELECT * FROM GLVOUCHER (NOLOCK) WHERE Stt= '" + iStt + "'"; DataTable dtCtph = SQLExec.ExecuteReturnDt(strPH); if (dtCtph.Rows.Count > 0) { bSttValid = false; } else { bSttValid = true; } } double dbTien0 = Convert.ToDouble(numTTien_Tt.Value); double dbTien3 = 0; //double dbTTien = dbTien0 + dbTien3; double dbThue = 0; foreach (DataRow drhd in dtCtHanTt.Rows) { if ((bool)drhd["Thanh_Toan"]) { Stt0 += 1; DataRow drDt = DataTool.SQLGetDataRowByID("LIDOITUONG", "Ma_Dt", drhd["Ma_Dt"].ToString()); strQueryCthd += @"INSERT INTO CATIEN (Stt, Stt0, Ma_Ct, Ngay_Ct, So_Ct, Dien_Giai, Ong_Ba, Ma_Dt,Ten_DtGtGt,Ma_Cbnv,Ma_Cbnv_Gh,Dia_Chi, Tk_No, Tk_Co, Tien_Nt9, Tien, Tien_Nt, Ma_Thue, Thue_GtGt, Tien3, Tien_Nt3, Tk_No3, Tk_Co3, Ngay_Ct0, So_Ct0, So_Seri0, Ma_So_Thue, Ma_Dvcs, Ma_Tte, Ty_Gia)" + @" VALUES('" + iStt + "', '" + Stt0 + "', 'PTT', '" + dteNgay_Ct_TT.Text + "','" + strSo_Ct_New + "', N'" + txtDien_Giai.Text + " - Số Ct : " + drhd["So_Ct_Hd"] + "', N'" + drDt["Ong_Ba"] + "', '" + drhd["Ma_Dt"] + "',N'" + drhd["So_Ct_Hd"] + "','" + drhd["MA_CBNV_Bh"] + "','" + drhd["MA_CBNV_GH"] + "',N'" + drDt["Dia_Chi"] + "','" + txtTk_Tt.Text + "','" + drhd["Tk"] + "', " + drhd["Tien_Tt1"] + ", " + drhd["Tien_Tt1"] + ", " + drhd["Tien_Tt1"] + ", '', 0, 0, 0, '', '', '', '', '', '', '" + Element.sysMa_DvCs + "','VND', 1)\n"; //strCt_Di_Kem += drhd["So_Ct_Hd"].ToString() + ","; } } strQueryPh = @" INSERT INTO GLVOUCHER (Stt, Ma_Ct, Ngay_Ct, So_Ct, Ma_Dt, Dien_giai, TTien0, TTien_Nt0, TTien3, TTien_Nt3, Create_Log, Ct_Di_Kem,Is_ThanhToan,Ma_Nvu, Ma_Dvcs) VALUES('" + iStt + "', 'PTT', '" + Library.DateToStr(dteNgay_Ct_tt) + "', '" + strSo_Ct_New + "', '" + txtMa_Dt.Text + "', N'" + txtDien_Giai.Text + "', " + dbTien0 + ", " + dbTien0 + ", " + dbTien3 + ", " + dbTien3 + ", '" + strCreate_Log + "', '" + strCt_Di_Kem + "',1,'PTT', '" + Element.sysMa_DvCs + "')"; if (numTTien_Tt.Value > 0) { if (SQLExec.Execute(strQueryPh) && SQLExec.Execute(strQueryCthd)) { EpointProcessBox.AddMessage("Chứng từ đã tạo xong Số chứng từ : " + strSo_Ct_New); this.strStt_Pt = iStt; this.strSo_Ct_New = strSo_Ct_New; return(iStt); } } return(string.Empty);; } catch (Exception ex) { EpointProcessBox.AddMessage(ex.ToString()); return(string.Empty); // throw; } }
private string Tao_Pt_TheoKH() { int Stt0 = 0; string strSo_Ct = string.Empty; string strSo_Ct_New = string.Empty; string strCreate_Log = string.Empty; string iStt = string.Empty; try { foreach (DataRow drhd in dtCtHanTt.Rows) { DataRow drDt = DataTool.SQLGetDataRowByID("LIDOITUONG", "Ma_Dt", drhd["Ma_Dt"].ToString()); if (drDt != null) { string strQueryPh = string.Empty; string strQueryCthd = string.Empty; if ((bool)drhd["Thanh_Toan"]) { #region GetNew_SoCt DataRow drDmct = DataTool.SQLGetDataRowByID("SYSDMCT", "Ma_Ct", "PTT"); DataRow dr = SQLExec.ExecuteReturnDt("SELECT Ma_DvCs FROM SYSDMDVCS WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' ").Rows[0]; DateTime dteNgay_Ct_tt = Library.StrToDate(dteNgay_Ct_TT.Text); string strSQLExec = "SELECT So_Ct FROM GLVOUCHER (NOLOCK) WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Ct = 'PTT' AND MONTH(Ngay_Ct) =" + dteNgay_Ct_tt.Month.ToString() + " AND YEAR(Ngay_Ct) =" + dteNgay_Ct_tt.Year.ToString() + " AND So_Ct <> '' "; //+ " AND DAY(Ngay_Ct) =" + dteNgay_Ct1.Day.ToString() DataTable dt = SQLExec.ExecuteReturnDt(strSQLExec); if (dt.Rows.Count > 0) { string strSQL = "SELECT ISNULL(MAX(So_Ct),'') FROM GLVOUCHER (NOLOCK) WHERE Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Ct = 'PTT' AND MONTH(Ngay_Ct) =" + dteNgay_Ct_tt.Month.ToString() + " AND YEAR(Ngay_Ct) =" + dteNgay_Ct_tt.Year.ToString() + ""; strSo_Ct = SQLExec.ExecuteReturnValue(strSQL).ToString(); Hashtable htPara = new Hashtable(); htPara.Add("TABLENAME", "GLVOUCHER"); htPara.Add("COLUMNNAME", "So_Ct"); htPara.Add("CURRENTID", strSo_Ct); htPara.Add("KEY", "Ma_DvCs = '" + Element.sysMa_DvCs + "' AND Ma_Ct = 'PTT' AND MONTH(Ngay_Ct) = " + dteNgay_Ct_tt.Month + " AND YEAR(Ngay_Ct) = " + dteNgay_Ct_tt.Year + ""); htPara.Add("PREFIXLEN", Convert.ToInt32(drDmct["PrefixLen"])); htPara.Add("SUFFIXLEN", Convert.ToInt32(drDmct["SubfixLen"])); strSo_Ct_New = (string)SQLExec.ExecuteReturnValue("sp_GetNewID", htPara, CommandType.StoredProcedure); //strSo_Ct_New = drDmct["Prefix"].ToString() + dteNgay_Ct_tt.Month.ToString("00") + dteNgay_Ct_tt.Day.ToString("00") + strSo_Ct_New.Substring(strSo_Ct_New.Length - 4, 4); } else { strSo_Ct_New = drDmct["Prefix"].ToString() + dteNgay_Ct_tt.Month.ToString("00") + dteNgay_Ct_tt.Day.ToString("00") + "0001"; } #endregion strCreate_Log = Common.GetCurrent_Log(); bool bSttValid = false; while (!bSttValid) { iStt = Common.GetNewStt("01", true); string strPH = @"SELECT * FROM GLVOUCHER (NOLOCK) WHERE Stt= '" + iStt + "'"; DataTable dtCtph = SQLExec.ExecuteReturnDt(strPH); if (dtCtph.Rows.Count > 0) { bSttValid = false; } else { bSttValid = true; } } #region Tạo Phiếu thu double dbTien3 = 0; // Tạo header strQueryPh += @" INSERT INTO GLVOUCHER (Stt, Ma_Ct, Ngay_Ct, So_Ct, Ma_Dt, Dien_giai, TTien0, TTien_Nt0, TTien3, TTien_Nt3, Create_Log, Ct_Di_Kem,Is_ThanhToan, Ma_Dvcs) VALUES('" + iStt + "', 'PTT', '" + Library.DateToStr(dteNgay_Ct_tt) + "', '" + strSo_Ct_New + "', '" + drhd["Ma_Dt"] + "', N'" + txtDien_Giai.Text + " - Số Ct : " + drhd["So_Ct_Hd"] + "', " + drhd["Tien_Tt1"] + ", " + drhd["Tien_Tt1"] + ", " + dbTien3 + ", " + dbTien3 + ", '" + strCreate_Log + "', '" + drhd["So_Ct_Hd"] + "',1, '" + Element.sysMa_DvCs + "')"; // Tạo Chi tiết Stt0 += 1; strQueryCthd += @"INSERT INTO CATIEN (Stt, Stt0, Ma_Ct, Ngay_Ct, So_Ct, Dien_Giai, Ong_Ba, Ma_Dt,Dia_Chi,Ten_Dt, Tk_No, Tk_Co, Tien_Nt9, Tien, Tien_Nt, Ma_Thue, Thue_GtGt, Tien3, Tien_Nt3, Tk_No3, Tk_Co3, Ngay_Ct0, So_Ct0, So_Seri0, Ma_So_Thue, Ten_DtGtGt, Ma_Dvcs, Ma_Tte, Ty_Gia) VALUES('" + iStt + "', '" + Stt0 + "', 'PTT', '" + dteNgay_Ct_TT.Text + "','" + strSo_Ct_New + "', N'" + txtDien_Giai.Text + " - Số Ct : " + drhd["So_Ct_Hd"] + "', N'" + drDt["Ong_Ba"] + "', '" + drhd["Ma_Dt"] + "',N'" + drDt["Dia_Chi"] + "', N'" + drDt["Ten_Dt"] + "','" + txtTk_Tt.Text + "','" + drhd["Tk"] + "', " + drhd["Tien_Tt1"] + ", " + drhd["Tien_Tt1"] + ", " + drhd["Tien_Tt1"] + ", '', 0, 0, 0, '', '', '', '', '', '', N'', '" + Element.sysMa_DvCs + "','VND', 1)\n"; if (numTTien_Tt.Value > 0) { SQLExec.Execute(strQueryPh); SQLExec.Execute(strQueryCthd); //Common.MsgOk("Chứng từ đã tạo xong Số chứng từ : " + strSo_Ct_New); this.strStt_Pt = iStt; this.strSo_Ct_New = strSo_Ct_New; //return iStt; } #endregion //Tao thanh toán mới DataRow rowCtThanhtoan; DataRow row2 = drhd; DataTable dtTableSource = SQLExec.ExecuteReturnDt("SELECT *, CAST(0 AS BIT) AS Thanh_Toan FROM GLTHANHTOANCT WHERE 0 = 1"); rowCtThanhtoan = dtTableSource.NewRow(); Common.CopyDataRow(row2, rowCtThanhtoan); if ((rowCtThanhtoan["Ngay_Ct_TT"] == DBNull.Value) && (((DateTime)rowCtThanhtoan["Ngay_Ct_TT"]) == Element.sysNgay_Min)) { rowCtThanhtoan["Ngay_Ct_TT"] = Library.StrToDate(this.dteNgay_Ct_TT.Text); } rowCtThanhtoan["Stt_PT"] = iStt; rowCtThanhtoan["Tk"] = row2["Tk"]; rowCtThanhtoan["Ma_Dt"] = row2["Ma_Dt"]; rowCtThanhtoan["Stt_HD"] = row2["Stt_HD"]; rowCtThanhtoan["Tien_Tt"] = row2["Tien_Tt1"]; rowCtThanhtoan["Tien_Tt_Nt"] = row2["Tien_Tt_Nt1"]; rowCtThanhtoan["Tien_CLTG"] = row2["Tien_CLTG"]; rowCtThanhtoan["LastModify_Log"] = row2["LastModify_Log"]; dtTableSource.Rows.Add(rowCtThanhtoan); dtTableSource.AcceptChanges(); this.Save_HanTt0(iStt, dtTableSource); // tạo thanh toán cũ phục vụ cái chưa update. try { bool a = SQLExec.Execute(@"INSERT INTO GLTHANHTOAN( Stt, Ma_Ct, Ngay_Ct, So_Ct, Dien_Giai, Ma_Tte, Ty_Gia, Tk, Ma_Dt, Tien_Tt, Tien_Tt_Nt, Stt_Hd, Is_SoDuDau, Ma_DvCs, Tien_CLTG, Dau_ClTg, Tk_No_ClTg, Tk_Co_ClTg, Tk_No_ClTg2, Tk_Co_ClTg2, LastModify_Log, Is_CLTG, User_Crtd, User_Edit, Ngay_Crtd, Ngay_Edit) select Stt = Stt_PT, Ma_Ct = 'PTT', Ngay_Ct = Ngay_Ct_TT, So_Ct = So_Ct_TT, Dien_Giai = Dien_Giai_TT, Ma_Tte = 'VND', Ty_Gia = 1, Tk , Ma_Dt, Tien_Tt, Tien_Tt_Nt, Stt_Hd, Is_SoDuDau = 0, Ma_DvCs, Tien_CLTG, Dau_ClTg, Tk_No_ClTg, Tk_Co_ClTg, Tk_No_ClTg2, Tk_Co_ClTg2, LastModify_Log, Is_CLTG = Dau_ClTg, User_Crtd = '', User_Edit = '', Ngay_Crtd = GETDATE(), Ngay_Edit = GETDATE() from GLTHANHTOANCT WHERE Stt_Pt = '" + iStt + "'"); } catch (Exception e1) { EpointProcessBox.AddMessage(e1.ToString()); } EpointProcessBox.AddMessage("Thanh toán công nợ khách hàng " + drhd["Ma_Dt"].ToString() + " Số Ct : " + strSo_Ct_New); } } } return(string.Empty); } catch (Exception ex) { Common.MsgOk(ex.ToString()); return(string.Empty); // throw; } }
void sendmail() { try { string strMsgLog = string.Empty; string strMsg = string.Empty; string strMa_Cbnv, strTen_Cbnv, strEmail, strSubject; DataTable dtBirthDayEmployee; string strHost = EmailConfig.strHost; string strCredentials = EmailConfig.strCredentials; string strPassclient = EmailConfig.strPassclient; string strFrom = EmailConfig.strFrom; string strCC = EmailConfig.strCC; string strContentEmail = EmailConfig.strContentEmail; #region Format mail string strBodyMail = EmailConfig.strEmailBobyBirthDay; #endregion //Xem kết quả Hashtable ht = new Hashtable(); ht["LANGUAGE_TYPE"] = (char)Element.sysLanguage; ht["MA_DVCS"] = Element.sysMa_DvCs; ht["STT"] = 1; dtBirthDayEmployee = SQLExec.ExecuteReturnDt("sp_ViewReminder", ht, CommandType.StoredProcedure); foreach (DataRow drP in dtBirthDayEmployee.Rows) { if ((Boolean)drP["Sent_Mail"]) continue; strMa_Cbnv = drP["Ma_Cbnv"].ToString(); strTen_Cbnv = drP["Ten_Cbnv"].ToString(); strEmail = drP["Email"].ToString(); //if (strEmail == string.Empty) // continue; int Numrd = new Random().Next(0, 3); EmailConfig.EMAIL_CONTENT = "EMAIL_CONTENT" + Numrd.ToString(); EmailConfig.SendMailBirthday(strBodyMail, drP); System.Threading.Thread.Sleep(20000); strMsgLog += "\n" + strMa_Cbnv + "---" + strTen_Cbnv + "(" + drP["Ngay_Sinh_Text"].ToString() + ")" + "\n"; // Lưu lại thông tin gửi mail //EmailConfig.SaveInfoSendMail(strMa_Cbnv, (DateTime)drP["Ngay_Sinh"]); } WriteToFile(DateTime.Now.ToLongTimeString()); WriteToFile(strMsgLog); } catch (Exception ex) { WriteToFile(DateTime.Now.ToLongTimeString()); WriteToFile(ex.ToString()); } }
private void Save_HanTt0(string Stt_PT) { DataRow rowCtThanhtoan; //DataRow CurrRow = ((DataRowView)this.bdsThanhToan.Current).Row; //double dbTien_PT = Convert.ToDouble(CurrRow["Tien_PT"]); //double dbTien_Pt_Nt = Convert.ToDouble(CurrRow["Tien_PT_Nt"]); if (true) { DataTable dtTableSource = SQLExec.ExecuteReturnDt("SELECT *, CAST(0 AS BIT) AS Thanh_Toan FROM GLTHANHTOANCT WHERE 0 = 1"); foreach (DataRow row2 in this.dtCtHanTt.Select(this.bdsHanTt.Filter)) { if (!(bool)row2["Thanh_Toan"]) { continue; } rowCtThanhtoan = dtTableSource.NewRow(); Common.CopyDataRow(row2, rowCtThanhtoan); if ((rowCtThanhtoan["Ngay_Ct_TT"] == DBNull.Value) && (((DateTime)rowCtThanhtoan["Ngay_Ct_TT"]) == Element.sysNgay_Min)) { rowCtThanhtoan["Ngay_Ct_TT"] = Library.StrToDate(this.dteNgay_Ct_TT.Text); } rowCtThanhtoan["Stt_PT"] = Stt_PT; rowCtThanhtoan["Tk"] = row2["Tk"]; rowCtThanhtoan["Ma_Dt"] = row2["Ma_Dt"]; rowCtThanhtoan["Stt_HD"] = row2["Stt_HD"]; rowCtThanhtoan["Tien_Tt"] = row2["Tien_Tt1"]; rowCtThanhtoan["Tien_Tt_Nt"] = row2["Tien_Tt_Nt1"]; rowCtThanhtoan["Tien_CLTG"] = row2["Tien_CLTG"]; rowCtThanhtoan["LastModify_Log"] = row2["LastModify_Log"]; dtTableSource.Rows.Add(rowCtThanhtoan); } dtTableSource.AcceptChanges(); SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand(); command.CommandText = "Sp_Update_CtHanTt"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Stt", ""); command.Parameters.AddWithValue("@Ma_Ct", "PTT"); command.Parameters.AddWithValue("@Tk", "1311"); command.Parameters.AddWithValue("@Ma_Dt", ""); command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs); SqlParameter parameter = new SqlParameter { SqlDbType = SqlDbType.Structured, ParameterName = "@CtHanTt", TypeName = "TVP_CtHanTt", Value = Voucher.GetTVPValue("GLTHANHTOANCT", "TVP_CtHanTt", dtTableSource) }; command.Parameters.Add(parameter); try { command.ExecuteNonQuery(); } catch (Exception exception) { command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION"; command.CommandType = CommandType.Text; command.Parameters.Clear(); command.ExecuteNonQuery(); MessageBox.Show("Có lỗi xảy ra :" + exception.Message); } this.btSave.Enabled = false; } }
private void txtMa_Sp_Validating(object sender, CancelEventArgs e) { string strValue = txtMa_Sp.Text.Trim(); bool bRequire = enuLoai_Vt.Text == "1" ? true : false; if (bRequire && txtMa_Sp.Text != string.Empty) //enuNew_Edit == enuEdit.New && { if (enuNew_Edit == enuEdit.New) { if (!DataTool.SQLCheckExist("LISANPHAM", "Ma_Sp", txtMa_Sp.Text)) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Sản phẩm {" + txtMa_Sp.Text + "} chưa có, thêm sản phẩm này vào danh mục sản phẩm" : "Do you want to add this product in list of product"; if (Common.MsgYes_No(strMsg)) { DataTable dtDmSp = DataTool.SQLGetDataTable("LISANPHAM", "*", "0 = 1", ""); DataRow drEditSp = dtDmSp.NewRow(); drEditSp["Ma_Nh_Vt"] = txtMa_Nh_Vt.Text; drEditSp["Ma_Sp"] = txtMa_Sp.Text; drEditSp["Ten_Sp"] = txtTen_Vt.Text; drEditSp["Dvt"] = txtDvt.Text; DataTable dt = SQLExec.ExecuteReturnDt("SELECT * FROM LIVATTUNH WHERE Ma_Nh_Vt = '" + txtMa_Nh_Vt.Text + "' AND Loai_Nh IN ('2', '3')"); if (dt != null && dt.Rows.Count >= 1) { DataTool.SQLUpdate(enuEdit.New, "LISANPHAM", ref drEditSp); } else { //frmSanPham_Edit frmEdit = new frmSanPham_Edit(); //frmEdit.Load(enuEdit.New, drEditSp); } } } } else { string strMa_Sp_Old = (string)drEdit["Ma_Sp"]; if (txtMa_Sp.Text != strMa_Sp_Old && DataTool.SQLCheckExist("LISANPHAM", "Ma_Sp", strMa_Sp_Old)) //Đã tồn tại { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Có chắc chắn đổi mã {" + strMa_Sp_Old + "} sang mã mới {" + txtMa_Sp.Text + "}" : "Are you sure to change product code?"; if (Common.MsgYes_No(strMsg)) { DataRow drEditSp = DataTool.SQLGetDataRowByID("LISANPHAM", "Ma_Sp", strMa_Sp_Old); drEditSp["Ma_Nh_Vt"] = txtMa_Nh_Vt.Text; drEditSp["Ma_Sp"] = txtMa_Sp.Text; drEditSp["Ten_Sp"] = txtTen_Vt.Text; drEditSp["Dvt"] = txtDvt.Text; if (DataTool.SQLSave(enuEdit.Edit, "LISANPHAM", ref drEditSp)) { DataTool.SQLChangeID("MA_SP", drEditSp); drEdit["Ma_Sp"] = txtMa_Sp.Text; } } } } } //frmSanPham frmLookup = new frmSanPham(); DataRow drLookup = Lookup.ShowLookup("Ma_Sp", strValue, bRequire, null); if (bRequire && drLookup == null) { e.Cancel = true; } if (drLookup == null) { txtMa_Sp.Text = string.Empty; lbtTen_Sp.Text = string.Empty; } else { txtMa_Sp.Text = ((string)drLookup["Ma_Sp"]).Trim(); lbtTen_Sp.Text = ((string)drLookup["Ten_Sp"]).Trim(); } dicName.SetValue(lbtTen_Sp.Name, lbtTen_Sp.Text); }
private void LoadDataCombobox() { cboTrang_Thai.DataSource = SQLExec.ExecuteReturnDt(@"SP_HRM_GetDataCombobox 'TRANG_THAI' "); cboTrang_Thai.ValueMember = "Code"; cboTrang_Thai.DisplayMember = "Description"; }
private bool Save() { if (!Common.CheckDataLocked(Library.StrToDate(dteNgay_Ps.Text))) { Common.MsgCancel("Dữ liệu đã khóa, liên hệ với nhà quản trị!"); return(false); } //Kiem tra Valid tren Form if (!FormCheckValid()) { return(false); } //Luu vao CSDL if (rdbIs_TaiSan.Checked) { Hashtable ht = new Hashtable(); ht.Add("STT", strStt); ht.Add("STT0", iStt0); ht.Add("MA_TS", txtMa_Ts.Text); ht.Add("TEN_TS", txtTen_Ts.Text); ht.Add("MA_NH_TS", txtMa_Nh_Ts.Text); ht.Add("TK_TS", txtTk_Ts.Text); ht.Add("DVT", txtDvt.Text); ht.Add("NGAY_CT", Library.StrToDate(dteNgay_Ps.Text)); ht.Add("SO_CT", txtSo_Ct.Text); ht.Add("MA_TTE", txtMa_Tte.Text); ht.Add("TY_GIA", 1); ht.Add("DIEN_GIAI", txtDien_Giai.Text); ht.Add("MA_BP", txtMa_Bp.Text); ht.Add("MA_KM", txtMa_Km.Text); ht.Add("MA_SP", txtMa_Sp.Text); ht.Add("SO_LUONG", numSo_Luong.Value); ht.Add("TIEN_NG", numTien_NG.Value); ht.Add("TK_NO", txtTk_No.Text); ht.Add("TK_CO", txtTk_Co.Text); ht.Add("TINH_KH", chkTinh_Kh.Checked); ht.Add("NGAY_BD_KH", Library.StrToDate(txtNgay_Bd_Kh.Text)); ht.Add("SO_THANG_KH", numSo_Thang_Kh.Value); ht.Add("MA_DVCS", Element.sysMa_DvCs.ToString()); //Check Ma_Ts exist string strMa_Ts = (string)SQLExec.ExecuteReturnValue("SELECT Ma_Ts FROM ASTS WHERE Ma_Ts ='" + txtMa_Ts.Text.Trim() + "'", CommandType.Text); if (strMa_Ts != null) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Mã này đã tồn tại trong danh mục tài sản." : "The code already exists in the asset list."; Common.MsgCancel(strMsg); return(false); } else { SQLExec.Execute("sp_Create_TSCD", ht, CommandType.StoredProcedure); } } if (rdbIs_CCDC.Checked) { Hashtable ht = new Hashtable(); ht.Add("STT", strStt); ht.Add("STT0", iStt0); ht.Add("MA_CCDC", txtMa_Ts.Text); ht.Add("TEN_CCDC", txtTen_Ts.Text); ht.Add("MA_NH_TS", txtMa_Nh_Ts.Text); ht.Add("TK_CCDC", txtTk_Ts.Text); ht.Add("DVT", txtDvt.Text); ht.Add("NGAY_CT", Library.StrToDate(dteNgay_Ps.Text)); ht.Add("SO_CT", txtSo_Ct.Text); ht.Add("MA_TTE", txtMa_Tte.Text); ht.Add("TY_GIA", 1); ht.Add("DIEN_GIAI", txtDien_Giai.Text); ht.Add("MA_BP", txtMa_Bp.Text); ht.Add("MA_KM", txtMa_Km.Text); ht.Add("MA_SP", txtMa_Sp.Text); ht.Add("SO_LUONG", numSo_Luong.Value); ht.Add("TIEN_NG", numTien_NG.Value); ht.Add("TK_NO", txtTk_No.Text); ht.Add("TK_CO", txtTk_Co.Text); ht.Add("TINH_KH", chkTinh_Kh.Checked); ht.Add("NGAY_BD_KH", Library.StrToDate(txtNgay_Bd_Kh.Text)); ht.Add("SO_THANG_KH", numSo_Thang_Kh.Value); ht.Add("MA_DVCS", Element.sysMa_DvCs.ToString()); //Check Ma_CCDC exist string strMa_CCDC = (string)SQLExec.ExecuteReturnValue("SELECT Ma_CCDC FROM ASCCDC WHERE Ma_CCDC ='" + txtMa_Ts.Text.Trim() + "'", CommandType.Text); if (strMa_CCDC != null) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Mã này đã tồn tại trong danh mục CCDC." : "The code already exists in the tool list."; Common.MsgCancel(strMsg); return(false); } else { SQLExec.Execute("sp_Create_CCDC", ht, CommandType.StoredProcedure); } } /////////// ////Xac dinh Stt //if (this.enuNew_Edit == enuEdit.New) // drEdit["Stt"] = Common.GetNewStt("TS", true); //Kiem tra Valid CSDL //if (!DataTool.SQLUpdate(enuNew_Edit, "ASTSNG", ref drEdit)) // return false; return(true); }
public static void SendMessageToZalo(ZaloClient client, string FilePathZalo, string Is_SendZalo) { string strMsgLog = string.Empty; try { object objImage; string strMsg = string.Empty; string AttachmentId = string.Empty; string ZaloLink, FileName; string FileImg; //string strMa_Cbnv, strTen_Cbnv, strEmail, strMa_Kv, strMa_Loai2, strSubject; DataTable dtMsg = SQLExec.ExecuteReturnDt("Z_GetMessage_ToZalo"); if (dtMsg == null || dtMsg.Rows.Count == 0) { return; } foreach (DataRow drmsg in dtMsg.Rows) { int MsgID = Convert.ToInt32(drmsg["Ident00"]); ZaloLink = drmsg["ZaloLink"].ToString(); objImage = drmsg["File_Content"]; FileImg = FilePathZalo + @"\" + (drmsg["File_Tag"].ToString() == string.Empty ? String.Empty : drmsg["File_ID"].ToString() + "." + drmsg["File_Tag"].ToString()); //Common.WriteToFileZaloLog("Start Send Message ToZalo : " + FileImg); if (SaveZaloResource.LoadResourceImage(FileImg, objImage)) { ZaloFile Zfile = new ZaloFile(FileImg); Zfile.setMediaTypeHeader("Image/PNG"); JObject updatefile = client.uploadImageForOfficialAccountAPI(Zfile); dynamic dynObjFile = JsonConvert.DeserializeObject(updatefile.ToString()); AttachmentId = dynObjFile.data.attachment_id; } //Get list employee in branch //string strSQLEm = "Z_GetEmployee_ByTag " + drmsg["Ident00"] + ""; if (Is_SendZalo == "Y") { DataTable dtEmployee_Br = SQLExec.ExecuteReturnDt("Z_GetEmployee_ByTag " + MsgID.ToString()); if (dtEmployee_Br == null || dtEmployee_Br.Rows.Count == 0) { continue; } foreach (DataRow drR in dtEmployee_Br.Rows) { JObject jSendbr = client.sendImageMessageToUserIdByAttachmentId(drR["Zalo_ID"].ToString(), ZaloLink, AttachmentId); } } else { JObject jSend_hungnv = client.sendImageMessageToUserIdByAttachmentId("5643947530772678208", ZaloLink, AttachmentId); } SQLExec.Execute("Z_UpdateMessageZaloAfterSend " + MsgID.ToString()); } } catch (Exception ex) { //Common.WriteToFileZaloLog("Send Message to Zalo : " + strMsgLog + "-------------\n" + ex.ToString()); } }
public void BuildGridViewReport() { if (strZone == string.Empty) { return; } string strColumnVndList = string.Empty; string strColumnNtList = string.Empty; string strColumnAllList = string.Empty; string strReport_ID = strZone; string strReport_ID_Info = (string)SQLExec.ExecuteReturnValue("SELECT Report_ID_Info FROM SYSReport WHERE Report_ID = '" + strReport_ID + "'"); System.Collections.Hashtable htParameter = new System.Collections.Hashtable(); htParameter.Add("REPORT_ID", strReport_ID); htParameter.Add("REPORT_ID_INFO", strReport_ID_Info); DataTable dtReportInfo = SQLExec.ExecuteReturnDt("sp_GetReportInfo", htParameter, CommandType.StoredProcedure); //DataTable dtReportInfo = DataTool.SQLGetDataTable("SYSREPORTINFO", "*", "(Report_ID = '" + strZone + "') AND (Visible = 1)", "Stt"); foreach (DataRow dr in dtReportInfo.Rows) { string strColumn_ID = (string)dr["Column_ID"]; if (strColumn_ID == string.Empty) { continue; } switch ((string)dr["Vnd_Nt"]) { case "1": //Hien Vnd strColumnVndList += strColumnVndList != string.Empty ? ", " : ""; strColumnVndList += strColumn_ID; break; case "2": //Hien Nt strColumnNtList += strColumnNtList != string.Empty ? ", " : ""; strColumnNtList += strColumn_ID; break; default: //Hien tat ca strColumnVndList += strColumnVndList != string.Empty ? ", " : ""; strColumnNtList += strColumnNtList != string.Empty ? ", " : ""; strColumnVndList += strColumn_ID; strColumnNtList += strColumn_ID; break; } strColumnAllList += strColumnAllList != string.Empty ? ", " : ""; strColumnAllList += strColumn_ID; } if (strVnd_Nt == string.Empty) { if (bVnd_Nt) { base.BuildGridView(strColumnVndList); } else { base.BuildGridView(strColumnNtList); } } else { if (strVnd_Nt == "0") { base.BuildGridView(strColumnVndList); } else if (strVnd_Nt == "1") { base.BuildGridView(strColumnNtList); } else { base.BuildGridView(strColumnAllList); } } //this.dgvGridView.ColumnPanelRowHeight = 40; //this.dgvGridView.Columnp //this.AllowUserToOrderColumns = true; }
//Load Menu cho Main chính public void Load() { DataTable dtModule = DataTool.SQLGetDataTable("SYSMODULE", "*", "", "Module_Parent, Module_Id"); //string strQuery = "SELECT * FROM vw_Module_Menu "; DataTable dtGroupItemMain = SQLExec.ExecuteReturnDt(@"select r2.Module_Id, Menu_Id = CAST( CAST(r2.Module_Id AS VARCHAR(5)) + CAST(r1.Menu_Id AS VARCHAR(5)) AS INT), Menu_Parent, Menu_Name, Menu_NameE, r1.Stt, r1.Picture, Menu_Method, Menu_Para, r1.Show_On_Main, r1.Is_Customize, r1.Object_ID, Menu_NameO from SYSmenu r1 inner join SYSMODULEME r2 ON r1.Menu_Id = r2.Menu_Id INNER JOIN SYSMODULE r3 ON r3.Module_Id = r2.Module_Id"); //DataTable dtModule = SQLExec.ExecuteReturnDt(strQuery); DataRow[] drArrParent = dtModule.Select("Module_Parent = 100"); string[] strArrNumber = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f", "g", "h", "i", "k", "l", "m", "n", "p", "q", "r", "s", "t" }; foreach (DataRow drParent in drArrParent) { //Menu cha int iModule_Parent_Id = (int)drParent["Module_Id"]; if (iModule_Parent_Id == 9000) //Điều khiển { if (!Element.sysIs_Admin) { continue; } } //Kiểm tra phân hệ có hợp lệ hay không if ((bool)drParent["Is_Module"]) { if (!Core.Is_Module_Valid(iModule_Parent_Id)) { continue; } } tsmiControl tsmiParent = new tsmiControl(); tsmiParent.Text = (string)drParent["Module_Name"]; tsmiParent.Vietnamese = (string)drParent["Module_Name"]; tsmiParent.English = (string)drParent["Module_NameE"]; if (drParent.Table.Columns.Contains("Module_NameO")) { tsmiParent.Other = (string)drParent["Module_NameO"]; } else { tsmiParent.Other = tsmiParent.English; } //string strPicture = (string)drParent["Picture"]; //if (strPicture != string.Empty) //{ // string strFileName = Application.StartupPath + @"\Images\" + strPicture; // if (System.IO.File.Exists(strFileName)) // { // Image img = Image.FromFile(strFileName); // tsmiParent.Image = img; // } //} DataRow[] drArrChild = dtGroupItemMain.Select("Module_ID = " + iModule_Parent_Id.ToString()); int iNumber = 0; foreach (DataRow drChild in drArrChild) { //Menu con int iModule_Child_Id = (int)drChild["Menu_Id"]; //Kiểm tra phân hệ có hợp lệ hay không //if ((bool)drChild["Is_Module"]) //{ // if (!Core.Is_Module_Valid(iModule_Child_Id)) // continue; //} tsmiControl tsmiChild = new tsmiControl(); iNumber++; iNumber++; string strPrefix = string.Empty; if (iNumber <= strArrNumber.Length) { strPrefix = "&" + strArrNumber[iNumber - 1] + ". "; } tsmiChild.Text = strPrefix + (string)drChild["Menu_Name"]; tsmiChild.Vietnamese = strPrefix + (string)drChild["Menu_Name"]; tsmiChild.English = strPrefix + (string)drChild["Menu_NameE"]; if (drChild.Table.Columns.Contains("Menu_NameO")) { tsmiChild.Other = ((string)drChild["Menu_NameO"]).Trim(); } else { tsmiChild.Other = tsmiChild.English; } //strPicture = (string)drChild["Picture"]; //if (strPicture != string.Empty) //{ // string strFileName = Application.StartupPath + @"\Images\" + strPicture; // if (System.IO.File.Exists(strFileName)) // tsmiChild.Image = Image.FromFile(strFileName); //} tsmiChild.MethodName = ((string)drChild["Menu_Method"]).Trim(); tsmiChild.ParaName = ((string)drChild["Menu_Para"]).Trim(); tsmiChild.ID = (int)drChild["Menu_Id"]; tsmiChild.Parent_ID = (int)drChild["Menu_Parent"]; tsmiChild.Object_Id = ((string)drChild["Object_Id"]).Trim(); tsmiChild.bIs_Module = false; tsmiChild.Click += new EventHandler(tsmiRunMethod); //Kiem tra Permission if (Common.CheckPermission((string)drChild["Object_ID"], enuPermission_Type.Allow_Access)) { tsmiParent.DropDownItems.Add(tsmiChild); } } this.Items.Add(tsmiParent); } }
private void DanhSoCt() { if (bdsViewPh.Count <= 0) { return; } drCurrent = ((DataRowView)bdsViewPh.Current).Row; string strMa_Ct = (string)drCurrent["Ma_Ct"]; int iThang = ((DateTime)drCurrent["Ngay_Ct"]).Month; string strFormat_Text = string.Empty; string strFix_Text = string.Empty; string strStt = string.Empty; string strSo_Ct = string.Empty; DataTable dtDmSoCt = DataTool.SQLGetDataTable("SYSDMSOCT", "", "Ma_Ct = '" + strMa_Ct + "' AND Loai_Ma_Ct = " + iThang.ToString().Trim(), ""); if (dtDmSoCt != null && dtDmSoCt.Rows.Count > 0) { strFormat_Text = (string)dtDmSoCt.Rows[0]["Format_Text"]; strFix_Text = (string)dtDmSoCt.Rows[0]["Fix_Text"]; } frmDanhSo_Ct frm = new frmDanhSo_Ct(); frm.txtFormat_Text.Text = strFormat_Text; frm.txtFix_Text.Text = strFix_Text; frm.Load(); if (frm.isAccept) { int iSo_Ct = Convert.ToInt32(frm.numSo_Ct.Value); strFormat_Text = frm.txtFormat_Text.Text; strFix_Text = frm.txtFix_Text.Text; for (int i = 0; i < bdsViewPh.Count; i++) { bdsViewPh.Position = i; string strSo_Ct_New = iSo_Ct.ToString().PadLeft(strFormat_Text.Length, '0'); if (strFix_Text.Contains(",")) { strSo_Ct_New = strFix_Text.Replace(",", strSo_Ct_New); } else { strSo_Ct_New = strFix_Text + strSo_Ct_New; } drCurrent = ((DataRowView)bdsViewPh.Current).Row; strStt = (string)drCurrent["Stt"]; strSo_Ct = (string)drCurrent["So_Ct"]; string strSQLExec = "UPDATE GLCVOUCHER SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE CATIEN SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE APMUA SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE ARBAN SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE INNHAPXUAT SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE GLKETOAN SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_ThuChi SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_DoanhThu SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_ChiPhi SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_CongNo SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_TheKho SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_SoCai SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_ThueVAT SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "'" + "UPDATE vw_HanTt SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "' AND So_Ct = '" + strSo_Ct + "'" + "UPDATE GLTHANHTOAN SET So_Ct = '" + strSo_Ct_New + "' WHERE Stt = '" + strStt + "' AND So_Ct = '" + strSo_Ct + "'"; if (SQLExec.Execute(strSQLExec)) { drCurrent["So_Ct"] = strSo_Ct_New; } iSo_Ct++; } } }
public override void Edit(enuEdit enuNew_Edit) { if (bdsDuDauINCt.Position < 0 && enuNew_Edit == enuEdit.Edit) { return; } if (dtDuDauINCt == null) { return; } //Copy hang hien tai if (bdsDuDauINCt.Position >= 0) { Common.CopyDataRow(((DataRowView)bdsDuDauINCt.Current).Row, ref drCurrent); } else { drCurrent = dtDuDauINCt.NewRow(); } //Kiểm tra khóa số dư if (enuNew_Edit == enuEdit.New) { string strSQLExec = "SELECT TOP 1 Locked_Sdv FROM SYSNAM " + " WHERE Nam = " + Element.sysWorkingYear + " AND Ma_DvCs = '" + Element.sysMa_DvCs + "'"; if ((bool)SQLExec.ExecuteReturnValue(strSQLExec)) { Common.MsgCancel("Số dư đầu đã khóa!"); return; } drCurrent["Ma_Kho"] = ((DataRowView)bdsDuDauIN.Current)["Ma_Kho"]; } frmDuDauIN_Edit frmEdit = new frmDuDauIN_Edit(); frmEdit.Load(enuNew_Edit, drCurrent); //Accept if (frmEdit.isAccept) { if (enuNew_Edit == enuEdit.New) { if (bdsDuDauINCt.Position >= 0) { dtDuDauINCt.ImportRow(drCurrent); } else { dtDuDauINCt.Rows.Add(drCurrent); } bdsDuDauINCt.Position = bdsDuDauINCt.Find("Ident00", drCurrent["Ident00"]); } else { Common.CopyDataRow(drCurrent, ((DataRowView)bdsDuDauINCt.Current).Row); } //this.UpdateTotal(drCurrent); dtDuDauINCt.AcceptChanges(); } //else // dtDuDauINCt.RejectChanges(); }
void btViewContract_Click(object sender, EventArgs e) { try { string HDLD = Parameters.GetParaValue("HDLD").ToString(); // "HDLD20180824"; string HDLD2 = Parameters.GetParaValue("HDLD2").ToString(); // "HDLD20180824";-- Hợp đồng không thời hạn string HDLD_PL = Parameters.GetParaValue("HDLDPL").ToString(); //"HDLD20180824_PL"; string HDLD_HL = Parameters.GetParaValue("HDLDHL").ToString(); //"HDLD20180824_PL";-- -- Hợp đồng huấn luyện if (tabDetail.SelectedTab == pageHopDong || dgvHopDong.Focused) // View hop dong { if (bdsHopDong.Position < 0) { return; } DataRow drCurrentHD = ((DataRowView)bdsHopDong.Current).Row; string strSQLProc = "sp_GetHDLDInfo"; Hashtable htParameter = new Hashtable(); htParameter.Add("MA_CBNV", drCurrentHD["Ma_Cbnv"].ToString()); htParameter.Add("SO_HD", drCurrentHD["So_Hd"].ToString()); htParameter.Add("SO_PL", string.Empty); DataTable dtResult = SQLExec.ExecuteReturnDt(strSQLProc, htParameter, CommandType.StoredProcedure); string fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD); object objFileContent = Resource.LoadResource(HDLD); if (drCurrentHD["Loai_Hd"].ToString() == "5") { fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD_HL); objFileContent = Resource.LoadResource(HDLD_HL); } if (drCurrentHD["Loai_Hd"].ToString() == "2") { fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD2); objFileContent = Resource.LoadResource(HDLD2); } string strFileTemplate = Application.StartupPath + @"\Template\" + fileName; if (objFileContent != null) { FileStream stream = new FileStream(strFileTemplate, FileMode.Create, FileAccess.ReadWrite); stream.Write((byte[])objFileContent, 0, ((byte[])objFileContent).Length); stream.Close(); } else { EpointMessage.MsgOk("Tập tin rỗng"); } HRMCommon.WriteToWordQTTC04(dtResult, strFileTemplate, fileName); } else if (tabDetail.SelectedTab == pageHopDongPL || dgvHopDongPL.Focused)//View phụ lục hợp đồng { if (bdsHopDongPL.Position < 0) { return; } DataRow drCurrentPL = ((DataRowView)bdsHopDongPL.Current).Row; if (drCurrentPL["File_Id"].ToString() != string.Empty) { HDLD_PL = drCurrentPL["File_Id"].ToString(); } string fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD_PL); string strFileTemplate = Application.StartupPath + @"\Template\" + fileName; object objFileContent = Resource.LoadResource(HDLD_PL); if (objFileContent != null) { FileStream stream = new FileStream(strFileTemplate, FileMode.Create, FileAccess.ReadWrite); stream.Write((byte[])objFileContent, 0, ((byte[])objFileContent).Length); stream.Close(); } else { EpointMessage.MsgOk("Tập tin rỗng"); } string strSQLProc = "sp_GetHDLDInfo"; Hashtable htParameter = new Hashtable(); htParameter.Add("MA_CBNV", drCurrentPL["Ma_Cbnv"].ToString()); htParameter.Add("SO_HD", string.Empty); htParameter.Add("SO_PL", drCurrentPL["So_Pl"].ToString()); DataTable dtResult = SQLExec.ExecuteReturnDt(strSQLProc, htParameter, CommandType.StoredProcedure); if (dtResult != null && dtResult.Rows.Count > 0) { HRMCommon.WriteToWordQTTC04(dtResult, strFileTemplate, fileName); } else { EpointMessage.MsgOk("Không xuất được báo cáo!"); } } } catch (Exception ex) { EpointMessage.MsgOk(ex.Message); } }
public bool UpdateCt(DataTable dtEditCt) { #region UpdateCt: Cap nhat tung dong trong dtEditCt SqlConnection sqlCon = SQLExec.GetNewSQLConnection(); SqlCommand sqlCom = sqlCon.CreateCommand(); SqlTransaction sqlTran = sqlCom.Connection.BeginTransaction("Update_Voucher_Tran"); sqlCom.Transaction = sqlTran; int iSave_Ct_Success = 0; sqlCom.Parameters.Clear(); //Xoa du lieu cu trong Chung tu //if (this.enuNew_Edit == enuEdit.Edit) //{ // sqlCom.CommandType = CommandType.Text; // sqlCom.CommandText = "DELETE FROM OM_PXKDetail WHERE MA_PX = @MA_PX"; // sqlCom.Parameters.AddWithValue("@MA_PX", (string)drEdit["MA_PX"]); // try // { // sqlCom.ExecuteNonQuery(); // } // catch (Exception ex) // { // MessageBox.Show("Có lỗi xảy ra :" + ex.Message); // sqlCom.Transaction.Rollback(); // return false; // } //} //Luu du lieu vao Ct sqlCom.CommandText = "sp_UpdatePXK"; sqlCom.CommandType = CommandType.StoredProcedure; string strKey = "Object_id = Object_id('sp_UpdatePXK')"; DataTable dtUpdateCt_Para = DataTool.SQLGetDataTable("Sys.Parameters", "Name", strKey, null); DataRow[] drArrPrint = dtEditCt.Select("CHON = true"); foreach (DataRow dr in drArrPrint) { //Khong luu nhung dong danh dau xoa if (dr.Table.Columns.Contains("Deleted") && (bool)dr["Deleted"]) { continue; } sqlCom.Parameters.Clear(); DataRow drEditCt = dr; Common.SetDefaultDataRow(ref drEditCt); foreach (DataRow drPara in dtUpdateCt_Para.Rows) { string strColumnName = ((string)drPara["Name"]).Replace("@", ""); if (!drEditCt.Table.Columns.Contains(strColumnName)) { continue; } sqlCom.Parameters.AddWithValue("@" + strColumnName, drEditCt[strColumnName]); } try { int iSuc = sqlCom.ExecuteNonQuery(); if (iSuc > 0) { SQLExec.Execute("Update GLVoucher SET So_Ct_Lap = '" + strMa_Px + "'" + "WHERE Stt = '" + dr["Stt"].ToString() + "'"); //SQLExec.Execute("Update ARBan SET Ma_CBNV_GH = '" + txtMa_CBNV_GH.Text + "' " + // "WHERE Stt = '" + dr["Stt"].ToString() + "'"); iSave_Ct_Success += 1; } } catch (Exception ex) { MessageBox.Show("Có lỗi xảy ra :" + ex.Message); sqlCom.Transaction.Rollback(); return(false); } } #endregion sqlTran.Commit(); return(true); }
private void FillHanTtFromEditCt() { Voucher.Update_Detail(frmEditCt); string strSQLExec = "SELECT TOP 0 Stt, Ma_Ct, Ngay_Ct, So_Ct, Dien_Giai, Tk, Ma_Dt, Ma_Tte, Ty_Gia, Tien_Tt AS Tien, Tien_Tt_Nt AS Tien_Nt, CAST(0 AS BIT) AS Is_UngTruoc " + " FROM vw_HanTt WHERE 0 = 1"; dtHanTt = SQLExec.ExecuteReturnDt(strSQLExec); //Điền dữ liệu từ frmEditCt vào HanTt0 string strArrTk_CongNo_List = "," + (string)Parameters.GetParaValue("TK_CONGNO_LIST"); DataRow[] drArr = frmEditCt.dtEditCt.Select("Deleted = false"); string strTk_No, strTk_Co, strMa_Dt, strMa_Dt_Co, strMa_Ct; double dbTien, dbTien_Nt; bool bIs_UngTruoc = false; //Lấy dữ liệu từ hạch toán gốc foreach (DataRow dr in drArr) { if (dr.Table.Columns.Contains("TIEN")) { strTk_No = ((string)dr["Tk_No"]).Trim(); strTk_Co = ((string)dr["Tk_Co"]).Trim(); strMa_Dt = ((string)dr["Ma_Dt"]).Trim(); strMa_Ct = ((string)dr["Ma_Ct"]).Trim(); dbTien = Convert.ToDouble(dr["Tien"]); dbTien_Nt = Convert.ToDouble(dr["Tien_Nt"]); if (dr.Table.Columns.Contains("Is_UngTruoc")) { bIs_UngTruoc = (bool)dr["Is_UngTruoc"]; } if (dr.Table.Columns.Contains("Ma_Dt_Co") && (string)dr["Ma_Dt_Co"] != string.Empty) { strMa_Dt_Co = (string)dr["Ma_Dt_Co"]; } else { strMa_Dt_Co = strMa_Dt; } if (strTk_No != string.Empty && strTk_Co != string.Empty) { //Kiểm tra Tk_No if (strArrTk_CongNo_List.Contains("," + strTk_No.Substring(0, 3))) { if (frmEditCt.dtEditCt.Select("Tk_No LIKE '" + strTk_No + "%' AND Han_Tt = 0").Length > 0) { this.SaveToHanTt(strTk_No, strMa_Dt, dbTien, dbTien_Nt, "N", bIs_UngTruoc); } } //Kiểm tra Tk_Co if (strArrTk_CongNo_List.Contains("," + strTk_Co.Substring(0, 3))) { if (strMa_Ct == "BT" && frmEditCt.dtEditCt.Columns.Contains("Han_Tt_Co")) { if (frmEditCt.dtEditCt.Select("Tk_Co LIKE '" + strTk_Co + "%' AND Han_Tt_Co = 0").Length > 0) { this.SaveToHanTt(strTk_Co, strMa_Dt_Co, dbTien, dbTien_Nt, "C", bIs_UngTruoc); } } else { if (frmEditCt.dtEditCt.Select("Tk_Co LIKE '" + strTk_Co + "%' AND Han_Tt = 0").Length > 0) { this.SaveToHanTt(strTk_Co, strMa_Dt_Co, dbTien, dbTien_Nt, "C", bIs_UngTruoc); } } } } } if (dr.Table.Columns.Contains("TIEN3")) { strTk_No = ((string)dr["Tk_No3"]).Trim(); strTk_Co = ((string)dr["Tk_Co3"]).Trim(); strMa_Dt = ((string)dr["Ma_Dt"]).Trim(); dbTien = Convert.ToDouble(dr["Tien3"]); dbTien_Nt = Convert.ToDouble(dr["Tien_Nt3"]); if (dr.Table.Columns.Contains("Ma_Dt_Co") && (string)dr["Ma_Dt_Co"] != string.Empty) { strMa_Dt_Co = (string)dr["Ma_Dt_Co"]; } else { strMa_Dt_Co = strMa_Dt; } if (strTk_No != string.Empty && strTk_Co != string.Empty) { //Kiểm tra Tk_No if (strArrTk_CongNo_List.Contains("," + strTk_No.Substring(0, 3))) { if (frmEditCt.dtEditCt.Select("Tk_No LIKE '" + strTk_No + "%' AND Han_Tt = 0").Length > 0) { this.SaveToHanTt(strTk_No, strMa_Dt, dbTien, dbTien_Nt, "N", bIs_UngTruoc); } } //Kiểm tra Tk_Co if (strArrTk_CongNo_List.Contains("," + strTk_Co.Substring(0, 3))) { if (frmEditCt.dtEditCt.Select("Tk_Co LIKE '" + strTk_Co + "%' AND Han_Tt = 0").Length > 0) { this.SaveToHanTt(strTk_Co, strMa_Dt_Co, dbTien, dbTien_Nt, "C", bIs_UngTruoc); } } } } } //Cập nhật lại Tỷ giá foreach (DataRow dr in dtHanTt.Rows) { dbTien = Convert.ToDouble(dr["Tien"]); dbTien_Nt = Convert.ToDouble(dr["Tien_Nt"]); if (dbTien != dbTien_Nt && dbTien_Nt != 0) { dr["Ty_Gia"] = Math.Round(dbTien / dbTien_Nt, 0, MidpointRounding.AwayFromZero); } } dgvHanTt.DataSource = bdsHanTt; bdsHanTt.DataSource = dtHanTt; }
private void Init_Ct() { if (dtEditPh.Rows.Count == 0) { dtEditPh.Rows.Add(dtEditPh.NewRow()); } if (dtEditCt.Rows.Count == 0) { dtEditCt.Rows.Add(dtEditCt.NewRow()); } drEditPh = dtEditPh.Rows[0]; drCurrent = dtEditCt.Rows[0]; if (this.enuNew_Edit == enuEdit.New) { //Clear Content in drCurrent foreach (DataColumn dcEditCt in dtEditCt.Columns) { drCurrent[dcEditCt] = DBNull.Value; } Common.SetDefaultDataRow(ref drEditPh); Common.SetDefaultDataRow(ref drCurrent); drCurrent["Ma_DvCs"] = Element.sysMa_DvCs; drCurrent["Stt"] = strStt; drCurrent["Ma_Ct"] = strMa_Ct; drCurrent["Ngay_Ct"] = ((string)Epoint.Systems.Librarys.Parameters.GetParaValue("NGAY_CT") == "0" && drEdit["Ngay_Ct"] != DBNull.Value) ? drEdit["Ngay_Ct"] : DateTime.Now; drCurrent["Ma_Tte"] = Element.sysMa_Tte; drCurrent["Ty_Gia"] = 1; drCurrent["Stt0"] = 1; drCurrent["Deleted"] = false; if (drEditPh.Table.Columns.Contains("Duyet")) { drEditPh["Duyet"] = (bool)drDmCt["Default_Duyet"]; } if (drEditPh.Table.Columns.Contains("Is_Thue_Vat")) { drEditPh["Is_Thue_Vat"] = (bool)drDmCt["Default_VAT"]; } //Tinh so chung tu if ((bool)SQLExec.ExecuteReturnValue("SELECT Is_So_Ct FROM SYSDMCT WHERE Ma_Ct = '" + strMa_Ct + "'") == true)//1: Tính tự động, 0-Tính theo thủ công từng tháng { Cong_So_Ct_Auto(); } else { string strLoai_Ma_Ct = ((DateTime)drCurrent["Ngay_Ct"]).Month.ToString().Trim(); string strSQLExec = "EXEC Sp_Cong_So_Ct '" + strMa_Ct + "', '" + strLoai_Ma_Ct + "'"; DataTable dtSo_Ct = SQLExec.ExecuteReturnDt(strSQLExec); if (dtSo_Ct.Rows.Count > 0) { drEditPh["So_Ct"] = drCurrent["So_Ct"] = (string)dtSo_Ct.Rows[0][0]; } } drEditPh["Ma_DvCs"] = drCurrent["Ma_DvCs"]; drEditPh["Stt"] = drCurrent["Stt"]; drEditPh["Ma_Ct"] = drCurrent["Ma_Ct"]; drEditPh["Ngay_Ct"] = drCurrent["Ngay_Ct"]; //drEditPh["So_Ct"] = drCurrent["So_Ct"]; } Voucher.Update_Header(this); Voucher.Update_Stt(this, strModule); dgvEditCt1.Columns["Dvt"].ReadOnly = true; //BindingTTien numTTien0.DataBindings.Add("Value", dtEditPh, "TTien0"); numTTien_Nt0.DataBindings.Add("Value", dtEditPh, "TTien_Nt0"); numTTien_Nt3.DataBindings.Add("Value", dtEditPh, "TTien_Nt3"); numTTien3.DataBindings.Add("Value", dtEditPh, "TTien3"); numTTien.DataBindings.Add("Value", dtEditPh, "TTien"); numTTien_Nt.DataBindings.Add("Value", dtEditPh, "TTien_Nt"); numTSo_Luong.DataBindings.Add("Value", dtEditPh, "TSo_Luong"); }
private void Save_HanTt0() { if (this.frmEditCt != null) //Lưu xuống DataTable { if (frmEditCt.dtHanTt0 == null) { frmEditCt.dtHanTt0 = dtHanTt0.Clone(); } DataRow drHanTt = ((DataRowView)bdsHanTt.Current).Row; bool bReFillHanTt0 = true; if (!(frmEditCt.dtHanTt0.Select("Tk = '" + (string)drHanTt["Tk"] + "' AND Ma_Dt = '" + (string)drHanTt["Ma_Dt"] + "'").Length > 0)) { for (int i = 0; i <= dtHanTt0.Rows.Count - 1; i++) { if ((bool)dtHanTt0.Rows[i]["Modify"]) { frmEditCt.dtHanTt0.ImportRow(dtHanTt0.Rows[i]); } } } frmEditCt.dtHanTt0.AcceptChanges(); this.btSave.Enabled = false; } else //Lưu xuống SQL Server { DataRow drHanTt = ((DataRowView)bdsHanTt.Current).Row; DataRow[] drArrHanTt0 = dtHanTt0.Select(bdsHanTt0.Filter); double dbTien_PT = Convert.ToDouble(drHanTt["Tien"]); double dbTien_PT_Nt = Convert.ToDouble(drHanTt["Tien_Nt"]); if (dbTien_PT != numTTien_Tt.Value) { if (!Common.MsgYes_No("Giá trị trên chứng từ thanh toán khác với tổng giá trị thanh toán. Bạn có muốn tiếp tục hay không?")) { return; } } else { if (dbTien_PT_Nt != numTTien_Tt_Nt.Value) { if (!Common.MsgYes_No("Giá trị Nt trên chứng từ thanh toán khác với tổng giá trị Nt thanh toán. Bạn có muốn tiếp tục hay không?")) { return; } } } Hashtable htParameter = new Hashtable(); htParameter.Add("STT", drHanTt["Stt"]); htParameter.Add("MA_CT", drHanTt["Ma_Ct"]); htParameter.Add("NGAY_CT", drHanTt["Ngay_Ct"]); htParameter.Add("SO_CT", drHanTt["So_Ct"]); htParameter.Add("DIEN_GIAI", drHanTt["Dien_Giai"]); htParameter.Add("MA_TTE", drHanTt["Ma_Tte"]); htParameter.Add("TY_GIA", drHanTt["Ty_Gia"]); htParameter.Add("TK", drHanTt["Tk"]); htParameter.Add("MA_DT", drHanTt["Ma_Dt"]); htParameter.Add("TIEN_TT", 0); htParameter.Add("TIEN_TT_NT", 0); htParameter.Add("TIEN_CLTG", 0); htParameter.Add("STT_HD", string.Empty); htParameter.Add("MA_DVCS", Element.sysMa_DvCs); foreach (DataRow dr in drArrHanTt0) { if (!(bool)dr["Modify"]) { continue; } htParameter["TIEN_TT"] = Math.Round(Convert.ToDouble(dr["Tien_Tt1"]), 0); htParameter["TIEN_TT_NT"] = Math.Round(Convert.ToDouble(dr["Tien_Tt_Nt1"]), 2, MidpointRounding.AwayFromZero); htParameter["TIEN_CLTG"] = dr["Tien_ClTg"]; htParameter["STT_HD"] = dr["Stt"]; htParameter["LASTMODIFY_LOG"] = dr["LastModify_Log"]; SQLExec.Execute("sp_UpdateHanTt0", htParameter, CommandType.StoredProcedure); } this.btSave.Enabled = false; } }
void btOk_Click(object sender, EventArgs e) { string strSQL = string.Empty; string strTable_PH = string.Empty; string strTable_Ct = string.Empty; if (tabControl1.SelectedTab == tabPageDeleteVoucher) { if (txtMa_Ct.Text != "") { string[] Dmct = txtMa_Ct.Text.Split(new char[] { ',' }); foreach (string strMa_Ct in Dmct) { //Lay ra ten Table can xoa du lieu strTable_PH = (string)SQLExec.ExecuteReturnValue("SELECT Table_Ph FROM SYSDMCT WHERE Ma_Ct ='" + strMa_Ct + "'"); strTable_Ct = (string)SQLExec.ExecuteReturnValue("SELECT Table_Ct FROM SYSDMCT WHERE Ma_Ct ='" + strMa_Ct + "'"); //Thuc hien xoa du lieu if (Common.MsgYes_No(Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có chắc chắn xóa không !" : Element.sysLanguage == enuLanguageType.English ? "Are you sure !" : "你確定 !") && strTable_PH != "" && strTable_Ct != "") { strSQL = "DELETE FROM " + strTable_Ct + " WHERE Ma_Ct = '" + strMa_Ct + "' AND Ngay_Ct BETWEEN '" + Convert.ToDateTime(txtNgay_Ct1.Text).ToShortDateString() + "' AND '" + Convert.ToDateTime(txtNgay_Ct1.Text).ToShortDateString() + "' \r\n" + " DELETE FROM " + strTable_PH + " WHERE Ma_Ct = '" + strMa_Ct + "' AND Ngay_Ct BETWEEN '" + Convert.ToDateTime(txtNgay_Ct1.Text).ToShortDateString() + "' AND '" + Convert.ToDateTime(txtNgay_Ct1.Text).ToShortDateString() + "'"; SQLExec.Execute(strSQL); strSQL = string.Empty; } } } } if (tabControl1.SelectedTab == tabPageDeleteList) { if (Common.MsgYes_No(Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có chắc chắn xóa không !" : Element.sysLanguage == enuLanguageType.English ? "Are you sure !" : "你確定 !")) { strSQL = "DELETE FROM " + cboDanhMuc.SelectedValue.ToString(); SQLExec.Execute(strSQL); strSQL = string.Empty; } } if (tabControl1.SelectedTab == tabPageDeleteDuDau) { if (Common.MsgYes_No(Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có chắc chắn xóa không !" : Element.sysLanguage == enuLanguageType.English ? "Are you sure !" : "你確定 !")) { if (cboDuDau.SelectedValue.ToString() == "INDUDAU") { strSQL = "DELETE FROM " + cboDuDau.SelectedValue.ToString() + " WHERE YEAR(Ngay_Ct) = " + cboNam.SelectedValue.ToString() + " AND Ma_DvCs ='" + Element.sysMa_DvCs + "'"; SQLExec.Execute(strSQL); strSQL = string.Empty; } if (cboDuDau.SelectedValue.ToString() == "GLDUDAU") { strSQL = "DELETE FROM " + cboDuDau.SelectedValue.ToString() + " WHERE Nam = " + cboNam.SelectedValue.ToString() + " AND Ma_DvCs ='" + Element.sysMa_DvCs + "'"; SQLExec.Execute(strSQL); strSQL = string.Empty; } if (cboDuDau.SelectedValue.ToString() == "GLDUDAUXDCB") { strSQL = "DELETE FROM " + cboDuDau.SelectedValue.ToString() + " WHERE YEAR(Ngay_Ct) = " + cboNam.SelectedValue.ToString() + " AND Ma_DvCs ='" + Element.sysMa_DvCs + "'"; SQLExec.Execute(strSQL); strSQL = string.Empty; } if (cboDuDau.SelectedValue.ToString() == "GLDUDAUHANTT") { strSQL = "DELETE FROM " + cboDuDau.SelectedValue.ToString() + " WHERE Nam = " + cboNam.SelectedValue.ToString() + " AND Ma_DvCs ='" + Element.sysMa_DvCs + "'"; SQLExec.Execute(strSQL); strSQL = string.Empty; } } } if (tabControl1.SelectedTab == tabPageDeleteConditional) { if (rtbConditional.Text != "" && Common.MsgYes_No(Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có chắc chắn xóa không !" : Element.sysLanguage == enuLanguageType.English ? "Are you sure !" : "你確定 !")) { strSQL = rtbConditional.Text; SQLExec.Execute(strSQL); strSQL = string.Empty; } } }
void bdsHanTt_PositionChanged(object sender, EventArgs e) { DataRow drHanTt = ((DataRowView)bdsHanTt.Current).Row; bool bReFillHanTt0 = true; if (frmEditCt != null && frmEditCt.dtHanTt0 != null) { if (frmEditCt.dtHanTt0.Select("Tk = '" + (string)drHanTt["Tk"] + "' AND Ma_Dt = '" + (string)drHanTt["Ma_Dt"] + "'").Length > 0) { bReFillHanTt0 = false; dtHanTt0 = frmEditCt.dtHanTt0; bdsHanTt0.DataSource = dtHanTt0; dgvHanTt0.DataSource = bdsHanTt0; } } if (bReFillHanTt0) { Hashtable htParameter = new Hashtable(); if (dtNgay_Ct != DateTime.MinValue) { htParameter.Add("NGAY_CT1", dtNgay_Ct); htParameter.Add("NGAY_CT2", dtNgay_Ct); } else { htParameter.Add("NGAY_CT1", Library.StrToDate(frmFilter.dteNgay_Ct1.Text)); htParameter.Add("NGAY_CT2", Library.StrToDate(frmFilter.dteNgay_Ct2.Text)); } htParameter.Add("TK", (string)drHanTt["Tk"]); htParameter.Add("MA_DT", (string)drHanTt["Ma_Dt"]); htParameter.Add("STT_TT", (string)drHanTt["Stt"]); htParameter.Add("IS_UNGTRUOC", drHanTt["Is_UngTruoc"]); htParameter.Add("MA_DVCS", Element.sysMa_DvCs); dtHanTt0 = SQLExec.ExecuteReturnDt("Sp_GetHanTt0", htParameter, CommandType.StoredProcedure); //Kiểm tra có Modify if (!dtHanTt0.Columns.Contains("Modify")) { dtHanTt0.Columns.Add(new DataColumn("Modify", typeof(bool))); dtHanTt0.Columns["Modify"].DefaultValue = false; } bdsHanTt0.DataSource = dtHanTt0; dgvHanTt0.DataSource = bdsHanTt0; } this.Tinh_Tong(); if (!Common.CheckDataLocked((DateTime)drHanTt["Ngay_Ct"]) && !(bool)drHanTt["Is_UngTruoc"]) { Common.MsgCancel("Dữ liệu đã khóa, liên hệ với nhà quản trị!"); this.dgvHanTt0.ReadOnly = true; return; } else { this.dgvHanTt0.ReadOnly = false; this.dgvHanTt0.Enabled = true; } }
private void Save_HanTt0() { DataRow row3; DataRow CurrRow = ((DataRowView)this.bdsThanhToan.Current).Row; double dbTien_PT = Convert.ToDouble(CurrRow["Tien_PT"]); double dbTien_Pt_Nt = Convert.ToDouble(CurrRow["Tien_PT_Nt"]); if (dbTien_PT != this.numTTien_Tt.Value) { if (!Common.MsgYes_No("Giá trị trên chứng từ thanh toán khác với tổng giá trị thanh toán. Bạn có muốn tiếp tục hay không?")) { return; } } else if (!(dbTien_Pt_Nt == this.numTTien_Tt_Nt.Value) && !Common.MsgYes_No("Giá trị Nt trên chứng từ thanh toán khác với tổng giá trị Nt thanh toán. Bạn có muốn tiếp tục hay không?")) { return; } if (this.frmEditCt != null) { string strTk = CurrRow["Tk"].ToString(); string strMa_Dt = CurrRow["Ma_Dt"].ToString(); if (this.frmEditCt.dtHanTt0 != null) { foreach (DataRow row2 in this.frmEditCt.dtHanTt0.Select("Tk = '" + strTk + "' AND Ma_Dt = '" + strMa_Dt + "'")) { this.frmEditCt.dtHanTt0.Rows.Remove(row2); } } else { this.frmEditCt.dtHanTt0 = this.dtHanTt0.Clone(); } foreach (DataRow row2 in this.dtHanTt0.Select("Tk = '" + strTk + "' AND Ma_Dt = '" + strMa_Dt + "'")) { row3 = this.frmEditCt.dtHanTt0.NewRow(); Common.CopyDataRow(row2, row3); this.frmEditCt.dtHanTt0.Rows.Add(row3); } this.frmEditCt.dtHanTt0.AcceptChanges(); this.btSave.Enabled = false; } else { DataTable dtTableSource = SQLExec.ExecuteReturnDt("SELECT *, CAST(0 AS BIT) AS Thanh_Toan FROM GLTHANHTOANCT WHERE 0 = 1"); foreach (DataRow row2 in this.dtHanTt0.Select(this.bdsHanTt.Filter)) { row3 = dtTableSource.NewRow(); Common.CopyDataRow(row2, row3); if ((row3["Ngay_Ct_TT"] == DBNull.Value) && (((DateTime)row3["Ngay_Ct_TT"]) == Element.sysNgay_Min)) { row3["Ngay_Ct_TT"] = Library.StrToDate(this.dteNgay_Ct.Text); } row3["Stt_PT"] = CurrRow["Stt_PT"]; row3["Tk"] = row2["Tk"]; row3["Ma_Dt"] = row2["Ma_Dt"]; row3["Stt_HD"] = row2["Stt_HD"]; row3["Tien_Tt"] = row2["Tien_Tt1"]; row3["Tien_Tt_Nt"] = row2["Tien_Tt_Nt1"]; row3["Tien_CLTG"] = row2["Tien_CLTG"]; row3["LastModify_Log"] = row2["LastModify_Log"]; dtTableSource.Rows.Add(row3); } dtTableSource.AcceptChanges(); SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand(); command.CommandText = "Sp_Update_CtHanTt"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Stt", ""); command.Parameters.AddWithValue("@Ma_Ct", CurrRow["Ma_Ct_PT"]); command.Parameters.AddWithValue("@Tk", CurrRow["Tk"]); command.Parameters.AddWithValue("@Ma_Dt", CurrRow["Ma_Dt"]); command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs); SqlParameter parameter = new SqlParameter { SqlDbType = SqlDbType.Structured, ParameterName = "@CtHanTt", TypeName = "TVP_CtHanTt", Value = Voucher.GetTVPValue("GLTHANHTOANCT", "TVP_CtHanTt", dtTableSource) }; command.Parameters.Add(parameter); try { command.ExecuteNonQuery(); } catch (Exception exception) { command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION"; command.CommandType = CommandType.Text; command.Parameters.Clear(); command.ExecuteNonQuery(); MessageBox.Show("Có lỗi xảy ra :" + exception.Message); } this.btSave.Enabled = false; } }
public override void Delete() { if (bdsViewPh.Position < 0) { return; } DataRow drCurrent = ((DataRowView)bdsViewPh.Current).Row; string strMa_Ct = ((string)drCurrent["Ma_Ct"]).Trim(); string strStt = ((string)drCurrent["Stt"]).Trim(); if (!Common.CheckDataLocked((DateTime)drCurrent["Ngay_Ct"])) { Common.MsgCancel("Đã khóa chứng từ không được xóa !"); return; } if (Voucher.CheckDataLockedCtHanTtHD(strStt)) { Common.MsgCancel("Chứng từ đã được thanh toán không được xóa !"); return; } if (Voucher.CheckDataLockedPXK(strStt)) { Common.MsgCancel("Chứng từ đã được tạo phiếu xuất kho: " + (string)drCurrent["So_Ct_Lap"] + " không được xóa !"); return; } if (!Element.sysIs_Admin) { string strCreate_User = (string)drCurrent["Create_Log"]; if (strCreate_User != string.Empty && strCreate_User.Substring(14) != Element.sysUser_Id) { string strUser_Allow = (string)SQLExec.ExecuteReturnValue("SELECT Member_ID_Allow FROM SYSMEMBER WHERE Member_ID = '" + Element.sysUser_Id + "'") + ","; if (!strUser_Allow.Contains("*,")) //Được phép sửa tất cả { if (!strUser_Allow.Contains(strCreate_User.Substring(14) + ",")) { Common.MsgCancel("Không được xóa chứng từ do " + strCreate_User.Substring(14) + " lập, liên hệ với Admin!"); return; } } } } if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE"), "N")) { return; } //if (Voucher.SQLDeleteCt(strStt, strMa_Ct)) //{ // bdsViewPh.RemoveAt(bdsViewPh.Position); // dtViewPh.AcceptChanges(); //} if (dgvViewPh.dgvGridView.IsMultiSelect)// Chọn nhiều đơn hàng để xóa { int ivoucher = dgvViewPh.dgvGridView.SelectedRowsCount; //if (ivoucher == 1) // if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE"), "N")) // return; if (ivoucher > 1) { if (!Common.MsgYes_No("Bạn có chắc chắn xóa " + ivoucher.ToString() + " hóa đơn?", "N")) { return; } } int[] a = dgvViewPh.dgvGridView.GetSelectedRows(); for (int i = (a.Length - 1); i >= 0; i--) { int istt = a[i]; string stt = dgvViewPh.dgvGridView.GetRowCellValue(istt, "STT").ToString(); if (Voucher.CheckDataLockedCtHanTtHD(stt)) { Common.MsgCancel("Chứng từ đã được thanh toán không được xóa !"); continue; } else if (Voucher.CheckDataLockedPXK(strStt)) { Common.MsgCancel("Chứng từ đã được tạo phiếu xuất kho: " + (string)drCurrent["So_Ct_Lap"] + " không được xóa !"); continue; } if (Voucher.SQLDeleteCt(stt, strMa_Ct)) { bdsViewPh.RemoveAt(bdsViewPh.Position); dtViewPh.AcceptChanges(); } } this.FillDataNew(); } else // Chỉ xóa 1 đơn hàng { if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE"), "N")) { return; } //-------------------------------------------------------------------- if (Voucher.SQLDeleteCt(strStt, strMa_Ct)) { bdsViewPh.RemoveAt(bdsViewPh.Position); dtViewPh.AcceptChanges(); } } }
public void LoadScreen() { //TreeMain //ucTreeMain = new UcTreeMain(); //ucTreeMain.LoadControl(this.iModule_ID); //ucTreeMain.Dock = DockStyle.Top; //ucTreeMain.Width = pnlLeftScreen.Width - 20; //ucTreeMain.MinimumSize = new Size(ucTreeMain.Width, pnlLeftScreen.Height / 3); //ucTreeMain.MaximumSize = new Size(ucTreeMain.Width, pnlLeftScreen.Height * 6 / 6); //ucTreeMain.SetProperlyHeight(); //ucTreeMain.Visible = false; //pnlLeftScreen.Controls.Add(ucTreeMain); ucNarvarMain = new ucNarMain(); ucNarvarMain.LoadControl(); ucNarvarMain.Anchor = AnchorStyles.Top | AnchorStyles.Left; ucNarvarMain.SetProperlyHeight(this); //ucNarvarMain.Width = pnlLeftScreen.Width; //pnlLeftScreen.Controls.Add(ucNarvarMain); //this.pnlLeftScreen.Visible = false; ///////////////////////// pnlScreen.Dock = DockStyle.Fill; this.pnlCenter.Dock = DockStyle.Fill; this.ucNarvarMain.Dock = DockStyle.Left; pnlScreen.Anchor = ((AnchorStyles)((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))); //////////////////////// tbTabPageControl tbTabPageMain = new tbTabPageControl(); tbTabPageMain.Tag = "MAIN"; //this.pnImage = new pnlControl(); //if (Element.sysLanguage == enuLanguageType.Vietnamese) // pnImage.BackgroundImage = Commons.Properties.Resources.Background_V; //else // pnImage.BackgroundImage = Commons.Properties.Resources.Background_E; this.pnImage = new pnlControl(); if (Element.sysLanguage == enuLanguageType.Vietnamese) { this.pnImage.BackgroundImage = Commons.Properties.Resources.Background_V; if (File.Exists(Application.StartupPath + @"\Images\Background_V.png")) { this.pnImage.BackgroundImage = Image.FromFile(Application.StartupPath + @"\Images\Background_V.png"); } } else if (Element.sysLanguage == enuLanguageType.English) { this.pnImage.BackgroundImage = Commons.Properties.Resources.Background_E; if (File.Exists(Application.StartupPath + @"\Images\Background_E.png")) { this.pnImage.BackgroundImage = Image.FromFile(Application.StartupPath + @"\Images\Background_E.png"); } } else { this.pnImage.BackgroundImage = Commons.Properties.Resources.Background_E; if (File.Exists(Application.StartupPath + @"\Images\Background_O.png")) { this.pnImage.BackgroundImage = Image.FromFile(Application.StartupPath + @"\Images\Background_O.png"); } } pnImage.BackgroundImageLayout = ImageLayout.Stretch; pnImage.Dock = DockStyle.Fill; //Add chart on the main #region Chart bool bloadChart = DataTool.SQLCheckExist("sys.procedures", "Name", "SYS_LoadMainChart"); if (bloadChart) //Collection.Parameters.ContainsKey("MAINCHART") { DataSet dsChart = SQLExec.ExecuteReturnDs("SYS_LoadMainChart @Ma_Dvcs ='" + Element.sysMa_DvCs + "',@Nam = " + Element.sysWorkingYear.ToString() + ""); //DataSet dsChart = SQLExec.ExecuteReturnDs("SYS_LoadMainChart"); this.mainchart = new MainChart(); mainchart.LoadChart(dsChart); mainchart.Dock = DockStyle.Fill; this.pnImage.Controls.Add(mainchart); } #endregion this.tbTabMain.Anchor = ((AnchorStyles)((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))); tbTabMain.Dock = DockStyle.Fill; tbTabMain.Visible = false; pnlScreen.Dock = DockStyle.Fill; this.pnlScreen.Controls.Add(ucNarvarMain); this.pnlCenter.Controls.Add(tbTabMain); this.pnlCenter.Controls.Add(pnImage); this.ssMain.Dock = DockStyle.Bottom; this.pnlCenter.Controls.Add(ssMain); //ModuleManagement Nhac viet this.ucModuleManagement.Dock = DockStyle.Bottom; this.ucModuleManagement.Width = pnlLeftScreen.Width - 20; this.UcModuleHeight = this.ucModuleManagement.Height; //this.ucModuleManagement.Height = this.UcModuleHeight - this.ucModuleManagement.lvReminder.Height; this.pnImage.Controls.Add(ucModuleManagement); //ucCustomer = new ucCustomerInfo(); //ucCustomer.Anchor = AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Bottom; //ucCustomer.Location = new Point(this.pnImage.Width / 2 + 200, this.pnImage.Height / 2); //this.pnImage.Controls.Add(ucCustomer); //ucModuleManagement.Width = 250; //ucModuleManagement.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; //ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, 1); //ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, this.pnlCenter.Height - ucModuleManagement.Height - 20); //ucModuleManagement.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; /* * * //ModuleManagement Nhac viet * //ucModuleManagement.Dock = DockStyle.Bottom; * //ucModuleManagement.Width = pnlLeftScreen.Width - 20; * * // pnlLeftScreen.Controls.Add(ucModuleManagement); * * //ucModuleManagement.Width = 250; * //ucModuleManagement.Anchor = AnchorStyles.Top | AnchorStyles.Right; * //if (iModule_ID <= 0) * //{ * // this.pnlCenter.Controls.Add(ucModuleManagement); * // //ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, 1); * // ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, this.pnlCenter.Height - ucModuleManagement.Height - 20); * // ucModuleManagement.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; * //} * * //Cac control khac * * //ucCustomer = new ucCustomerInfo(); * //this.pnlCenter.Controls.Add(ucCustomer); * * //tbTabPageMain.Controls.Add(ucCustomer); * //ucCustomer.Location = new Point(0, 0); * //ucCustomer.Anchor = AnchorStyles.Top | AnchorStyles.Left; */ //Test //ucWTable ucDesk = new ucWTable(); //ucDesk.Load(); //ucDesk.Dock = DockStyle.Fill; //pnImage.Controls.Add(ucDesk); // }
void frmThanhToan_KeyDown(object sender, KeyEventArgs e) { //if (e.KeyCode == Keys.F6) //{ // if (numTTien_Dua.Value == 0) // { // string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Vui lòng nhập số tiền khách hàng đưa !" : "Please enter the amount to the customer"; // Common.MsgCancel(strMsg); // numTTien_Dua.Focus(); // } // else if (numTTien_Dua.Value < numTTien_Nt.Value) // { // string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Số tiền khách hàng đưa > Số tiền thanh toán !" : "Amount customers make > Payment amount!"; // Common.MsgCancel(strMsg); // numTTien_Dua.Focus(); // } // else // { // Save3(); // string strReport_File_First = string.Empty; // bool bInVisibleNextPrint = false; // enuNew_Edit = enuEdit.Edit; // PrintVoucher.Print(drEditPh1, false, false, ref bInVisibleNextPrint, ref strReport_File_First); // } //} if (e.KeyCode == Keys.F6) { if (numTTien_Dua.Value == 0) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Vui lòng nhập số tiền khách hàng đưa !" : "Please enter the amount to the customer"; Common.MsgCancel(strMsg); numTTien_Dua.Focus(); } else if (numTTien_Dua.Value < numTTien_Nt.Value) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Số tiền khách hàng đưa > Số tiền thanh toán !" : "Amount customers make > Payment amount!"; Common.MsgCancel(strMsg); numTTien_Dua.Focus(); } else { Save3(); //Tự động tạo phiếu thu tiền Hashtable ht = new Hashtable(); ht["STT"] = strStt1; ht["NGAY_CT"] = drEditPh1["Ngay_Ct"]; ht["SO_CT"] = drEditPh1["So_Ct"]; ht["MA_DT"] = drEditPh1["Ma_Dt"]; ht["TIEN"] = drEditPh1["TTien0"]; ht["TIEN_NT"] = drEditPh1["TTien_Nt0"]; ht["TK_NO"] = drDmCt1["TK_No"]; ht["TK_CO"] = drDmCt1["TK_Co"]; ht["MA_DVCS"] = drEditPh1["Ma_DvCs"]; SQLExec.Execute("sp_UpdatePOS_InsertPT", ht, CommandType.StoredProcedure); string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Đã lưu !" : " Save successful !"; Common.MsgCancel(strMsg); } } if (e.KeyCode == Keys.F7) { if (numTTien_Dua.Value == 0) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Vui lòng nhập số tiền khách hàng đưa !" : "Please enter the amount to the customer"; Common.MsgCancel(strMsg); numTTien_Dua.Focus(); } else if (numTTien_Dua.Value < numTTien_Nt.Value) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Số tiền khách hàng đưa > Số tiền thanh toán !" : "Amount customers make > Payment amount!"; Common.MsgCancel(strMsg); numTTien_Dua.Focus(); } else { Save3(); //Tự động tạo phiếu thu tiền Hashtable ht = new Hashtable(); ht["STT"] = strStt1; ht["NGAY_CT"] = drEditPh1["Ngay_Ct"]; ht["SO_CT"] = drEditPh1["So_Ct"]; ht["MA_DT"] = drEditPh1["Ma_Dt"]; ht["TIEN"] = drEditPh1["TTien0"]; ht["TIEN_NT"] = drEditPh1["TTien_Nt0"]; ht["TK_NO"] = drDmCt1["TK_No"]; ht["TK_CO"] = drDmCt1["TK_Co"]; ht["MA_DVCS"] = drEditPh1["Ma_DvCs"]; SQLExec.Execute("sp_UpdatePOS_InsertPT", ht, CommandType.StoredProcedure); string strReport_File_First = string.Empty; bool bInVisibleNextPrint = false; enuNew_Edit = enuEdit.Edit; PrintVoucher.Print(drEditPh1, false, false, ref bInVisibleNextPrint, ref strReport_File_First); this.Close(); } } }