public Tuple <dynamic, DataTable> GetFreeShopDetail(FREESHOPEntity Data)
{
string sql = $@" SELECT L.*,M.MERCHANTID,M.NAME SHMC,B.NAME BRANCHNAME " +
" FROM FREESHOP L,CONTRACT C,MERCHANT M,BRANCH B ";
sql += " where L.CONTRACTID=C.CONTRACTID and C.MERCHANTID=M.MERCHANTID and C.BRANCHID=B.ID ";
if (!Data.BILLID.IsEmpty())
{
sql += (" and L.BILLID= " + Data.BILLID);
}
DataTable dt = DbHelper.ExecuteTable(sql);
dt.NewEnumColumns <退铺单状态>("STATUS", "STATUSMC");
string sqlshop = $@"SELECT G.*,S.CODE,Y.CATEGORYCODE,Y.CATEGORYNAME " +
" FROM FREESHOPITEM G,SHOP S,CATEGORY Y " +
" WHERE G.SHOPID=S.SHOPID AND S.CATEGORYID= Y.CATEGORYID";
if (!Data.BILLID.IsEmpty())
{
sqlshop += (" and G.BILLID= " + Data.BILLID);
}
DataTable dtshop = DbHelper.ExecuteTable(sqlshop);
return(new Tuple <dynamic, DataTable>(dt.ToOneLine(), dtshop));
}
public string SaveFreeShop(FREESHOPEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.BILLID.IsEmpty())
{
SaveData.BILLID = NewINC("FREESHOP");
}
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.CONTRACTID);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.FREESHOPITEM?.ForEach(item =>
{
GetVerify(item).Require(a => a.SHOPID);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
return(SaveData.BILLID);
}
public object ShowOneFreeShopEdit(FREESHOPEntity Data)
{
string sql = $@" SELECT L.*,M.MERCHANTID,M.NAME SHMC FROM FREESHOP L,CONTRACT C,MERCHANT M";
sql += " where L.CONTRACTID=C.CONTRACTID and C.MERCHANTID=M.MERCHANTID ";
if (!Data.BILLID.IsEmpty())
{
sql += (" and L.BILLID= " + Data.BILLID);
}
DataTable dt = DbHelper.ExecuteTable(sql);
string sqlshop = $@"SELECT G.*,S.CODE,Y.CATEGORYCODE,Y.CATEGORYNAME " +
" FROM FREESHOPITEM G,SHOP S,CATEGORY Y " +
" WHERE G.SHOPID=S.SHOPID AND S.CATEGORYID= Y.CATEGORYID";
if (!Data.BILLID.IsEmpty())
{
sqlshop += (" and G.BILLID= " + Data.BILLID);
}
DataTable dtshop = DbHelper.ExecuteTable(sqlshop);
var result = new
{
freeShop = dt,
freeShopItem = new dynamic[] {
dtshop
}
};
return(result);
}
public string ExecFreeShop(FREESHOPEntity Data)
{
FREESHOPEntity freeShop = DbHelper.Select(Data);
if (freeShop.STATUS == ((int)退铺单状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
freeShop.VERIFY = employee.Id;
freeShop.VERIFY_NAME = employee.Name;
freeShop.VERIFY_TIME = DateTime.Now.ToString();
freeShop.STATUS = ((int)退铺单状态.审核).ToString();
DbHelper.Save(freeShop);
Tran.Commit();
}
return(freeShop.BILLID);
}
public void DeleteFreeShop(List <FREESHOPEntity> DeleteData)
{
foreach (var item in DeleteData)
{
FREESHOPEntity 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();
}
}
public string StopFreeShop(FREESHOPEntity Data)
{
FREESHOPEntity freeShop = DbHelper.Select(Data);
if (Convert.ToDateTime(freeShop.FREEDATE) > Convert.ToDateTime(DateTime.Now.ToShortString()))
{
throw new LogicException("退铺日期大于当前日期不能终止合同!");
}
if (freeShop.STATUS == ((int)退铺单状态.终止).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经终止不能再次终止!");
}
using (var Tran = DbHelper.BeginTransaction())
{
STOPFREESHOP stopFreeShop = new STOPFREESHOP()
{
P_BILLID = Data.BILLID,
P_TERMINATE = employee.Id
};
DbHelper.ExecuteProcedure(stopFreeShop);
Tran.Commit();
}
return(freeShop.BILLID);
}
public void StopData(FREESHOPEntity Data)
{
service.HtglService.StopFreeShop(Data);
}
public void ExecData(FREESHOPEntity Data)
{
service.HtglService.ExecFreeShop(Data);
}
public UIResult ShowOneEdit(FREESHOPEntity Data)
{
return(new UIResult(service.HtglService.ShowOneFreeShopEdit(Data)));
}
public string Save(FREESHOPEntity SaveData)
{
return(service.HtglService.SaveFreeShop(SaveData));
}
