public static void addQcCheckHead(TC_QCY_FILE model, string qcx06) { //开启事务管理1.添加记录。2.添加 tc_qcz_file 。 using (TransactionScope sc = new TransactionScope()) { try { //1.添加 Tcqcys.AddModel(model); //2.添加 tc_qcz_file List <TC_QCX_FILE> qcxlist = Tcqcxs.GetList(qcx06, 0); foreach (TC_QCX_FILE qcx in qcxlist) { TC_QCZ_FILE qcz = new TC_QCZ_FILE(); qcz.TC_QCZ01 = model.TC_QCY01; qcz.TC_QCZ02 = qcx.TC_QCX02; qcz.TC_QCZ05 = qcx.TC_QCX01; qcz.TC_QCZ07 = qcx.TC_QCX07; qcz.TC_QCZ06 = qcx.TC_QCX03; qcz.TC_QCZ09 = qcx.TC_QCX04; Tcqczs.AddModel(qcz); } //事务提交 sc.Complete(); } catch (Exception Ex) { throw Ex; } } }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool AddModel(TC_QCZ_FILE model) { bool returnFlag = false; using (OraDBContext dbContext = new OraDBContext()) { //增加 dbContext.TC_QCZ_FILE.Add(model); dbContext.SaveChanges(); returnFlag = true; } return(returnFlag); }
public static void reloadqcz(string qcz01) { //开启事务管理1.添加记录。2.添加 tc_qcz_file 。 using (TransactionScope sc = new TransactionScope()) { try { //1.删除记录 Tcqczs.DeleteModel(qcz01); //2.添加记录 string qcx06 = qcz01.Substring(0, qcz01.IndexOf('-')); List <TC_QCX_FILE> qcxlist = Tcqcxs.GetList(qcx06, 0); foreach (TC_QCX_FILE qcx in qcxlist) { TC_QCZ_FILE qcz = new TC_QCZ_FILE(); qcz.TC_QCZ01 = qcz01; qcz.TC_QCZ02 = qcx.TC_QCX02; qcz.TC_QCZ05 = qcx.TC_QCX01; qcz.TC_QCZ06 = qcx.TC_QCX03; qcz.TC_QCZ07 = qcx.TC_QCX07; qcz.TC_QCZ09 = qcx.TC_QCX04; Tcqczs.AddModel(qcz); } //事务提交 sc.Complete(); } catch (Exception Ex) { throw Ex; } } }
public static void UpdateModel(TC_QCZ_FILE model, string sid, int qcz05) { using (OraDBContext dbContext = new OraDBContext()) { var editmodel = dbContext.TC_QCZ_FILE.Where(u => u.TC_QCZ01 == sid && u.TC_QCZ05 == qcz05).FirstOrDefault(); if (editmodel == null) { return;//空 } editmodel.TC_QCZ02 = model.TC_QCZ02; editmodel.TC_QCZ03 = model.TC_QCZ03; editmodel.TC_QCZ04 = model.TC_QCZ04; //editmodel.TC_QCZ05 = model.TC_QCY05; editmodel.TC_QCZ06 = model.TC_QCZ06; editmodel.TC_QCZ07 = model.TC_QCZ07; editmodel.TC_QCZ08 = model.TC_QCZ08; editmodel.TC_QCZ09 = model.TC_QCZ09; editmodel.TC_QCZ10 = model.TC_QCZ10; editmodel.TC_QCZ11 = model.TC_QCZ11; //提交修改 dbContext.SaveChanges(); } }