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