public bool AddOrUpdateContractTrace(SD_CDetail main, List<SD_ContractTrace> list)
{
bool result = false;
//long ContractId = 0;
try
{
List<SD_ContractTrace> oldList = GetTraceContractList(main.CDetail_Code);
//保存合同细目
for (int i = 0; i < oldList.Count; i++)
{
var temp = list.FirstOrDefault(o => o.SDT_Code == oldList[i].SDT_Code);
if (temp != null)
{
//var item = SDetailList[i];
var item = oldList[i];
//if (bllCdetail.CheckExist(SDetailList[i].CDetail_ContractNo, SDetailList[i].CDetail_PartNo))
//{
temp.SDT_ID = item.SDT_ID;
Update(temp);
list.Remove(temp);
}
else
{
Delete(oldList[i]);
}
}
foreach (var it in list)
{
it.SDT_Code = GenerateCTraceCode();
it.SDT_MainCode = main.CDetail_Code;
it.SDT_ContractCode = main.CDetail_ContractNo;
it.SDT_PartNo = main.CDetail_PartNo;
it.SDT_PartName = main.CDetail_PartName;
Insert(it);
}
//bllContract.instance.idb.CommitTransaction();
result = true;
}
catch (Exception ex)
{
//bllContract.instance.idb.RollbackTransaction();
throw ex;
}
return result;
}
public bool AddOrUpdateFinance(SD_CDetail sd,List<SD_Finance> list)
{
List<SD_Finance> oldlist = GetFinanceListByContract(sd);
foreach (var d in oldlist)
{
var model = list.FirstOrDefault(o => o.SDF_Code == d.SDF_Code);
if (model != null)
{
model.SDF_ID = d.SDF_ID;
UpdateFinance(model);
list.Remove(model);
}
else
{
DeleteFinance(d);
}
}
foreach (var d in list)
{
d.SDF_Code = GenerateSDFinance();
AddFinance(d);
}
return true;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SD_CDetail model)
{
bool result = false;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return result;
}
/// <summary>
/// 插入数据 并返回数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public long InsertWithReturnId(SD_CDetail model)
{
long result = 0;
object _result = instance.AddWithReturn(model);
if (_result != null)
{
long.TryParse(_result.ToString(), out result);
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(SD_CDetail model)
{
bool result = false;
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
return result;
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name="strCondition"></param>
/// <returns></returns>
public SD_CDetail GetModel(string strCondition)
{
List<SD_CDetail> list = instance.GetListByWhere(strCondition);
SD_CDetail model = new SD_CDetail();
if (list != null && list.Count > 0)
{
model = list[0];
}
return model;
}
public List<SD_Finance> GetFinanceListByContract(SD_CDetail sd)
{
string where = string.Format(" AND SDF_ContractCode='{0}' AND SDF_PartNo='{1}'",sd.CDetail_ContractNo,sd.CDetail_PartNo);
var list = sfInstance.GetListByWhere(where);
return list;
}
public bool Delete(SD_CDetail sc)
{
bool flag = false;
sc.Stat = 1;
if (instance.Update(sc) > 0)
{
flag = true;
}
return flag;
}
public bool AddOrUpdateSDRelation(SD_CDetail detail,List<SD_CRProdCode> list)
{
var oldlist=GetCDetailRelation(detail.CDetail_Code);
foreach (var d in oldlist)
{
var model=list.FirstOrDefault(o => o.SDR_Code == d.SDR_Code);
if (model != null)
{
model.SDR_ID = d.SDR_ID;
model.SDR_DetailCode = detail.CDetail_Code;
UpdateSDRelation(model);
list.Remove(model);
}
else
{
DeleteSDRelation(d);
}
}
foreach (var d in list)
{
d.SDR_Code = GenerateSDRelationCode();
d.SDR_ContractCode = detail.CDetail_ContractNo;
d.SDR_DetailCode = detail.CDetail_Code;
AddSDRelation(d);
}
return true;
}
