/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddModel(TC_QCZZ_FILE model)
{
bool returnFlag = false;
using (OraDBContext dbContext = new OraDBContext())
{
//增加
dbContext.TC_QCZZ_FILE.Add(model);
dbContext.SaveChanges();
returnFlag = true;
}
return(returnFlag);
}
public static void addQcOutCheckHead(TC_QCYY_FILE model, string qcx06)
{
//开启事务管理1.添加记录。2.添加 tc_qcz_file 。
using (TransactionScope sc = new TransactionScope())
{
try
{
//1.添加
Tcqcyys.AddModel(model);
//2.添加 tc_qcz_file
List <TC_QCXX_FILE> qcxlist = Tcqcxxs.GetList(qcx06, 1);
foreach (TC_QCXX_FILE qcx in qcxlist)
{
TC_QCZZ_FILE qcz = new TC_QCZZ_FILE();
qcz.TC_QCZZ01 = model.TC_QCYY01;
qcz.TC_QCZZ02 = qcx.TC_QCXX02;
qcz.TC_QCZZ06 = qcx.TC_QCXX01;
qcz.TC_QCZZ07 = qcx.TC_QCXX03;
qcz.TC_QCZZ08 = qcx.TC_QCXX07;
qcz.TC_QCZZ10 = qcx.TC_QCXX04;
qcz.TC_QCZZ11 = qcx.TC_QCXX08;
qcz.TC_QCZZ09 = qcx.TC_QCXX09;
Tcqczzs.AddModel(qcz);
}
//事务提交
sc.Complete();
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public static void UpdateModel(TC_QCZZ_FILE model, string sid, int qczz06)
{
using (OraDBContext dbContext = new OraDBContext())
{
var editmodel = dbContext.TC_QCZZ_FILE.Where(u => u.TC_QCZZ01 == sid && u.TC_QCZZ06 == qczz06).FirstOrDefault();
if (editmodel == null)
{
return;//空
}
editmodel.TC_QCZZ02 = model.TC_QCZZ02;
editmodel.TC_QCZZ03 = model.TC_QCZZ03;
editmodel.TC_QCZZ04 = model.TC_QCZZ04;
editmodel.TC_QCZZ05 = model.TC_QCZZ05;
editmodel.TC_QCZZ06 = model.TC_QCZZ06;
editmodel.TC_QCZZ07 = model.TC_QCZZ07;
editmodel.TC_QCZZ08 = model.TC_QCZZ08;
editmodel.TC_QCZZ09 = model.TC_QCZZ09;
editmodel.TC_QCZZ10 = model.TC_QCZZ10;
editmodel.TC_QCZZ11 = model.TC_QCZZ11;
//提交修改
dbContext.SaveChanges();
}
}
