protected void btnQuery_Click(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQuery param = new ParamQuery();
param.m_time = m_time.Text;
param.m_param = m_gold.Text;
OpRes res = user.doQuery(param, QueryType.queryTypeAccountCoinLessValue);
if (res != OpRes.opres_success)
{
m_res.InnerText = OpResMgr.getInstance().getResultString(res);
return;
}
ResultAccountCoinLessValue rv =
(ResultAccountCoinLessValue)user.getQueryResult(QueryType.queryTypeAccountCoinLessValue);
Literal L = new Literal();
L.Text = string.Format("总共:{0}", rv.m_totalCount);
divResult.Controls.Add(L);
L = new Literal();
L.Text = "<br/>";
divResult.Controls.Add(L);
L = new Literal();
L.Text = string.Format("小于指定金币共:{0}", rv.m_condCount);
divResult.Controls.Add(L);
}
// GET api/mms/send/getdoperson
public List <dynamic> GetDoPerson(string q)
{
var SendService = new mms_inspectionwellService();
var pQuery = ParamQuery.Instance().Select("top 10 DoPerson").AndWhere("DoPerson", q, Cp.StartWithPY).From("MANHOLE");
return(SendService.GetDynamicList(pQuery));
}
public List <dynamic> GetBillNo(string q)
{
var service = new mms_rainwaterportService();
var pQuery = ParamQuery.Instance().Select("top 10 BillNo").AndWhere("BillNo", q, Cp.StartWith);
return(service.GetDynamicList(pQuery));
}
public dynamic GetPageData(string id)
{
var masterService = new Mes_BlankingBoardService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var detail = new Mes_BlankingResultService().GetDynamicList(ParamQuery.Instance().AndWhere("MainID", id).AndWhere("IsEnable", 1));
var query = new RequestWrapper();
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>V__Mes_BlankingResult</from>
</settings>");
var result = new
{
//主表数据
form = masterService.GetModel(pQuery),
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new Mes_BlankingResultService().GetDynamicListWithPaging(query.ToParamQuery().AndWhere("MainID", id).AndWhere("IsEnable", 1))
//new Mes_BlankingResultService().GetDynamicListWithPaging(query.ToParamQuery().AndWhere("MainID", id).AndWhere("IsEnable",1))
};
return(result);
}
public List <dynamic> GetAllValueTextList(string codeTypeList)
{
var pQuery = ParamQuery.Instance().AndWhere("CodeType", codeTypeList, Cp.In)
.Select("Value as value,Text as text,CodeType as codetype");
return(base.GetDynamicList(pQuery));
}
public ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
urls = MmsHelper.GetIndexUrls("send"),
resx = MmsHelper.GetIndexResx("发料单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
PriceKind = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Code as value,Text as text").Where("CodeType", "Pricing")),
Purpose = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Code as value,Text as text").Where("CodeType", "MaterialUse"))
},
form = new
{
BillNo = "",
PickUnitName = "",
DoPerson = "",
WarehouseCode = "",
PriceKind = "",
SendDate = ""
}
};
return(View(model));
}
// 地址：GET api/mms/send/getdoperson
public List <dynamic> GetDoPerson(string q)
{
var SendService = new mms_rentOffService();
var pQuery = ParamQuery.Instance().Select("top 10 DoPerson").Where(c => c.And("DoPerson", q).Symbol("StartWithPY"));//.AndWhere("DoPerson", q, Cp.StartWithPY);
return(SendService.GetDynamicList(pQuery));
}
//
// GET: /Mms/TestABC/
public ActionResult Index()
{
var model = new
{
dataSource = new{
TypeItems = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Code as value,Text as text").AndWhere("CodeType", "Pricing"))
},
urls = new{
query = "/api/mms/testabc",
newkey = "/api/mms/testabc/getnewkey",
edit = "/api/mms/testabc/edit"
},
resx = new{
noneSelect = "请先选择一条货物数据！",
editSuccess = "保存成功！",
auditSuccess = "单据已审核！"
},
form = new{
Year = "",
ProjectName = "",
DeclaringUnits = "",
ProjectType = "",
StartDate = "",
EndDate = ""
},
defaultRow = new {
},
setting = new{
postListFields = new string[] { "ID", "Year", "ProjectName", "DeclaringUnits", "ProjectType", "StartDate", "EndDate", "TotalMoney", "Remark" }
}
};
return(View(model));
}
public dynamic GetPageData(string id)
{
var masterService = new QMS_ShipmentInspectionService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var mainData = masterService.GetModel(pQuery);
if (mainData != null)
{
var pQuery2 = ParamQuery.Instance().AndWhere("MainID", mainData.ID);
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new QMS_ShipmentInspectionItemService().GetDynamicList(pQuery2)
};
return(result);
}
else
{
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = ""
};
return(result);
}
}
public ActionResult Index()
{
var model = new
{
dataSource = new{
warehouseItems = new psi_warehouseService().GetDynamicList(ParamQuery.Instance().Select("Id as value,Name as text"))
},
urls = new{
query = "/api/psi/goods",
newkey = "/api/psi/goods/getnewkey",
edit = "/api/psi/goods/edit"//audit = "/api/psi/audit";
},
resx = new{
noneSelect = "请先选择一条货物数据！",
editSuccess = "保存成功！",
auditSuccess = "单据已审核！"
},
form = new{
Id = "",
Name = "",
Catagory = "",
Brand = ""
},
defaultRow = new {
},
setting = new{
postListFields = new string[] { "Id", "Name", "Catagory", "Brand", "Model", "Unit", "Remark" }
}
};
return(View(model));
}
// 开始查询
protected void onQueryAccount(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQuery param = new ParamQuery();
param.m_way = (QueryWay)m_queryWay.SelectedIndex;
param.m_param = m_param.Text;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
param.m_time = m_regTime.Text;
if (param.m_way == QueryWay.by_way0)
{
//BtnBlockAcc.Visible = true;
}
else
{
//BtnBlockAcc.Visible = false;
}
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeAccount, user);
genTable(m_result, res, param, user, mgr);
}
void getSEValue(ParamQuery param, GMUser user, string[] fields, int playerId, ref long svalue, ref long evalue)
{
DateTime mint = DateTime.Now, maxt = DateTime.Now;
Tool.splitTimeStr(param.m_time, ref mint, ref maxt);
IMongoQuery imq1 = Query.LT("genTime", BsonValue.Create(maxt));
IMongoQuery imq2 = Query.GTE("genTime", BsonValue.Create(mint));
IMongoQuery imq = Query.And(imq1, imq2, Query.EQ("playerId", BsonValue.Create(playerId)));
List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.STAT_PLAYER_DRAGON,
user.getDbServerID(),
DbName.DB_PUMP,
imq, 0, 1, fields, "genTime", true);
if (dataList.Count > 0)
{
svalue = Convert.ToInt32(dataList[0][fields[0]]);
}
dataList = DBMgr.getInstance().executeQuery(TableName.STAT_PLAYER_DRAGON,
user.getDbServerID(),
DbName.DB_PUMP,
imq, 0, 1, fields, "genTime", false);
if (dataList.Count > 0)
{
evalue = Convert.ToInt32(dataList[0][fields[1]]);
}
}
public override OpRes makeQuery(object param, GMUser user, QueryCondition queryCond)
{
ParamQuery p = (ParamQuery)param;
if (string.IsNullOrEmpty(p.m_time))
{
return(OpRes.op_res_time_format_error);
}
DateTime mint = DateTime.Now, maxt = DateTime.Now;
bool res = Tool.splitTimeStr(p.m_time, ref mint, ref maxt);
if (!res)
{
return(OpRes.op_res_time_format_error);
}
if (queryCond.isExport())
{
queryCond.addCond("time", p.m_time);
}
else
{
IMongoQuery imq1 = Query.LT("genTime", BsonValue.Create(maxt));
IMongoQuery imq2 = Query.GTE("genTime", BsonValue.Create(mint));
queryCond.addImq(Query.And(imq1, imq2));
}
return(OpRes.opres_success);
}
//public dynamic GetPageData(string id)
//{
// var masterService = new WMS_BN_TransfersMainService();
// var pQuery = ParamQuery.Instance().AndWhere("ID", id);
// var result = new
// {
// //主表数据
// form = masterService.GetModel(pQuery),
// scrollKeys = masterService.ScrollKeys("ID", id),
// //明细数据
// tab0 = new WMS_BN_TransfersDetailService().GetDynamicList(pQuery)
// };
// return result;
//}
public dynamic GetPageData(string id)
{
var masterService = new WMS_BN_TransfersMainService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var mainData = masterService.GetModel(pQuery);
if (mainData != null)
{
var pQuery2 = ParamQuery.Instance().AndWhere("BillCode", mainData.BillCode);
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new WMS_BN_TransfersDetailService().GetDynamicList(pQuery2)
};
return(result);
}
else
{
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = ""
};
return(result);
}
}
public override OpRes doQuery(object param, GMUser user)
{
m_result.reset();
ParamQuery p = (ParamQuery)param;
if (string.IsNullOrEmpty(p.m_time))
{
return(OpRes.op_res_time_format_error);
}
DateTime mint = DateTime.Now, maxt = DateTime.Now;
bool res = Tool.splitTimeStr(p.m_time, ref mint, ref maxt);
if (!res)
{
return(OpRes.op_res_time_format_error);
}
int itemId = 0;
if (!int.TryParse(p.m_param, out itemId))
{
return(OpRes.op_res_param_not_valid);
}
IMongoQuery imq1 = Query.LT("genTime", BsonValue.Create(maxt));
IMongoQuery imq2 = Query.GTE("genTime", BsonValue.Create(mint));
IMongoQuery imq = Query.And(imq1, imq2, Query.EQ("itemId", itemId));
return(query(p, imq, user, itemId));
}
public dynamic GetDepartment(string user)
{
var pQuery = ParamQuery.Instance()
.Select("DepartmentCode,DepartmentName").AndWhere("IsEnable ", 1).AndWhere("UserCode", user);
return(base.GetDynamic(pQuery));
}
public ActionResult Index()
{
var model = new
{
dataSource = new{
warehouseItems = new psi_warehouseService().GetDynamicList(ParamQuery.Instance().Select("Id as value,Name as text"))
},
urls = new{
query = "/api/psi/picking",
remove = "/api/psi/picking/",
billno = "/api/psi/picking/getnewbillno",
audit = "/api/psi/picking/audit/",
edit = "/psi/picking/edit/"
},
resx = new{
detailTitle = "领货单明细",
noneSelect = "请先选择一条领货单！",
deleteConfirm = "确定要删除选中的领货单吗？",
deleteSuccess = "删除成功！",
auditSuccess = "单据已审核！"
},
form = new{
BillNo = "",
PickPerson = "",
PickDate = "",
CustomerName = "",
Warehouse = "",
ContractNo = ""
}
};
return(View(model));
}
private OpRes query(ParamQuery param, IMongoQuery imq, GMUser user)
{
List <Dictionary <string, object> > dataList =
DBMgr.getInstance().executeQuery(TableName.STAT_GAME_TIME_FOR_DISTRIBUTION_RESULT, user.getDbServerID(), DbName.DB_PUMP, imq,
0, 0, null, "genTime", false);
if (dataList == null || dataList.Count == 0)
{
return(OpRes.op_res_not_found_data);
}
int i = 0;
for (i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
DateTime t = Convert.ToDateTime(data["genTime"]).ToLocalTime();
GameTimeForDistributionBase tmp = new GameTimeForDistributionBase();
tmp.m_gameId = Convert.ToInt32(data["gameId"]);
tmp.m_Less10s = Convert.ToInt32(data["Less10s"]);
tmp.m_Less30s = Convert.ToInt32(data["Less30s"]);
tmp.m_Less60s = Convert.ToInt32(data["Less60s"]);
tmp.m_Less5min = Convert.ToInt32(data["Less5min"]);
tmp.m_Less10min = Convert.ToInt32(data["Less10min"]);
tmp.m_Less30min = Convert.ToInt32(data["Less30min"]);
tmp.m_Less60min = Convert.ToInt32(data["Less60min"]);
tmp.m_GT60min = Convert.ToInt32(data["GT60min"]);
m_result.addData(t, tmp);
}
return(OpRes.opres_success);
}
public dynamic GetTextUsers()
{
var pQuery = ParamQuery.Instance()
.Select("username as value,username as text");
return(base.GetDynamicList(pQuery));
}
private OpRes queryEnterRoom(ParamQuery param, IMongoQuery imq, GMUser user)
{
List <Dictionary <string, object> > dataList =
DBMgr.getInstance().executeQuery(TableName.STAT_NEW_PLAYER_ENTER_ROOM,
user.getDbServerID(), DbName.DB_PUMP, imq,
0, 0, null, "genTime", false);
if (dataList == null || dataList.Count == 0)
{
return(OpRes.op_res_not_found_data);
}
int i = 0;
for (i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
DateTime time = Convert.ToDateTime(data["genTime"]).ToLocalTime();
int roomId = Convert.ToInt32(data["roomId"]);
int enterCount = Convert.ToInt32(data["enterCount"]);
m_result.addEnterCount(time, roomId, enterCount);
}
return(OpRes.opres_success);
}
/// <summary>
/// 地址：GET api/mms/merchant/getnames
/// 功能：取得收料单供应商
/// 调用：供应商自动完成
/// </summary>
public List <dynamic> GetNames(string q)
{
var ReceiveService = new mms_merchantsService();
var pQuery = ParamQuery.Instance().Select("top 10 MerchantsName").AndWhere("MerchantsName", q, Cp.StartWithPY);
return(ReceiveService.GetDynamicList(pQuery));
}
// 金币下注分布
private OpRes queryOutlayDistribution(ParamQuery param, IMongoQuery imq, GMUser user)
{
List <Dictionary <string, object> > dataList =
DBMgr.getInstance().executeQuery(TableName.STAT_NEW_PLAYER_OUTLAY_DISTRIBUTION,
user.getDbServerID(), DbName.DB_PUMP, imq,
0, 0, null, "genTime", false);
if (dataList == null || dataList.Count == 0)
{
return(OpRes.op_res_not_found_data);
}
int i = 0;
for (i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
DateTime time = Convert.ToDateTime(data["genTime"]).ToLocalTime();
for (int k = 0; k < 11; k++)
{
int val = Convert.ToInt32(data[k.ToString()]);
m_result.addOutlayInfo(time, k, val);
}
}
return(OpRes.opres_success);
}
public List <dynamic> GetAllValueTextList()
{
var pQuery = ParamQuery.Instance()
.Select("Value as value,Text as text,CodeType as codetype");
return(base.GetDynamicList(pQuery));
}
private OpRes query(ParamQuery param, IMongoQuery imq, GMUser user)
{
List <Dictionary <string, object> > dataList =
DBMgr.getInstance().executeQuery(TableName.STAT_GAME_TIME_FOR_PLAYER_FAVOR_RESULT, user.getDbServerID(), DbName.DB_PUMP, imq,
0, 0, null, "genTime", true);
if (dataList == null || dataList.Count == 0)
{
return(OpRes.op_res_not_found_data);
}
int i = 0;
for (i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
DateTime t = Convert.ToDateTime(data["genTime"]).ToLocalTime();
int playerType = Convert.ToInt32(data["playerType"]);
int playerCount = Convert.ToInt32(data["playerCount"]);
GameTimeForPlayerFavorBase gpf = m_result.addData(t, playerType, 0, 0);
gpf.m_playerCount = playerCount;
for (int k = 0; k < StrName.s_gameName.Length; k++)
{
if (data.ContainsKey("game" + k.ToString()))
{
long count = Convert.ToInt64(data["game" + k.ToString()]);
m_result.addData(t, playerType, k, count);
}
}
}
return(OpRes.opres_success);
}
public dynamic GetSettingList(string id)
{
var pQuery = ParamQuery.Instance().AndWhere("UserCode", id);
var service = new sys_userSettingService();
return(service.GetModelList(pQuery));
}
private OpRes query(ParamQuery param, IMongoQuery imq, GMUser user)
{
List <Dictionary <string, object> > dataList =
DBMgr.getInstance().executeQuery(TableName.STAT_FIRST_RECHARGE_GAME_TIME_DISTRIBUTION_RESULT, user.getDbServerID(), DbName.DB_PUMP, imq,
0, 0, null, "genTime", true);
if (dataList == null || dataList.Count == 0)
{
return(OpRes.op_res_not_found_data);
}
int i = 0;
for (i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
DateTime t = Convert.ToDateTime(data["genTime"]).ToLocalTime();
int playerType = Convert.ToInt32(data["playerType"]);
FirstRechargeGameTimeDistributionBase tmp = new FirstRechargeGameTimeDistributionBase();
tmp.m_Less1min = Convert.ToInt32(data["Less1min"]);
tmp.m_Less10min = Convert.ToInt32(data["Less10min"]);
tmp.m_Less30min = Convert.ToInt32(data["Less30min"]);
tmp.m_Less60min = Convert.ToInt32(data["Less60min"]);
tmp.m_Less3h = Convert.ToInt32(data["Less3h"]);
tmp.m_Less5h = Convert.ToInt32(data["Less5h"]);
tmp.m_Less12h = Convert.ToInt32(data["Less12h"]);
tmp.m_Less24h = Convert.ToInt32(data["Less24h"]);
tmp.m_GT24h = Convert.ToInt32(data["GT24h"]);
m_result.addData(t, playerType, tmp);
}
return(OpRes.opres_success);
}
public List <dynamic> GetBillNo(string q)
{
var service = new mms_inspectionwellService();
var pQuery = ParamQuery.Instance().Select("top 10 BillNo").AndWhere("BillNo", q, Cp.StartWith).From("MANHOLE");;
return(service.GetDynamicList(pQuery));
}
private OpRes query(ParamQuery param, IMongoQuery imq, GMUser user)
{
List <Dictionary <string, object> > dataList =
DBMgr.getInstance().executeQuery(TableName.STAT_FIRST_RECHARGE_POINT_DISTRIBUTION_RESULT, user.getDbServerID(), DbName.DB_PUMP, imq,
0, 0, null, "genTime", true);
if (dataList == null || dataList.Count == 0)
{
return(OpRes.op_res_not_found_data);
}
int i = 0;
for (i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
DateTime t = Convert.ToDateTime(data["genTime"]).ToLocalTime();
int playerType = Convert.ToInt32(data["playerType"]);
FirstRechargePointDistribution tmp = new FirstRechargePointDistribution();
m_result.addData(t, playerType, tmp);
data.Remove("genTime");
data.Remove("playerType");
data.Remove("_id");
foreach (var d in data)
{
tmp.add(Convert.ToInt32(d.Key), Convert.ToInt32(d.Value));
}
}
return(OpRes.opres_success);
}
// 地址：GET api/mms/refund/getdoperson
public List <dynamic> GetRefundPerson(string q)
{
var SendService = new mms_refundService();
var pQuery = ParamQuery.Instance().Select("top 10 RefundPerson").AndWhere("RefundPerson", q, Cp.StartWithPY);
return(SendService.GetDynamicList(pQuery));
}
public dynamic GetIntoryNameByCode(string InventoryCode)
{
return(new SYS_PartService().GetModelList(
ParamQuery.Instance()
.AndWhere("InventoryCode", InventoryCode)
).Select(a => new { value = a.InventoryCode, label = a.InventoryName }));
}
