//private void ExportDocument(eExportType expType)
//{
// try
// {
// GridExportController gridController = new GridExportController(this.grdQryDetail.Views[0]);
// switch (expType)
// {
// case eExportType.html:
// gridController.ExportToHTML(this.FileName_Detail + ".html", "HTML Document", "HTML Files|*.html");
// break;
// case eExportType.pdf:
// gridController.ExportToPDF(this.FileName_Detail + ".pdf", "PDF Document", "PDF Files|*.pdf");
// break;
// case eExportType.rtf:
// gridController.ExportToRTF(this.FileName_Detail + ".rtf", "RTF Document", "RTF Files|*.rtf");
// break;
// case eExportType.txt:
// gridController.ExportToTEXT(this.FileName_Detail + ".txt", "Text Document", "Text Files|*.txt");
// break;
// case eExportType.xls:
// gridController.ExportToXLS(this.FileName_Detail + ".xls", "Microsoft Excel Document", "Microsoft Excel|*.xls");
// break;
// case eExportType.xlsx:
// gridController.ExportToXLSX(this.FileName_Detail + ".xlsx", "Microsoft Excel 2007 Document", "Microsoft Excel|*.xlsx");
// break;
// default:
// break;
// }
// }
// catch (Exception ex)
// {
// XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
// }
//}
private void Query_StockInSummary_Detail()
{
//TimeSpan executionTime = new TimeSpan();
try
{
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
DataTable dtbStkOutDtl = null;
using (QueryBLL queryBll = new QueryBLL())
{
dtbStkOutDtl = queryBll.StockInSummaryDetail_Mtl(this._WH_ID, this._ARR_TYPE, this._PARTY_NAME, this._PRODUCT_NO, this._IN_DATE);
//executionTime = queryBll.ExecutionTime;
}
this.grdQryDetail.DataSource = dtbStkOutDtl;
this.dntProdTracDtl.DataSource = dtbStkOutDtl;
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQryDetail.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
base.FinishedProcessing();
//((frmMainMenu)this.ParentForm).ExecuteTime.Caption = "Execute Time: " + UiUtility.TimeSpanInWords(executionTime);
}
}
private void Interface_DeliveryBoardDetail(DateTime lastupdate)
{
List <DeliveryBoardDetail> lstDeliveryDetail;
try
{
//eventLog1.WriteEntry("Get Stock By Delivery Board Detail", EventLogEntryType.Information);
//get data from oracle database
using (QueryBLL oraQuery = new QueryBLL())
{
lstDeliveryDetail = oraQuery.GetDeliveryBoardDetail();
}
// Insert data to SQLite database
if (lstDeliveryDetail != null)
{
//eventLog1.WriteEntry("SQLite Stock By Delivery Board Detail", EventLogEntryType.Information);
using (InterfaceBLL infBll = new InterfaceBLL())
{
infBll.InsertDeliveryBoardDetail(lstDeliveryDetail, lastupdate);
infBll.DeleteDeliveryBoardDetail();
infBll.UpdateDeliveryBoardDetail();
}
}
}
catch (Exception ex)
{
eventLog1.WriteEntry(ex.Message, EventLogEntryType.Error);
}
}
public object QueryWorkstation(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.* from Data_Workstation a where a.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_WorkstationService data_WorkstationService = BLLContainer.Resolve <IData_WorkstationService>();
var data_Workstation = data_WorkstationService.SqlQuery(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Workstation));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
//private void ExportDocument(eExportType expType)
//{
// try
// {
// GridExportController gridController = new GridExportController(this.grdQryDetail.Views[0]);
// switch (expType)
// {
// case eExportType.html:
// gridController.ExportToHTML(this.FileName_Detail + ".html", "HTML Document", "HTML Files|*.html");
// break;
// case eExportType.pdf:
// gridController.ExportToPDF(this.FileName_Detail + ".pdf", "PDF Document", "PDF Files|*.pdf");
// break;
// case eExportType.rtf:
// gridController.ExportToRTF(this.FileName_Detail + ".rtf", "RTF Document", "RTF Files|*.rtf");
// break;
// case eExportType.txt:
// gridController.ExportToTEXT(this.FileName_Detail + ".txt", "Text Document", "Text Files|*.txt");
// break;
// case eExportType.xls:
// gridController.ExportToXLS(this.FileName_Detail + ".xls", "Microsoft Excel Document", "Microsoft Excel|*.xls");
// break;
// case eExportType.xlsx:
// gridController.ExportToXLSX(this.FileName_Detail + ".xlsx", "Microsoft Excel 2007 Document", "Microsoft Excel|*.xlsx");
// break;
// default:
// break;
// }
// }
// catch (Exception ex)
// {
// XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
// }
//}
private void Query_ProductionTrack_Detail()
{
//TimeSpan executionTime = new TimeSpan();
try
{
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
DataTable dtbStkAsOnDtl = null;
using (QueryBLL queryBll = new QueryBLL())
{
dtbStkAsOnDtl = queryBll.JobTrackingDetail(this._JOB_NO, this._JOB_LOT);
//executionTime = queryBll.ExecutionTime;
}
this.grdQryDetail.DataSource = dtbStkAsOnDtl;
this.dntProdTracDtl.DataSource = dtbStkAsOnDtl;
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQryDetail.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
base.FinishedProcessing();
//((frmMainMenu)this.ParentForm).ExecuteTime.Caption = "Execute Time: " + UiUtility.TimeSpanInWords(executionTime);
}
}
public object QueryJackpotInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[1];
string sqlWhere = string.Empty;
parameters[0] = new SqlParameter("@MerchId", merchId);
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.* from Data_JackpotInfo a where a.MerchInfo=@MerchId";
sql = sql + sqlWhere;
IData_JackpotInfoService data_JackpotInfoService = BLLContainer.Resolve <IData_JackpotInfoService>();
var data_JackpotInfo = data_JackpotInfoService.SqlQuery <Data_JackpotInfo>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_JackpotInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
private void InitializaLOVData()
{
try
{
//for warehouse
using (QueryBLL queryBll = new QueryBLL())
{
List <Warehouse> lstWH = queryBll.GetWarehouse();
if (lstWH != null)
{
lstWH.Insert(0, new Warehouse {
SEQ_NO = string.Empty, NAME = "(All)"
});
this.lueWarehouse.Properties.DataSource = lstWH;
this.rps_lueWH.DataSource = lstWH;
}
}
//for party
using (PartyBLL partyBll = new PartyBLL())
{
List <Party> lstParty = partyBll.LovPratyList("C", string.Empty);
lstParty.Insert(0, new Party {
PARTY_ID = string.Empty, PARTY_NAME = "(All)"
});
this.lueCUSTOMER.Properties.DataSource = lstParty;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void Interface_StockByMinMax(DateTime lastupdate)
{
List <StockByMinMax> lstStkMinMax;
try
{
//eventLog1.WriteEntry("Get Stock By Min Max", EventLogEntryType.Information);
//get data from oracle database
using (QueryBLL oraQuery = new QueryBLL())
{
lstStkMinMax = oraQuery.GetStockByMinMax();
}
// Insert data to SQLite database
if (lstStkMinMax != null)
{
//eventLog1.WriteEntry("SQLite Stock By MinMax", EventLogEntryType.Information);
using (InterfaceBLL infBll = new InterfaceBLL())
{
infBll.InsertStockByMinMax(lstStkMinMax, lastupdate);
infBll.DeleteStockByMinMax();
infBll.UpdateStockByMinMax();
}
}
}
catch (Exception ex)
{
eventLog1.WriteEntry(ex.Message, EventLogEntryType.Error);
}
}
//for Sales Order from SAGE50
public void Doc_GetSalesOrderList()
{
DataTable dt;
try
{
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
using (QueryBLL queryBll = new QueryBLL())
{
dt = queryBll.Doc_SalesOrder_List();
}
this.grdDocument.DataSource = dt;
}
catch (Exception ex)
{
base.FinishedProcessing();
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
base.FinishedProcessing();
}
}
/// <summary> Execute query operation
/// </summary>
/// <param name="scope"></param>
/// <returns></returns>
protected override bool Execute(ActionScope scope)
{
try
{
int queryTypeID = this.QueryAction.QueryTypeID;
//get meta-descriptions for query type
QueryTypeInstance queryType = new QueryTypeBLL().GetQueryTypeByID(queryTypeID);
//get query type in values
Dictionary <int, string> queryTypeInID_value = this.GetQueryInParameters(scope, queryType);
//get query type part values
Dictionary <int, bool> queryTypePartID_value = this.GetQueryParts(scope, queryType);
//construct query from metadata and parameters' values
var sql = queryType.ConstructSql(queryTypeInID_value, queryTypePartID_value);
//execute query
DataTable resultData = new QueryBLL().ExecuteSql(sql.Item1, sql.Item2);
//update operator_id-values
this.SetOperatorValues(scope, resultData);
//query executed - mark it as executed
scope.ExecutedActionIDS.Add(this.EventAction.ActionID);
}
catch (FormGenerationException ex)
{
throw;
}
catch (Exception ex)
{
throw new Exception("Couldn't execute query to user's data source.", ex);
}
return(true);
}
public object QueryPushRule(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select b.GameID, b.GameName, a.ID, a.MemberLevelName, a.Week, a.Allow_Out, a.Allow_In, a.Coin, a.Level, a.StartTime as ST, a.EndTime as ET from Data_Push_Rule a " +
" inner join Data_GameInfo b on a.GameIndexID=b.ID " +
" where b.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>();
var data_Push_Rule = data_Push_RuleService.SqlQuery <Data_Push_RuleList>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Push_Rule));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object QueryFreeRule(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select c.ID, b.GameID, b.GameName, d.MemberLevelName as MemberLevelName, (case c.RuleType when 0 then '模拟机' when 1 then '博彩机' else '' end) as RuleTypeStr, " +
" c.NeedCoin, c.FreeCoin, c.ExitCoin, c.StartTime as ST, c.EndTime as ET, c.State from Data_GameFreeRule_List a " +
" inner join Data_GameInfo b on a.GameIndexID=b.ID " +
" inner join Data_GameFreeRule c on a.RuleID=c.ID " +
" left join Data_MemberLevel d on c.MemberLevelID=d.MemberLevelID" +
" where b.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_GameFreeRuleService data_GameFreeRuleService = BLLContainer.Resolve <IData_GameFreeRuleService>();
var data_GameFreeRule = data_GameFreeRuleService.SqlQuery <Data_GameFreeRuleList>(sql, parameters).ToList();
var linq = from a in data_GameFreeRule
group a by new { ID = a.ID } into g
select new {
g.Key.ID,
GameID = string.Join("|", g.Select(p => p.GameID)),
GameName = string.Join("|", g.Select(p => p.GameName)),
MemberLevelName = g.Max(p => p.MemberLevelName),
RuleTypeStr = g.Max(p => p.RuleTypeStr),
NeedCoin = g.Max(p => p.NeedCoin),
FreeCoin = g.Max(p => p.FreeCoin),
ExitCoin = g.Max(p => p.ExitCoin),
StartTime = g.Max(p => p.StartTime),
EndTime = g.Max(p => p.EndTime),
State = g.Max(p => p.State)
};
return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, linq));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object GetMerchList(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
//代理商仅能查所属商户，普通商户或大客户只能查自己，莘宸管理员可以查所有商户
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (userTokenKeyModel.LogType == (int)RoleType.MerchUser)
{
var merchIdDataModel = userTokenKeyModel.DataModel as MerchDataModel;
Array.Resize(ref parameters, parameters.Length + 1);
if (merchIdDataModel.MerchType == (int)MerchType.Agent)
{
parameters[parameters.Length - 1] = new SqlParameter("@logId", userTokenKeyModel.LogId);
sqlWhere = sqlWhere + " and a.CreateUserID=@logId";
}
else
{
parameters[parameters.Length - 1] = new SqlParameter("@merchId", merchIdDataModel.MerchID);
sqlWhere = sqlWhere + " and a.MerchID=@merchId";
}
}
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.MerchID, a.MerchName, a.Mobil, b.DictKey as MerchTypeStr, a.MerchAccount, d.DictKey as AllowCreateSubStr, a.AllowCreateCount, c.DictKey as MerchStatusStr from Base_MerchantInfo a " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户类别' and a.PID=0) b on convert(varchar, a.MerchType)=b.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户状态' and a.PID=0) c on convert(varchar, a.MerchStatus)=c.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='创建子账号' and a.PID=0) d on convert(varchar, a.AllowCreateSub)=d.DictValue " +
" where 1=1 ";
sql = sql + sqlWhere;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_MerchantInfo).Namespace);
var base_MerchantInfo = dbContext.Database.SqlQuery <Base_MerchantInfoListModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_MerchantInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object init(Dictionary <string, object> dicParas)
{
string pageName = string.Empty;
string processName = string.Empty;
int userId = 0;
if (dicParas.ContainsKey("pagename"))
{
pageName = dicParas["pagename"].ToString();
}
if (dicParas.ContainsKey("processname"))
{
processName = dicParas["processname"].ToString();
}
if (dicParas.ContainsKey("userid"))
{
int.TryParse(dicParas["userid"].ToString(), out userId);
}
string errMsg = string.Empty;
if (string.IsNullOrEmpty(pageName))
{
errMsg = "页面名参数不存在";
}
else if (string.IsNullOrEmpty(processName))
{
errMsg = "功能名参数不存在";
}
if (!string.IsNullOrEmpty(errMsg))
{
ResponseModel <List <InitModel> > responseModel = new ResponseModel <List <InitModel> >();
responseModel.Result_Code = Result_Code.F;
responseModel.Result_Msg = errMsg;
return(responseModel);
}
else
{
List <InitModel> listInitModel = null;
List <Dict_SystemModel> listDict_SystemModel = null;
QueryBLL.GetInit(pageName, processName, userId, ref listInitModel, ref listDict_SystemModel);
ResponseModel <List <InitModel> > responseModel = new ResponseModel <List <InitModel> >();
responseModel.Result_Data = listInitModel;
return(responseModel);
}
}
public object GetOrders(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@merchId", merchId);
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "b.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select b.ID, a.StoreID, a.StoreName, b.OrderID, b.FoodCount, b.OrderSource, b.CreateTime, b.PayType, b.OrderStatus," +
" c.DictKey as OrderSourceStr, d.DictKey as PayTypeStr, e.DictKey as OrderStatusStr, f.FoodName from Base_StoreInfo a " +
" inner join Flw_Order b on a.StoreID=b.StoreID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='订单来源' and a.PID=0) c on convert(varchar, b.OrderSource)=c.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='支付通道' and a.PID=0) d on convert(varchar, b.PayType)=d.DictValue " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='订单状态' and a.PID=0) e on convert(varchar, b.OrderStatus)=e.DictValue " +
" left join (select top 1 a.ID as OrderFlwID, d.FoodName from Flw_Order a inner join Flw_Order_Detail b on a.ID=b.OrderFlwID " +
" inner join Flw_Food_Sale c on b.FoodFlwID=c.ID " +
" inner join Data_FoodInfo d on c.FoodID=d.FoodID) f on b.ID=f.OrderFlwID " +
" where a.MerchID=@merchId ";
sql = sql + sqlWhere;
var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Flw_Order).Namespace);
var flw_Orders = dbContext.Database.SqlQuery <Flw_OrdersModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, flw_Orders));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
private void Query_ProductionTrack(string jobNo, string partyid, DateTime?fromDate, DateTime?todate,
string prodType, string mcno, string product)
{
try
{
base.ExecutionStart();
//UiUtility.BeginProcessing("Please wait", this);
base.BeginProcessing("Begin Load data...", "Please wait for Loading data");
using (QueryBLL queryBll = new QueryBLL())
{
this.dtbProductionTrans = queryBll.JobTrackingList(jobNo, partyid, fromDate, todate, prodType, mcno, product);
}
if (dtbProductionTrans != null)
{
dtbProductionTrans.DefaultView.Sort = "JOB_NO,JOB_LOT";
this.ConditionsColumnView(this.grdQrySummary);
//this.ConditionsAdjustment(this.grdQrySummary);
}
this.grdQrySummary.DataSource = this.dtbProductionTrans;
this.dntQryStkAsOn.DataSource = this.dtbProductionTrans;
base.ExecutionStop();
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQrySummary.DataSource = null;
this.dntQryStkAsOn.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
base.FinishedProcessing();
((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime;
}
}
public object QueryCouponInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string merchId = userTokenKeyModel.DataModel.MerchID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[1];
string sqlWhere = string.Empty;
parameters[0] = new SqlParameter("@MerchId", merchId);
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.ID, a.CouponName, b.DictKey as CouponTypeStr, a.PublishCount, (a.PublishCount - isnull(c.UseCount, 0) - isnull(d.UseCount, 0)) as LeftCount, " +
" (case when a.StartTime is null or a.StartTime='' then '' else convert(varchar,a.StartTime,23) end) as StartTime, (case when a.EndTime is null or a.EndTime='' then '' else convert(varchar,a.EndTime,23) end) as EndTime, " +
" a.Context from Data_CouponInfo a" +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='优惠券类别' and a.PID=0) b on convert(varchar, a.CouponType)=b.DictValue " +
" left join (select a.ID as CouponID, count(c.ID) as UseCount from Data_CouponInfo a inner join Data_CouponList b on a.ID=b.CouponID inner join Flw_CouponUse c on b.ID=c.CouponCode) c on a.ID=c.CouponID " +
" left join (select a.ID as CouponID, count(b.ID) as UseCount from Data_CouponInfo a inner join Flw_CouponUse b on a.ID=b.CouponID) d on a.ID=d.CouponID " +
" where a.MerchID=@MerchId";
sql = sql + sqlWhere;
IData_CouponInfoService data_CouponInfoService = BLLContainer.Resolve <IData_CouponInfoService>();
var data_CouponInfo = data_CouponInfoService.SqlQuery <Data_CouponInfoModel>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_CouponInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object QueryReloadGifts(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.ID, (case when a.RealTime is null or a.RealTime='' then '' else convert(varchar,a.RealTime,23) end) as RealTime, c.HeadName, d.DictKey as ReloadTypeName, b.LogName, a.ReloadCount, a.Note from Data_Reload a " +
" left join Base_UserInfo b on a.UserID=b.UserID " +
" left join Data_Head c on a.DeviceID=c.ID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='安装类别' and a.PID=0) d on convert(varchar, a.ReloadType)=d.DictValue " +
" where b.StoreID='" + storeId + "' and deviceType=2 and ReloadType=3 " +
" order by c.HeadName, a.RealTime desc";
sql = sql + sqlWhere;
IData_ReloadService data_ReloadService = BLLContainer.Resolve <IData_ReloadService>();
var data_Reload = data_ReloadService.SqlQuery <Data_ReloadModelList>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Reload));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object QueryGoodInventory(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.ID, c.DictKey as InventoryTypeStr, (case when a.InventoryType=1 then d.WorkStation when a.InventoryType=3 then e.HeadName else '' end) as InventoryIndexName, a.InventoryTime, a.UserID, b.RealName, a.InventoryCount, a.Note from Data_GoodInventory a " +
" left join Base_UserInfo b on a.UserID=b.UserID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='盘点类别' and a.PID=0) c on convert(varchar, a.InventoryType)=c.DictValue " +
" left join Data_Workstation d on a.InventoryType=1 and a.InventoryIndex=d.ID " +
" left join Data_Head e on a.InventoryType=3 and a.InventoryIndex=e.ID " +
" where a.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_GoodInventoryService data_GoodInventoryService = BLLContainer.Resolve <IData_GoodInventoryService>();
var data_GoodInventory = data_GoodInventoryService.SqlQuery <Data_GoodInventoryList>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_GoodInventory));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
private void Query_Stock_Out_Summary(string whid, string partyid, string product, DateTime?fromDate, DateTime?toDate, string shift)
{
try
{
base.ExecutionStart();
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
using (QueryBLL queryBll = new QueryBLL())
{
this.dtbStockOutSummary = queryBll.StockOutSummary(whid, partyid, product, fromDate, toDate, shift);
}
if (this.dtbStockOutSummary != null)
{
this.ConditionsColumnView(this.grdQrySummary);
}
this.grdQrySummary.DataSource = this.dtbStockOutSummary;
this.dntQryStkAsOn.DataSource = this.dtbStockOutSummary;
base.ExecutionStop();
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQrySummary.DataSource = null;
this.dntQryStkAsOn.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime;
base.FinishedProcessing();
}
}
private void Query_Material_Mixed_Daily(string mcno, DateTime?fromDate, DateTime?toDate)
{
try
{
base.ExecutionStart();
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
using (QueryBLL queryBll = new QueryBLL())
{
this.dtbMixedDailyRec = queryBll.MaterialMixedDaily(mcno, fromDate, toDate);
}
if (this.dtbMixedDailyRec != null)
{
this.ConditionsColumnView(this.grdQrySummary);
}
this.grdQrySummary.DataSource = this.dtbMixedDailyRec;
this.dntQryStkAsOn.DataSource = this.dtbMixedDailyRec;
base.ExecutionStop();
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQrySummary.DataSource = null;
this.dntQryStkAsOn.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime;
base.FinishedProcessing();
}
}
public object QueryGoodsInfo(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select a.ID, a.GoodName, a.Price, a.Points, a.Note, c.DictKey as GoodTypeStr from Base_GoodsInfo a " +
" left join Base_StoreInfo b on a.MerchID=b.MerchID " +
" left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商品类别' and a.PID=0) c on convert(varchar, a.GoodType)=c.DictValue " +
" where a.Status=1 and b.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IBase_GoodsInfoService base_GoodsInfoService = BLLContainer.Resolve <IBase_GoodsInfoService>();
var base_GoodsInfo = base_GoodsInfoService.SqlQuery <Base_GoodsInfoList>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_GoodsInfo));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
private void Query_StockAsOn_Date(string location, string partyid, string material)
{
try
{
base.ExecutionStart();
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
using (QueryBLL queryBll = new QueryBLL())
{
this.dtbStockAsOn = queryBll.StockAsOnDate_Mtl(location, partyid, material);
}
/*
* string expressionPCS = string.Empty;
* string expressionBOX = string.Empty;
*
* switch (this.GetDefaultViewType(this.grdQrySummary))
* {
* case eViewType.GridView:
* GridView gView = (GridView)this.grdQrySummary.MainView;
* foreach (GridColumn column in gView.VisibleColumns)
* {
* switch (column.FieldName)
* {
* case "ALLOC_QTY":
* expressionPCS += "ALLOC_QTY+";
* break;
* case "FREE_QTY":
* expressionPCS += "FREE_QTY+";
* break;
* case "ALLOC_BOX":
* expressionBOX += "ALLOC_BOX+";
* break;
* case "FREE_BOX":
* expressionBOX += "FREE_BOX+";
* break;
*
* default:
* break;
* }
* }
* break;
* case eViewType.CardView:
* // CardView cView = (CardView)this.grdQrySummary.MainView;
*
* break;
* case eViewType.BandedView:
* BandedGridView bView = (BandedGridView)this.grdQrySummary.MainView;
* foreach (GridColumn column in bView.VisibleColumns)
* {
* switch (column.FieldName)
* {
* case "ALLOC_QTY":
* expressionPCS += "ALLOC_QTY+";
* break;
* case "FREE_QTY":
* expressionPCS += "FREE_QTY+";
* break;
* case "ALLOC_BOX":
* expressionBOX += "ALLOC_BOX+";
* break;
* case "FREE_BOX":
* expressionBOX += "FREE_BOX+";
* break;
* default:
* break;
* }
* }
* break;
* case eViewType.AdvanceView:
* //AdvBandedGridView aView = (AdvBandedGridView)this.grdQryMainMTL.MainView;
* break;
* default:
* break;
* }
*
* if (!string.IsNullOrEmpty(expressionPCS))
* {
* expressionPCS = expressionPCS.Substring(0, expressionPCS.LastIndexOf("+"));
*
* if (this.dtbStockAsOn.Columns.IndexOf("TOTAL_QTY") == -1)
* {
* this.dtbStockAsOn.Columns.Add("TOTAL_QTY", typeof(int), expressionPCS);
* }
* else
* {
* this.dtbStockAsOn.Columns["TOTAL_QTY"].Expression = expressionPCS;
* }
* }
*
* if (!string.IsNullOrEmpty(expressionBOX))
* {
* expressionBOX = expressionBOX.Substring(0, expressionBOX.LastIndexOf("+"));
*
* if (this.dtbStockAsOn.Columns.IndexOf("TOTAL_BOX") == -1)
* {
* this.dtbStockAsOn.Columns.Add("TOTAL_BOX", typeof(int), expressionBOX);
* }
* else
* {
* this.dtbStockAsOn.Columns["TOTAL_BOX"].Expression = expressionBOX;
* }
* }
* */
if (dtbStockAsOn != null)
{
dtbStockAsOn.DefaultView.Sort = "MTL_CODE";
}
this.grdQrySummary.DataSource = this.dtbStockAsOn;
this.dntQryStkAsOn.DataSource = this.dtbStockAsOn;
base.ExecutionStop();
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQrySummary.DataSource = null;
this.dntQryStkAsOn.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime;
base.FinishedProcessing();
}
}
//private void Query_StockAsOn(string whid, string partyid, string product)
//{
// try
// {
// base.ExecutionStart();
// base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
// using (QueryBLL queryBll = new QueryBLL())
// {
// this.dtbStockAsOn = queryBll.StockAsOn(whid, partyid, product);
// }
// string expression = string.Empty;
// switch (this.GetDefaultViewType(this.grdQrySummary))
// {
// case eViewType.GridView:
// GridView gView = (GridView)this.grdQrySummary.MainView;
// foreach (GridColumn column in gView.VisibleColumns)
// {
// switch (column.FieldName)
// {
// case "ALLOC_STK":
// expression += "ALLOC_STK+";
// break;
// case "HOLD_QTY":
// expression += "HOLD_QTY+";
// break;
// case "FREE_STK":
// expression += "FREE_STK+";
// break;
// default:
// break;
// }
// }
// break;
// case eViewType.CardView:
// // CardView cView = (CardView)this.grdQrySummary.MainView;
// break;
// case eViewType.BandedView:
// BandedGridView bView = (BandedGridView)this.grdQrySummary.MainView;
// foreach (GridColumn column in bView.VisibleColumns)
// {
// switch (column.FieldName)
// {
// case "ALLOC_STK":
// expression += "ALLOC_STK+";
// break;
// case "HOLD_QTY":
// expression += "HOLD_QTY+";
// break;
// case "FREE_STK":
// expression += "FREE_STK+";
// break;
// default:
// break;
// }
// }
// break;
// case eViewType.AdvanceView:
// //AdvBandedGridView aView = (AdvBandedGridView)this.grdQryMainMTL.MainView;
// break;
// default:
// break;
// }
// if (!string.IsNullOrEmpty(expression))
// {
// expression = expression.Substring(0, expression.LastIndexOf("+"));
// if (this.dtbStockAsOn.Columns.IndexOf("TOTAL_QTY") == -1)
// {
// this.dtbStockAsOn.Columns.Add("TOTAL_QTY", typeof(int), expression);
// }
// else
// {
// this.dtbStockAsOn.Columns["TOTAL_QTY"].Expression = expression;
// }
// }
// if (dtbStockAsOn != null)
// {
// dtbStockAsOn.DefaultView.Sort = "WH_NAME,PRODUCT_NO";
// }
// this.grdQrySummary.DataSource = this.dtbStockAsOn;
// this.dntQryStkAsOn.DataSource = this.dtbStockAsOn;
// base.ExecutionStop();
// }
// catch (Exception ex)
// {
// base.FinishedProcessing();
// this.grdQrySummary.DataSource = null;
// this.dntQryStkAsOn.DataSource = null;
// XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
// }
// finally
// {
// ((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime;
// base.FinishedProcessing();
// }
//}
private void Query_StockAsOn(string whid, string partyid, string product)
{
try
{
base.ExecutionStart();
base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data");
using (QueryBLL queryBll = new QueryBLL())
{
this.dtbStockAsOn = queryBll.StockAsOn(whid, partyid, product);
}
string expressionPCS = string.Empty;
string expressionBOX = string.Empty;
switch (this.GetDefaultViewType(this.grdQrySummary))
{
case eViewType.GridView:
GridView gView = (GridView)this.grdQrySummary.MainView;
foreach (GridColumn column in gView.VisibleColumns)
{
switch (column.FieldName)
{
case "ALLOC_QTY":
expressionPCS += "ALLOC_QTY+";
break;
case "FREE_QTY":
expressionPCS += "FREE_QTY+";
break;
case "ALLOC_BOX":
expressionBOX += "ALLOC_BOX+";
break;
case "FREE_BOX":
expressionBOX += "FREE_BOX+";
break;
default:
break;
}
}
break;
case eViewType.CardView:
// CardView cView = (CardView)this.grdQrySummary.MainView;
break;
case eViewType.BandedView:
BandedGridView bView = (BandedGridView)this.grdQrySummary.MainView;
foreach (GridColumn column in bView.VisibleColumns)
{
switch (column.FieldName)
{
case "ALLOC_QTY":
expressionPCS += "ALLOC_QTY+";
break;
case "FREE_QTY":
expressionPCS += "FREE_QTY+";
break;
case "ALLOC_BOX":
expressionBOX += "ALLOC_BOX+";
break;
case "FREE_BOX":
expressionBOX += "FREE_BOX+";
break;
default:
break;
}
}
break;
case eViewType.AdvanceView:
//AdvBandedGridView aView = (AdvBandedGridView)this.grdQryMainMTL.MainView;
break;
default:
break;
}
if (!string.IsNullOrEmpty(expressionPCS))
{
expressionPCS = expressionPCS.Substring(0, expressionPCS.LastIndexOf("+"));
if (this.dtbStockAsOn.Columns.IndexOf("TOTAL_QTY") == -1)
{
this.dtbStockAsOn.Columns.Add("TOTAL_QTY", typeof(int), expressionPCS);
}
else
{
this.dtbStockAsOn.Columns["TOTAL_QTY"].Expression = expressionPCS;
}
}
if (!string.IsNullOrEmpty(expressionBOX))
{
expressionBOX = expressionBOX.Substring(0, expressionBOX.LastIndexOf("+"));
if (this.dtbStockAsOn.Columns.IndexOf("TOTAL_BOX") == -1)
{
this.dtbStockAsOn.Columns.Add("TOTAL_BOX", typeof(int), expressionBOX);
}
else
{
this.dtbStockAsOn.Columns["TOTAL_BOX"].Expression = expressionBOX;
}
}
if (dtbStockAsOn != null)
{
dtbStockAsOn.DefaultView.Sort = "WH_ID, PARTY_ID, PRODUCT_NO";
}
this.grdQrySummary.DataSource = this.dtbStockAsOn;
this.dntQryStkAsOn.DataSource = this.dtbStockAsOn;
base.ExecutionStop();
}
catch (Exception ex)
{
base.FinishedProcessing();
this.grdQrySummary.DataSource = null;
this.dntQryStkAsOn.DataSource = null;
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime;
base.FinishedProcessing();
}
}
