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