/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <param name="sid"></param>
public static void UpdateModel(TC_QCYY_FILE model, string sid)
{
using (OraDBContext dbContext = new OraDBContext())
{
var editmodel = dbContext.TC_QCYY_FILE.Where(u => u.TC_QCYY01 == sid).FirstOrDefault();
if (editmodel == null)
{
return;//空
}
editmodel.TC_QCYY02 = model.TC_QCYY02;
editmodel.TC_QCYY03 = model.TC_QCYY03;
editmodel.TC_QCYY04 = model.TC_QCYY04;
editmodel.TC_QCYY05 = model.TC_QCYY05;
editmodel.TC_QCYY06 = model.TC_QCYY06;
editmodel.TC_QCYY07 = model.TC_QCYY07;
editmodel.TC_QCYY08 = model.TC_QCYY08;
editmodel.TC_QCYY09 = model.TC_QCYY09;
editmodel.TC_QCYY10 = model.TC_QCYY10;
editmodel.TC_QCYY11 = model.TC_QCYY11;
editmodel.TC_QCYY12 = model.TC_QCYY12;
editmodel.TC_QCYY13 = model.TC_QCYY13;
editmodel.TC_QCYY14 = model.TC_QCYY14;
//提交修改
dbContext.SaveChanges();
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddModel(TC_QCYY_FILE model)
{
bool returnFlag = false;
using (OraDBContext dbContext = new OraDBContext())
{
//增加
dbContext.TC_QCYY_FILE.Add(model);
dbContext.SaveChanges();
returnFlag = true;
}
return(returnFlag);
}
/// <summary>
/// 获取最大流水号 出货单
/// </summary>
/// <param name="prefix"></param>
/// <returns></returns>
public static int getQcOutCheckHeadMaxNumber(string prefix)
{
int returnNumber = 0;
TC_QCYY_FILE model = Tcqcyys.GetMaxModel(prefix);
if (model != null)
{
//取最后三位流水号
string flow = model.TC_QCYY01.Substring(model.TC_QCYY01.Length - 3);
returnNumber = TypeHelper.StringToInt(flow);
}
return(returnNumber);
}
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;
}
}
}
