public inheriteContext(paramIndex param)
: base()
{
int mqt_id = 0;
if (param == paramIndex.Site)
{
manage_queue_transaction pk_mqt = cdc.manage_queue_transactions.Where(x => x.mqt_id == Program.CurrentSite.mhs_id).FirstOrDefault();
if (pk_mqt != null)
{
mqt_id = pk_mqt.mqt_id;
}
else
{
using (inheriteContext insContext = new inheriteContext())
{
manage_queue_transaction ins_mqt = new manage_queue_transaction();
ins_mqt.mqt_site_id = Program.CurrentSite.mhs_id;
ins_mqt.mqt_flag = true;
insContext.manage_queue_transactions.InsertOnSubmit(ins_mqt);
insContext.SubmitChanges();
mqt_id = ins_mqt.mqt_id;
}
}
}
cdc.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED");
cdc.Connection.Open();
DbTransaction trans = cdc.Connection.BeginTransaction();
cdc.Transaction = trans;
manage_queue_transaction mqt = cdc.manage_queue_transactions.Where(x => x.mqt_id == mqt_id).FirstOrDefault();
mqt.mqt_tpr_id = 0;
mqt.mqt_update_date = Program.GetServerDateTime();
mqt.mqt_flag = false;
mqt.mqt_user_name = "system";
cdc.SubmitChanges();
}
private void CheckDateAndUpdateCurrentDate()
{
try
{
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
mst_cur_date objcurrentDate = (from t1 in cdc.mst_cur_dates select t1).FirstOrDefault();
DateTime currentddate = objcurrentDate.mcd_cur_date;
DateTime NowDate = DateTime.Now;
DateTime ResetDate = new DateTime(NowDate.Year, NowDate.Month, NowDate.Day, 4, 0, 0);
if (currentddate.Date != ResetDate.Date)
{
cdc.ExecuteCommand("update mst_cur_date set mcd_cur_date={0}", ResetDate.ToString());
cdc.SubmitChanges();
}
}
}
catch (Exception ex)
{
lberror.Text = ex.Message;
}
}
