public string ExecRateAdjust(RATE_ADJUSTEntity Data)
{
RATE_ADJUSTEntity ra = DbHelper.Select(Data);
if (ra.STATUS != ((int)普通单据状态.未审核).ToString())
{
throw new LogicException("单据(" + Data.ID + ")不是未审核状态,不能执行审核操作!");
}
using (var Tran = DbHelper.BeginTransaction())
{
EXEC_RATE_ADJUST proExec = new EXEC_RATE_ADJUST()
{
in_ID = Data.ID,
in_USERID = employee.Id
};
DbHelper.ExecuteProcedure(proExec);
Tran.Commit();
}
//删除审核待办任务
var dcl = new BILLSTATUSEntity
{
BILLID = Data.ID,
MENUID = "10500702",
BRABCHID = Data.BRANCHID,
URL = " SPGL/RATE_ADJUST/Rate_AdjustEdit/" //暂无浏览界面
};
DelDclRw(dcl);
return(ra.ID);
}
public object ShowOneRateAdjustEdit(RATE_ADJUSTEntity Data)
{
string sql = @"SELECT A.*,B.NAME BRANCHNAME FROM RATE_ADJUST A,BRANCH B
WHERE A.BRANCHID=B.ID ";
if (!Data.ID.IsEmpty())
{
sql += (" and A.ID= " + Data.ID);
}
DataTable dt = DbHelper.ExecuteTable(sql);
string sqlitem = @"SELECT A.*,G.GOODSDM,G.NAME FROM RATE_ADJUST_ITEM A,GOODS G
WHERE A.GOODSID=G.GOODSID";
if (!Data.ID.IsEmpty())
{
sqlitem += (" and A.ID= " + Data.ID);
}
DataTable dtitem = DbHelper.ExecuteTable(sqlitem);
var result = new
{
RATE_ADJUST = dt,
RATE_ADJUST_ITEM = new dynamic[] {
dtitem
}
};
return(result);
}
public string SaveRateAdjust(RATE_ADJUSTEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.ID.IsEmpty())
{
SaveData.ID = NewINC("RATE_ADJUST");
}
SaveData.STATUS = ((int)普通单据状态.未审核).ToString();
SaveData.REPORTER = employee.Id;
SaveData.REPORTER_NAME = employee.Name;
SaveData.REPORTER_TIME = DateTime.Now.ToString();
v.Require(a => a.ID);
v.Require(a => a.BRANCHID);
v.Require(a => a.STARTTIME);
v.Require(a => a.ENDTIME);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.RATE_ADJUST_ITEM?.ForEach(item =>
{
item.SHEETID = "1";
GetVerify(item).Require(a => a.GOODSID);
GetVerify(item).Require(a => a.RATE_NEW);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
//增加审核待办任务
var dcl = new BILLSTATUSEntity
{
BILLID = SaveData.ID,
MENUID = "10500702",
BRABCHID = SaveData.BRANCHID,
URL = " SPGL/RATE_ADJUST/Rate_AdjustEdit/" //暂无浏览界面
};
InsertDclRw(dcl);
return(SaveData.ID);
}
public string StopRateAdjust(RATE_ADJUSTEntity Data)
{
RATE_ADJUSTEntity ra = DbHelper.Select(Data);
if (ra.STATUS != ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.ID + ")不是审核状态,不能执行终止操作!");
}
using (var Tran = DbHelper.BeginTransaction())
{
STOP_RATE_ADJUST proStop = new STOP_RATE_ADJUST()
{
in_ID = Data.ID,
in_USERID = employee.Id
};
DbHelper.ExecuteProcedure(proStop);
Tran.Commit();
}
return(ra.ID);
}
public void DeleteRateAdjust(List <RATE_ADJUSTEntity> DeleteData)
{
foreach (var con in DeleteData)
{
RATE_ADJUSTEntity Data = DbHelper.Select(con);
if (Data.STATUS != ((int)普通单据状态.未审核).ToString())
{
throw new LogicException($"单据({Data.ID})不是未审核状态,不能执行删除操作!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var AD in DeleteData)
{
var v = GetVerify(AD);
//校验
DbHelper.Delete(AD);
}
Tran.Commit();
}
//删除审核待办任务
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var AD in DeleteData)
{
var dcl = new BILLSTATUSEntity
{
BILLID = AD.ID,
MENUID = "10500702",
BRABCHID = AD.BRANCHID,
URL = " SPGL/RATE_ADJUST/Rate_AdjustEdit/" //暂无浏览界面
};
DelDclRw(dcl);
}
Tran.Commit();
}
}
public string StopData(RATE_ADJUSTEntity SaveData)
{
return(service.SpglService.StopRateAdjust(SaveData));
}
public string ExecData(RATE_ADJUSTEntity SaveData)
{
return(service.SpglService.ExecRateAdjust(SaveData));
}
public UIResult ShowOneRateAdjustEdit(RATE_ADJUSTEntity Data)
{
return(new UIResult(service.SpglService.ShowOneRateAdjustEdit(Data)));
}
