public string ExecSaleBillData(SALEBILLEntity Data)
{
SALEBILLEntity mer = DbHelper.Select(Data);
if (mer.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
EXEC_SALEBILL execsalebill = new EXEC_SALEBILL()
{
P_BILLID = Data.BILLID,
P_VERIFY = employee.Id
};
DbHelper.ExecuteProcedure(execsalebill);
Tran.Commit();
}
var dcl = new BILLSTATUSEntity
{
BILLID = Data.BILLID,
MENUID = "10500402",
BRABCHID = Data.BRANCHID,
URL = " SPGL/SALEBILL/SaleBillDetail/"
};
DelDclRw(dcl);
return(mer.BILLID);
}
public Tuple <dynamic, DataTable> GetSaleBillDetail(SALEBILLEntity Data)
{
string sql = $@" SELECT L.*,B.NAME BRANCHMC,S1.USERNAME SYYMC,S2.USERNAME YYYMC" +
" FROM SALEBILL L,BRANCH B,SYSUSER S1,SYSUSER S2 " +
" where L.BRANCHID = B.ID and L.CASHIERID = S1.USERID and L.CLERKID = S2.USERID ";
if (!Data.BILLID.IsEmpty())
{
sql += (" and L.BILLID= " + Data.BILLID);
}
DataTable dt = DbHelper.ExecuteTable(sql);
dt.NewEnumColumns <退铺单状态>("STATUS", "STATUSMC");
string sqlsale = $@"SELECT G.*,S.GOODSDM,S.NAME,P.NAME PAYNAME,O.CODE FROM SALEBILLITEM G,GOODS S,PAY P,SHOP O " +
" WHERE G.GOODSID=S.GOODSID and G.PAYID = P.PAYID and G.SHOPID= O.SHOPID";
if (!Data.BILLID.IsEmpty())
{
sqlsale += (" and G.BILLID= " + Data.BILLID);
}
DataTable dtsale = DbHelper.ExecuteTable(sqlsale);
return(new Tuple <dynamic, DataTable>(dt.ToOneLine(), dtsale));
}
public void DeleteSaleBill(List <SALEBILLEntity> DeleteData)
{
foreach (var con in DeleteData)
{
SALEBILLEntity Data = DbHelper.Select(con);
if (Data.STATUS != ((int)普通单据状态.未审核).ToString())
{
throw new LogicException($"租约({Data.BILLID})已经不是未审核不能删除!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var salebill in DeleteData)
{
var v = GetVerify(salebill);
//校验
var dcl = new BILLSTATUSEntity
{
BILLID = salebill.BILLID,
MENUID = "10500402",
BRABCHID = salebill.BRANCHID,
URL = " SPGL/SALEBILL/SaleBillDetail/"
};
DelDclRw(dcl);
DbHelper.Delete(salebill);
}
Tran.Commit();
}
}
public object ShowOneSaleBillEdit(SALEBILLEntity Data)
{
string sql = $@" SELECT L.*,B.NAME BRANCHMC,S1.USERNAME SYYMC,S2.USERNAME YYYMC" +
" FROM SALEBILL L,BRANCH B,SYSUSER S1,SYSUSER S2 " +
" where L.BRANCHID = B.ID and L.CASHIERID = S1.USERID and L.CLERKID = S2.USERID ";
if (!Data.BILLID.IsEmpty())
{
sql += (" and L.BILLID= " + Data.BILLID);
}
DataTable dt = DbHelper.ExecuteTable(sql);
string sqlsale = $@"SELECT G.*,S.GOODSDM,S.NAME,P.NAME PAYNAME,O.CODE FROM SALEBILLITEM G,GOODS S,PAY P,SHOP O " +
" WHERE G.GOODSID=S.GOODSID and G.PAYID = P.PAYID and G.SHOPID= O.SHOPID";
if (!Data.BILLID.IsEmpty())
{
sqlsale += (" and G.BILLID= " + Data.BILLID);
}
DataTable dtsale = DbHelper.ExecuteTable(sqlsale);
var result = new
{
saleBill = dt,
saleBillItem = new dynamic[] {
dtsale
}
};
return(result);
}
public string SaveSaleBill(SALEBILLEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.BILLID.IsEmpty())
{
SaveData.BILLID = NewINC("SALEBILL");
}
SaveData.STATUS = ((int)普通单据状态.未审核).ToString();
SaveData.REPORTER = employee.Id;
SaveData.REPORTER_NAME = employee.Name;
SaveData.REPORTER_TIME = DateTime.Now.ToString();
SaveData.VERIFY = employee.Id;
v.Require(a => a.BILLID);
v.Require(a => a.BRANCHID);
v.Require(a => a.ACCOUNT_DATE);
v.Require(a => a.CASHIERID);
v.Require(a => a.CLERKID);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.SALEBILLITEM?.ForEach(item =>
{
GetVerify(item).Require(a => a.GOODSID);
GetVerify(item).Require(a => a.PAYID);
GetVerify(item).Require(a => a.QUANTITY);
GetVerify(item).Require(a => a.AMOUNT);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
var dcl = new BILLSTATUSEntity
{
BILLID = SaveData.BILLID,
MENUID = "10500402",
BRABCHID = SaveData.BRANCHID,
URL = " SPGL/SALEBILL/SaleBillDetail/"
};
InsertDclRw(dcl);
return(SaveData.BILLID);
}
public void ExecData(SALEBILLEntity Data)
{
service.SpglService.ExecSaleBillData(Data);
}
public UIResult ShowOneSaleBillEdit(SALEBILLEntity Data)
{
return(new UIResult(service.SpglService.ShowOneSaleBillEdit(Data)));
}
public string Save(SALEBILLEntity SaveData)
{
return(service.SpglService.SaveSaleBill(SaveData));
}
