private void tsmiDeletePay_Click(object sender, EventArgs e)
{
try
{
Int16 PayID = Convert.ToInt16(dgvAllPay.CurrentRow.Cells[0].Value);
DataTable dtDFPP = new DataTable();///// DFPP= Delete From Person Pay
dtDFPP = GS.db.Query("SELECT * FROM `accounting` WHERE `id`='" + PayID.ToString() + "'");
if (dtDFPP != null)
{
string QMessage = "میخواهید پرداختی شخص با مبلغ " + GS.nf(dtDFPP.Rows[0]["payPrice"].ToString()) + " و با شرح ( " + dtDFPP.Rows[0]["payAbout"].ToString() + " )را حذف کنید؟";
if (GS.dialog.Question("حذف پرداختی ها", QMessage) == DialogResult.OK)
{
if (dtDFPP.Rows[0]["payMethod"].ToString() == "doc")
{
if (GS.dialog.Question("حذف چک پرداختی مشتری", "پرداخت از نوع چک می باشد آیا میخواهید آن را حذف کنید؟") == DialogResult.OK)
{
chek ZSMC = new chek();
// string CheckSerial = Regex.Match(dtDFPP.Rows[0]["payAbout"].ToString(), @"\d").Value.ToString();
string CheckSerial = dtDFPP.Rows[0]["payAbout"].ToString();
string CSN = Regex.Replace(CheckSerial, @"\D", "").ToString();
//MessageBox.Show(CSN);
ZSMC.delet_chek(CSN);
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
TL.delete(PayID);
SelectPersonal();
}
}
else
{
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
TL.delete(PayID);
SelectPersonal();
}
}
}//////// End Validate Result of selected row from pay list
}
catch { }
}
private void frmMain_Activated(object sender, EventArgs e)
{
chek ChequeSystem = new chek();
var ChequeDT = new DataTable();
var newDate = new DateTime();
newDate = DateTime.Now.AddDays(7);
string Next7DayDate = GS.dateManager.GetPersianDate(newDate);
//MessageBox.Show(Next7DayDate + " : " + GS.GetCurrentDate());
//string PNowDate=
/////////// بحث تاریخ ها درحال اجرا بود.
string TypeCheck = "0";////// 1= چک های پرداختی ------ And ------ 0= چک های دریافتی
string CQ = "WHERE `t_saresid` BETWEEN '" + GS.dateManager.GetCurrentPersianDate() + "' AND '" + Next7DayDate + "' AND `typeCheck`='" + TypeCheck + "' ORDER BY `t_saresid`";
//string CQ = "WHERE `t_saresid` BETWEEN '" + GS.GetCurrentDate() + "' AND '" + Next7DayDate + "' ORDER BY `t_saresid`";
ChequeDT = ChequeSystem.read_chek(CQ);
if (ChequeDT != null)
{
if (ChequeDT.Rows.Count > 0)
{
dgvChequeWekList.AutoGenerateColumns = false;
dgvChequeWekList.DataSource = ChequeDT;
dgvChequeWekList.Refresh();
gbNextWeekCheque.Visible = true;
}
else
{
gbNextWeekCheque.Visible = false;
//tableLayoutPanel1.Visible = false;
}
}////// End ChequeDT Value
}