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