/// <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)); }