/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <param name="sid"></param>
public static void UpdateModel(TC_QCY_FILE model, string sid)
{
using (OraDBContext dbContext = new OraDBContext())
{
var editmodel = dbContext.TC_QCY_FILE.Where(u => u.TC_QCY01 == sid).FirstOrDefault();
if (editmodel == null)
{
return;//空
}
editmodel.TC_QCY02 = model.TC_QCY02;
editmodel.TC_QCY03 = model.TC_QCY03;
editmodel.TC_QCY04 = model.TC_QCY04;
editmodel.TC_QCY05 = model.TC_QCY05;
editmodel.TC_QCY06 = model.TC_QCY06;
editmodel.TC_QCY07 = model.TC_QCY07;
editmodel.TC_QCY08 = model.TC_QCY08;
editmodel.TC_QCY09 = model.TC_QCY09;
editmodel.TC_QCY10 = model.TC_QCY10;
editmodel.TC_QCY11 = model.TC_QCY11;
editmodel.TC_QCY12 = model.TC_QCY12;
editmodel.TC_QCY13 = model.TC_QCY13;
editmodel.TC_QCY14 = model.TC_QCY14;
//提交修改
dbContext.SaveChanges();
}
}
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_QCY_FILE model)
{
bool returnFlag = false;
using (OraDBContext dbContext = new OraDBContext())
{
//增加
dbContext.TC_QCY_FILE.Add(model);
dbContext.SaveChanges();
returnFlag = true;
}
return(returnFlag);
}
/// <summary>
/// 获取最大流水号
/// </summary>
/// <param name="prefix"></param>
/// <returns></returns>
public static int getQcCheckHeadMaxNumber(string prefix)
{
int returnNumber = 0;
TC_QCY_FILE model = Tcqcys.GetMaxModel(prefix);
if (model != null)
{
//取最后三位流水号
string flow = model.TC_QCY01.Substring(model.TC_QCY01.Length - 3);
returnNumber = TypeHelper.StringToInt(flow);
}
return(returnNumber);
}