/// <summary>
/// 资产变更审核
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public string ExecAssetChange(ASSETCHANGEEntity Data)
{
ASSETCHANGEEntity assetchange = DbHelper.Select(Data);
if (assetchange.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
//using (var Tran = DbHelper.BeginTransaction())
//{
// assetchange.VERIFY = employee.Id;
// assetchange.VERIFY_NAME = employee.Name;
// assetchange.VERIFY_TIME = DateTime.Now.ToString();
// assetchange.STATUS = ((int)普通单据状态.审核).ToString();
// DbHelper.Save(assetchange);
// Tran.Commit();
//}
using (var Tran = DbHelper.BeginTransaction())
{
EXEC_ASSET_CHANGE exec_asset_change = new EXEC_ASSET_CHANGE()
{
V_BILLID = Data.BILLID,
V_USERID = employee.Id
};
DbHelper.ExecuteProcedure(exec_asset_change);
Tran.Commit();
}
return(assetchange.BILLID);
}
public Tuple <dynamic, DataTable, DataTable> GetAssetChangeElement(ASSETCHANGEEntity Data)
{
//此处校验一次只能查询一个单号,校验单号必须存在
string sql = $@"SELECT A.*,B.NAME BRANCHNAME FROM ASSETCHANGE A,BRANCH B WHERE A.BRANCHID=B.ID ";
if (!Data.BILLID.IsEmpty())
{
sql += (" AND BILLID= " + Data.BILLID);
}
DataTable assetchange = DbHelper.ExecuteTable(sql);
assetchange.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC");
string sqlitem = $@"SELECT M.*,P.CODE " +
" FROM ASSETCHANGEITEM M，SHOP P " +
" where M.ASSETID=P.SHOPID ";
if (!Data.BILLID.IsEmpty())
{
sqlitem += (" and M.BILLID= " + Data.BILLID);
}
DataTable assetchangeitem = DbHelper.ExecuteTable(sqlitem);
string sqlitem2 = $@"SELECT M.*,P.CODE " +
" FROM ASSETCHANGEITEM2 M，SHOP P " +
" where M.ASSETID=P.SHOPID ";
if (!Data.BILLID.IsEmpty())
{
sqlitem2 += (" and M.BILLID= " + Data.BILLID);
}
DataTable assetchangeitem2 = DbHelper.ExecuteTable(sqlitem2);
return(new Tuple <dynamic, DataTable, DataTable>(assetchange.ToOneLine(), assetchangeitem, assetchangeitem2));
}
public string SaveAssetChange(ASSETCHANGEEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.BILLID.IsEmpty())
{
SaveData.BILLID = NewINC("ASSETCHANGE");
}
SaveData.STATUS = ((int)普通单据状态.未审核).ToString();
SaveData.REPORTER = employee.Id;
SaveData.REPORTER_NAME = employee.Name;
SaveData.REPORTER_TIME = DateTime.Now.ToString();
v.Require(a => a.BILLID);
v.Require(a => a.CHANGE_TYPE);
v.Require(a => a.BRANCHID);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.ASSETCHANGEITEM2?.ForEach(newasset =>
{
GetVerify(newasset).Require(a => a.ASSETID);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
return(SaveData.BILLID);
}
public UIResult SearchAssetChange(ASSETCHANGEEntity Data)
{
var res = service.DpglService.GetAssetChangeElement(Data);
return(new UIResult(
new
{
assetchange = res.Item1,
assetchangeitem = res.Item2
}
));
}
public void DeleteAssetChange(List <ASSETCHANGEEntity> DeleteData)
{
foreach (var item in DeleteData)
{
ASSETCHANGEEntity Data = DbHelper.Select(item);
if (Data.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("已经审核不能删除!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var item in DeleteData)
{
DbHelper.Delete(item);
}
Tran.Commit();
}
}
/// <summary>
/// 资产拆分审核
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public string ExecAssetSpilt(ASSETCHANGEEntity Data)
{
ASSETCHANGEEntity assetchange = DbHelper.Select(Data);
if (assetchange.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
EXEC_ASSET_SPILT exec_asset_spilt = new EXEC_ASSET_SPILT()
{
V_BILLID = Data.BILLID,
V_USERID = employee.Id
};
DbHelper.ExecuteProcedure(exec_asset_spilt);
Tran.Commit();
}
return(assetchange.BILLID);
}
public void ExecData(ASSETCHANGEEntity Data)
{
service.DpglService.ExecAssetSpilt(Data);
}
public string Save(ASSETCHANGEEntity SaveData)
{
return(service.DpglService.SaveAssetChange(SaveData));
}
