private void button11_Click_1(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
// UpdateControlTypeforPaymentrpt
#region ClearABbelanceZezoinFbl5n
SqlConnection conn2 = null;
SqlDataReader rdr1 = null;
string destConnString = Utils.getConnectionstr();
try
{
conn2 = new SqlConnection(destConnString);
conn2.Open();
SqlCommand cmd1 = new SqlCommand("UpdateControlTypeforPaymentrpt", conn2);
cmd1.CommandType = CommandType.StoredProcedure;
// cmd1.Parameters.Add("@name", SqlDbType.VarChar).Value = userupdate;
rdr1 = cmd1.ExecuteReader();
// rdr1 = cmd1.ExecuteReader();
}
finally
{
if (conn2 != null)
{
conn2.Close();
}
if (rdr1 != null)
{
rdr1.Close();
}
}
// MessageBox.Show("ok", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
#endregion
string username = Utils.getusername();
FormCollection fc = System.Windows.Forms.Application.OpenForms;
bool kq = false;
foreach (Form frm in fc)
{
if (frm.Text == "Fromdate to Date Select")
{
kq = true;
frm.Focus();
}
}
if (!kq)
{
View.KafromtoSelect kafromto = new View.KafromtoSelect();
kafromto.ShowDialog();
DateTime fromdate = kafromto.fromdate;
DateTime todate = kafromto.todate;
var regioncode = (from tbl_Temp in dc.tbl_Temps
where tbl_Temp.username == username
select tbl_Temp.RegionCode).FirstOrDefault();
var liveandinregion = from tbl_kacontractdata in dc.tbl_kacontractdatas
where (from Tka_RegionRight in dc.Tka_RegionRights
where Tka_RegionRight.RegionCode == regioncode
select Tka_RegionRight.Region
).Contains(tbl_kacontractdata.SalesOrg)
select tbl_kacontractdata.ContractNo;
var rscustemp2 = from tbl_kacontractsdetailpayment in dc.tbl_kacontractsdetailpayments
from tbl_kacontractdata in dc.tbl_kacontractdatas
where liveandinregion.Contains(tbl_kacontractsdetailpayment.ContractNo)
&& tbl_kacontractsdetailpayment.ContractNo == tbl_kacontractdata.ContractNo
&& tbl_kacontractsdetailpayment.PaidOn >= fromdate
&& tbl_kacontractsdetailpayment.PaidOn <= todate
select new
{
tbl_kacontractsdetailpayment.ContractNo,
Contract_status = tbl_kacontractdata.Consts,
Contract_Type = tbl_kacontractdata.ConType,
tbl_kacontractsdetailpayment.BatchNo,
ContracName = tbl_kacontractsdetailpayment.ContracName.Trim(),
tbl_kacontractsdetailpayment.PayType,
tbl_kacontractsdetailpayment.PayID,
Description = tbl_kacontractsdetailpayment.Description.Trim(),
tbl_kacontractsdetailpayment.PaidRequestAmt,
tbl_kacontractsdetailpayment.PayControl,
tbl_kacontractsdetailpayment.ControlType,
tbl_kacontractsdetailpayment.PrintDate,
Remark = tbl_kacontractsdetailpayment.Remark.Trim(),
tbl_kacontractsdetailpayment.CRDDAT,
tbl_kacontractsdetailpayment.CRDUSR,
tbl_kacontractsdetailpayment.SubID,
};
Viewtable viewtbl = new Viewtable(rscustemp2, dc, "LIST ALL PAYMENT", 3);// view code 1 la can viet them lenh
viewtbl.Show();
}
}
private void button18_Click_1(object sender, EventArgs e)
{
// KafromtoSelect
FormCollection fc = System.Windows.Forms.Application.OpenForms;
bool kq = false;
foreach (Form frm in fc)
{
if (frm.Text == "Fromdate to Date Select")
{
kq = true;
frm.Focus();
}
}
if (!kq)
{
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
View.KafromtoSelect KafromtoSelect = new View.KafromtoSelect();
KafromtoSelect.ShowDialog();
DateTime Fromdate = KafromtoSelect.fromdate;
DateTime Todate = KafromtoSelect.todate;
Boolean choose = KafromtoSelect.choose;
// KafromtoSelect.Close();
#region// update pc, uc, ..
SqlConnection conn2 = null;
SqlDataReader rdr1 = null;
string destConnString = Utils.getConnectionstr();
if (choose)
{
try
{
conn2 = new SqlConnection(destConnString);
conn2.Open();
SqlCommand cmd1 = new SqlCommand("REKAupdateSalePC_UCtemptableFromTo", conn2);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@fromdate", SqlDbType.DateTime).Value = Fromdate;
cmd1.Parameters.Add("@todate", SqlDbType.DateTime).Value = Todate;
cmd1.CommandTimeout = 0;
rdr1 = cmd1.ExecuteReader();
MessageBox.Show("Recaculation Done !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
// rdr1 = cmd1.ExecuteReader();
}
finally
{
if (conn2 != null)
{
conn2.Close();
}
if (rdr1 != null)
{
rdr1.Close();
}
}
// MessageBox.Show("ok", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
#endregion update pc, uc
//string priod = kaPriodpicker.priod;
//var rs = from tbl_kasale in dc.tbl_kasales
// where tbl_kasale.Priod == priod
// select new
}
}
