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