public inheriteContext() : base() { 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 == 1).FirstOrDefault(); mqt.mqt_tpr_id = 0; mqt.mqt_update_date = Program.GetServerDateTime(); mqt.mqt_flag = false; mqt.mqt_user_name = "system"; cdc.SubmitChanges(); }
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(); }
public bool StartManageTransaction() { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { try { cdc.Connection.Open(); DbTransaction tran = cdc.Connection.BeginTransaction(); cdc.Transaction = tran; int?tpr_id = null; if (Program.CurrentRegis != null) { tpr_id = Program.CurrentRegis.tpr_id; } string user_name = null; if (Program.CurrentUser != null) { user_name = Program.CurrentUser.mut_username; } manage_queue_transaction mqt = cdc.manage_queue_transactions.Where(x => x.mqt_id == 1).FirstOrDefault(); if (mqt == null) { mqt = new manage_queue_transaction { mqt_flag = null }; cdc.manage_queue_transactions.InsertOnSubmit(mqt); } mqt.mqt_tpr_id = tpr_id; mqt.mqt_update_date = Program.GetServerDateTime(); mqt.mqt_user_name = user_name; mqt.mqt_flag = true; try { cdc.SubmitChanges(); } catch (ChangeConflictException) { return(StartManageTransaction()); } catch { return(false); } cdc.Transaction.Commit(); return(true); } catch { cdc.Transaction.Rollback(); return(false); } finally { cdc.Connection.Close(); } } } catch { return(false); } }