public ResponseResult getFenceList(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string fname;
string almtype;
string graphtype;
try
{
sysflag = inparams["sysflag"];
fname = inparams["fname"];
almtype = inparams["almtype"];
graphtype = inparams["graphtype"];
DataTable dt = getList(sysflag, fname, almtype, graphtype);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
res.isallresults = 0;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult getRegionList(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string regionname;
string uid;
try
{
sysflag = inparams["sysflag"];
regionname = inparams["regionname"];
uid = inparams["sysuid"];
DataTable dt = getList(sysflag, regionname, uid);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
res.isallresults = 0;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
private void ExecuteDeleteMethod(object obj)
{
_reservationRepository.RemoveReservation(SelectedRes.ResNum);
ResList.Remove(SelectedRes);
SelectedRes = new ReservationVo(); //삭제되면 SelectedRes도 삭제 됨으로 다시 생성
SelectedRes.StartAt = DateTime.Today;
}
public ResList GetRestaurants()
{
ResList allRes = new ResList();
using (var con = new NpgsqlConnection(connectionString))
{
con.Open();
using (var cmd = new NpgsqlCommand($"SELECT * FROM restaurants", con))
using (var reader = cmd.ExecuteReader())
while (reader.Read())
{
var res = new ResSummary
{
restaurant_id = reader.GetInt32(0),
name = reader.GetString(1),
description = reader.GetString(2),
rating = reader.GetIntOrDefault(3),
photo_url = reader.GetStringOrDefault(4),
address = reader.GetStringOrDefault(5),
link_to_360 = reader.GetStringOrDefault(6),
latitude = reader.GetFloatOrDefault(7),
longitude = reader.GetFloatOrDefault(8),
created_at = reader.GetDateTime(9)
};
allRes.restaurants.Add(res);
}
}
return(allRes);
}
public ResponseResult GetLastPhoto(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
try
{
ComSqlHelper csh = new ComSqlHelper();
string sysflag = inparams["sysflag"];
string cids = inparams["cids"];
SqlParameter[] Parameters0 = new SqlParameter[1];
Parameters0[0] = new SqlParameter("@CIDS", cids);
DataTable dt = csh.FillDataSet(sysflag, WebProc.Proc("GetLastPhotoByCids"), Parameters0).Tables[0];
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult GetDistributionCarsStat(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string sysflag;
string carno;
string carownname;
string uid;
string onecaruser;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("sysflag") || !inparams.Keys.Contains("carno") || !inparams.Keys.Contains("carownname"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
sysflag = inparams["sysflag"];
carno = inparams["carno"];
carownname = inparams["carownname"];
uid = inparams["sysuid"];
onecaruser = inparams["onecaruser"];
//调用存储过程查询车辆超速信息
//todo
DataTable dt = QueryDistributionCars(sysflag, carno, carownname, stime, etime, uid, onecaruser);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult FenceAlarmStatDetail(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string uid;
string cid;
string st;
string et;
try
{
sysflag = inparams["sysflag"];
uid = inparams["uid"];
cid = inparams["cid"];
st = inparams["st"];
et = inparams["et"];
DataTable dt = getFenceAlarmStatDetailList(sysflag, uid, cid, st, et);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
res.isallresults = 0;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult getOfflineStatisticDetail(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string sysflag;
string num;
string cid;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("cid") || !inparams.Keys.Contains("sysflag") || !inparams.Keys.Contains("num"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
sysflag = inparams["sysflag"];
num = inparams["num"];
cid = inparams["cid"];
DataTable dtStatDetail = GetStatDetailTable(sysflag, cid, stime, etime);
DataTable dtDetailOrg = OrgnizeTableDetailNew(dtStatDetail);
List <OfflineStatDetail> offlineStatDetailList = OrgnizeOfflineStatDetail(dtDetailOrg, Int32.Parse(num));
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = offlineStatDetailList.Count;
res.records = offlineStatDetailList;
res.isallresults = 1;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult getRegionCarsList(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string uid;
string rid;
try
{
sysflag = inparams["sysflag"];
uid = inparams["uid"];
rid = inparams["rid"];
DataTable[] dtArr = getRegionCarList(sysflag, uid, rid);
int Total = dtArr.Length;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dtArr;
res.isallresults = 0;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
/// <summary>
///
/// </summary>
/// <param name="State"></param>
/// <param name="Msg"></param>
/// <param name="Result">Select操作时此处使用ResList类型对象</param>
public ResponseAppResult(ResState State, string Msg, ResList Result)
{
state = (int)State;
msg = Msg;
result = Result == null ? "" : (object)Result;
rtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
/// <summary>
/// 查询放款机构
/// </summary>
/// <param name="inparams">初始参数</param>
/// <returns>字典项列表</returns>
public ResponseResult getOrg(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag = string.Empty;
if (!inparams.Keys.Contains("sysflag"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
sysflag = inparams["sysflag"];
//调用存储过程查询放款机构
DataTable dt = daoGetOrg(sysflag);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
/// <summary>
/// 获取里程统计详细信息
/// </summary>
/// <param name="inparams"></param>
/// <returns></returns>
public ResponseResult getCollectInfo(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
int cid;
string sysflag;
int alarmtype;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("cid") || !inparams.Keys.Contains("sysflag"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["cid"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "请选择车辆", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
cid = int.Parse(inparams["cid"].ToString());
sysflag = inparams["sysflag"];
//调用存储过程查询里程明细数据
//todo
DataTable dt = GetCollectInfoById(sysflag, cid, stime, etime);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
private bool HasReservations(uint?stylistId, DateTime startTime, DateTime endTime) //time --> 예약 끝나는 시간
{
// ResList = new ObservableCollection<ReservationVo>(_reservationRepository.GetReservations()); //다시 db상에서 데이터 받아옴
// 이거할시 SelectedRes 사라짐
int startTimeTotalM = ReturnTotalMin(startTime);
int endTimeTotalM = ReturnTotalMin(endTime);
foreach (ReservationVo r in ResList.Where(x => x.StylistId == stylistId))
{
int rstartTimeTotalM = ReturnTotalMin(r.StartAt);
int rendTimeTotalM = ReturnTotalMin(r.EndAt);
if (rstartTimeTotalM == rendTimeTotalM)
{
continue;
}
if (r.StartAt.Date == startTime.Date)
{
if (rstartTimeTotalM <= startTimeTotalM && rendTimeTotalM > endTimeTotalM) //다른 예약에 의해 포함될때
{
return(true);
}
else if (startTimeTotalM <= rstartTimeTotalM && endTimeTotalM >= rendTimeTotalM) //한 예약을 포함할때
{
return(true);
}
else if (startTimeTotalM < rstartTimeTotalM && endTimeTotalM < rendTimeTotalM && endTimeTotalM != rstartTimeTotalM && endTimeTotalM > rstartTimeTotalM) // 일부분이 겹칠때
{
return(true);
}
}
}
return(false);
}
/// <summary>
/// 查询试乘试驾数据列表
/// </summary>
/// <param name="inparams"></param>
/// <returns></returns>
public ResponseResult getTCDetail(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string cid;
string sysflag;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("cid") || !inparams.Keys.Contains("sysflag"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["cid"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "请选择车辆", null);
return(Result);
}
//if (inparams["sysflag"] == "")
//{
// Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
// return Result;
//}
stime = inparams["stime"];
etime = inparams["etime"];
cid = inparams["cid"];
sysflag = inparams["sysflag"];
//调用存储过程查询试乘试驾数据
//todo
DataTable dt = GetTestSituation(sysflag, cid, stime, etime);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult getSFCar(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string stime;
string area;
string province;
string dealername;
string dealercode;
string cartype;
string carno;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("sysflag"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "查询年月不能为空", null);
return(Result);
}
sysflag = inparams["sysflag"];
stime = inparams["stime"];
stime = stime.Substring(0, 7);
area = inparams["area"];
province = inparams["province"];
dealername = inparams["dealername"];
dealercode = inparams["dealercode"];
cartype = inparams["cartype"];
carno = inparams["carno"];
//调用存储过程查询车辆启动熄火数据
//todo
DataTable dt = GetStatusCars(sysflag, stime, area, province, dealername, dealercode, cartype, carno);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult getCarOnlineRate_Month(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string sysflag;
string sysuid;
string onecaruser;
string token;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("token") || !inparams.Keys.Contains("sysflag") || !inparams.Keys.Contains("sysuid") || !inparams.Keys.Contains("onecaruser"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
sysuid = inparams["sysuid"];
sysflag = inparams["sysflag"];
onecaruser = inparams["onecaruser"];
token = inparams["token"];
DataTable dt = GetOnlineDate(sysflag, sysuid, stime, etime, onecaruser);
DataTable[] resDt = GetOnlineRateMonth(token, stime, etime, dt);
int Total = resDt.Length;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = resDt;
res.isallresults = 0;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult QueryList(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string sysflag;
string CarNo;
string CarOwnName;
string sysuid;
string onecaruser;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("CarNo") || !inparams.Keys.Contains("sysflag") || !inparams.Keys.Contains("CarOwnName"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
CarNo = inparams["CarNo"];
CarOwnName = inparams["CarOwnName"];
sysuid = inparams["sysuid"];
sysflag = inparams["sysflag"];
onecaruser = inparams["onecaruser"];
//调用存储过程查询能耗分析总表
//todo
DataTable dt = EnergyAnalysisList(sysflag, sysuid, stime, etime, CarNo, CarOwnName, onecaruser);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public ResponseResult QueryFaultDetailList(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string sysflag;
string cid;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("cid") || !inparams.Keys.Contains("sysflag"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
cid = inparams["cid"];
sysflag = inparams["sysflag"];
DataTable originalDt = GetFaultDetailList(sysflag, cid, stime, etime);
DataTable resultDt = FormatDetailData(originalDt);
int Total = resultDt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = resultDt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public bool NetReciveMsg(byte[] recivebuffer, int netID)
{
var arg = new ByteOutArg(recivebuffer);
var str = arg.ReadString();
ResList.Enqueue(str);
//UnityEngine.Debug.Log(str);
return(true);
}
public TableauResNumTravailleurs(ResList rl)
{
resList = rl;
workerIds = rl.Keys.ToArray();
InitializeComponent();
WorkerShown.ItemsSource = workerIds;
WorkerShown.SelectedIndex = 0;
WorkerShown_SelectionChanged(WorkerShown);
}
public ResponseResult queryOneCarHistoryPhoto(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string stime;
string etime;
string sysflag;
string cid;
string tdh;
if (!inparams.Keys.Contains("stime") || !inparams.Keys.Contains("etime") || !inparams.Keys.Contains("sysflag") || !inparams.Keys.Contains("sysuid") || !inparams.Keys.Contains("cid"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["stime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "开始时间不能为空", null);
return(Result);
}
if (inparams["etime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "结束时间不能为空", null);
return(Result);
}
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
stime = inparams["stime"];
etime = inparams["etime"];
sysflag = inparams["sysflag"];
cid = inparams["cid"];
tdh = inparams["tdh"];
//调用存储过程查询车辆超速信息
//todo
DataTable dt = GetOneCarHistoryPhotos(sysflag, stime, etime, cid, tdh);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public TableauResNum(ResList d)
{
String val = "";
InitializeComponent();
foreach (Pair1 p in d["RES"])
{
String lbl = p.Key;
Pair2 p2 = p.Value;
bool isFileLink = false;
if (p2.Key == 0)
{
val = MainWindow.ShowDouble(p2.Value);
}
else if (p2.Key == 2)
{
val = p2.Value.ToString();
isFileLink = true;
}
else
{
Dict dict = p2.Value as Dict;
bool ok = false;
try
{
ok = dict.TryGetValue("est", out double v);
ok = dict.TryGetValue("lcl", out double v1);
ok = dict.TryGetValue("ucl", out double v2);
val = MainWindow.ShowDouble(v) + " [" + MainWindow.ShowDouble(v1) + " - " + MainWindow.ShowDouble(v2) + "]";
}
catch (ArgumentNullException)
{
}
}
TableRow tr = new TableRow();
tr.Cells.Add(new TableCell(new Paragraph(new Run(lbl))));
Run run = new Run(val);
if (isFileLink)
{
Hyperlink fileLink = new Hyperlink(run);
fileLink.Click += openFile_Click;
fileLink.NavigateUri = new Uri(val);
tr.Cells.Add(new TableCell(new Paragraph(fileLink)));
}
else
{
tr.Cells.Add(new TableCell(new Paragraph(run)));
}
tableauResultats.RowGroups[0].Rows.Add(tr);
}
}
/// <summary>
/// Fügt einem Spieler einen bestimmten Resourcen Betrag hinzu
/// </summary>
/// <param name="user">Benutzer, dem die Resourcen hinzugefügt werden sollen</param>
/// <param name="resources">Liste der Resourcen</param>
public void addRes(User user, ResList resources)
{
lock (resourceList)
{
foreach (KeyValuePair<ResType, double> get in resources)
{
addRes(user, get.Key, get.Value);
}
}
}
// Use this for initialization
void Start () {
Stats = new ResList(100, 200, 300, 400, 500, 600, 0);
// _resources = new Mod.Resource();
//Money = GameObject.Find("UI Root/Stats/Labels/Money").GetComponent<UILabel>();
Money = GameObject.Find("Money").GetComponent<UILabel>();
Eat = GameObject.Find("Eat").GetComponent<UILabel>();
Water = GameObject.Find("Water").GetComponent<UILabel>();
Energy = GameObject.Find("Energy").GetComponent<UILabel>();
Fassils = GameObject.Find("Fassils").GetComponent<UILabel>();
Wood = GameObject.Find("Wood").GetComponent<UILabel>();
Genetics = GameObject.Find("Genetics").GetComponent<UILabel>();
UpdateRes();
}
public ResponseResult QueryCarMaintenanceRemind(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string carno;
string token;
string remindmileage;
string uid;
string onecaruser;
if (!inparams.Keys.Contains("carno") || !inparams.Keys.Contains("token"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["token"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统回话标识错误", null);
return(Result);
}
carno = inparams["carno"];
token = inparams["token"];
uid = inparams["sysuid"];
onecaruser = inparams["onecaruser"];
sysflag = inparams["sysflag"];
remindmileage = inparams["remindmileage"];
DataTable cardt = getCars(carno, token);
DataTable carmaintenancedt = getCarMaintenanceData(sysflag, carno, uid, onecaruser);
DataTable dtResult = new DataTable();
if (cardt != null && cardt.Rows.Count > 0)
{
dtResult = GetRemindData(sysflag, cardt, carmaintenancedt, remindmileage);
}
int Total = dtResult.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dtResult;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
/// <summary>
/// 获取未上线车辆列表
/// </summary>
/// <param name="inparams"></param>
/// <returns></returns>
public ResponseResult getCarOnLine(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string uid;
string datime;
string sysflag;
string onecaruser;
if (!inparams.Keys.Contains("uid") || !inparams.Keys.Contains("datime"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["uid"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "用户错误", null);
return(Result);
}
if (inparams["datime"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "车辆未在线天数错误", null);
return(Result);
}
uid = inparams["uid"];
datime = inparams["datime"];
sysflag = inparams["sysflag"];
onecaruser = inparams["onecaruser"];
//调用存储过程查询车辆数据
//todo
DataTable dt = GetCarOnLine(sysflag, uid, datime, onecaruser);
//for (int i = 1; i <= dt.Rows.Count; i++)
//{
// dt.Rows[i - 1]["NO"] = i;
//}
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
private void RemoveRS(object obj)
{
ReservedServiceVo rsv = (ReservedServiceVo)obj;
_reservedServiceRepository.RemoveReservedService(rsv.ResNum, rsv.SerId);
ServiceCommands.Remove(ServiceCommands.Single(x => (x.Data == rsv)));
ServiceVo s = ServiceList.Single(x => x.ServiceId == rsv.SerId);
ReservationVo r = ResList.Single(x => x.ResNum == rsv.ResNum);
TimeSpan ts = new TimeSpan(s.ServiceTime / 60, s.ServiceTime % 60, 0);
r.EndAt = r.EndAt - ts;
_reservationRepository.UpdateReservation(r);
}
private async void Del(object obj)
{
BgVis = true;
if (WpfMessageBox.Show("Удаление", "Вы действительно хотите удалить бронь?", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
_model.db.ReservationSet.Remove(Cur_Item);
ResList.Remove(Cur_Item);
Cur_Item = null;
OnPropertyChanged(new PropertyChangedEventArgs("ResList"));
Update?.Invoke(obj, null);
await _model.db.SaveChangesAsync();
}
BgVis = false;
}
public ResponseAppResult AppGetAppAlarmAlert(Dictionary <string, string> inparams)
{
ResponseAppResult Result = null;
if (!inparams.Keys.Contains("cid") || inparams["cid"] == "")
{
Result = new ResponseAppResult(ResState.ParamsImperfect, "缺少cid或cid为空！", null);
return(Result);
}
if (!inparams.Keys.Contains("st") || inparams["st"] == "")
{
Result = new ResponseAppResult(ResState.ParamsImperfect, "缺少st或st为空！", null);
return(Result);
}
if (!inparams.Keys.Contains("et") || inparams["et"] == "")
{
Result = new ResponseAppResult(ResState.ParamsImperfect, "缺少et或et为空！", null);
return(Result);
}
if (!inparams.Keys.Contains("uid") || inparams["uid"] == "")
{
Result = new ResponseAppResult(ResState.ParamsImperfect, "缺少uid或uid为空！", null);
return(Result);
}
try
{
string sysflag = inparams["sysflag"];
long uid = long.Parse(inparams["uid"]);
long cid = GetCarCIDBySimCode(sysflag, inparams["cid"]);
DateTime st = DateTime.Parse(inparams["st"]);
DateTime et = DateTime.Parse(inparams["et"]);
DataTable dt = GetAppAlarmAlert(WebProc.GetAppSysflagKey(sysflag), cid.ToString(), uid.ToString(), st, et);
ResList res = new ResList();
res.isallresults = 1;
res.records = dt;
res.total = dt.Rows.Count;
res.size = 0;
res.page = 0;
Result = new ResponseAppResult(ResState.Success, "操作成功", res);
}
catch (Exception ex)
{
LogHelper.WriteError("AppGetCarLastTrack调用异常", ex);
Result = new ResponseAppResult(ResState.OperationFailed, ex.Message, null);
}
return(Result);
}
private void ExecuteInsertMethod(object obj)
{
if (!Check(SelectedRes))
{
return;
}
SelectedRes.EndAt = SelectedRes.StartAt;
SelectedRes.ResNum = _reservationRepository.InsertReservation(SelectedRes);
ResList.Add(SelectedRes);
_userRepository.InsertUser(new UserVo()
{
UserTel = SelectedRes.UserTel, Point = 0
});
_reservationRepository.RecentResNum = SelectedRes.ResNum;
}
/// <summary>
/// 车辆列表查询
/// </summary>
/// <param name="inparams"></param>
/// <returns></returns>
public ResponseResult getCarList(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
string sysflag;
string sysuid;
string carno;
string cid;
string cuid;
string carownname;
string line;
if (!inparams.Keys.Contains("carno") || !inparams.Keys.Contains("sysflag") || !inparams.Keys.Contains("cuid") || !inparams.Keys.Contains("carownname") || !inparams.Keys.Contains("cid") || !inparams.Keys.Contains("sysuid") || !inparams.Keys.Contains("line"))
{
Result = new ResponseResult(ResState.ParamsImperfect, "缺少参数", null);
return(Result);
}
try
{
if (inparams["sysflag"] == "")
{
Result = new ResponseResult(ResState.ParamsImperfect, "系统标识错误", null);
return(Result);
}
carno = inparams["carno"];
cid = inparams["cid"];
cuid = inparams["cuid"];
carownname = inparams["carownname"];
line = inparams["line"];
sysuid = inparams["sysuid"];
sysflag = inparams["sysflag"];
//调用存储过程查询车辆列表
DataTable dt = GetCarListSearch(sysflag, sysuid, carno, cid, cuid, carownname, line);
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
res.isallresults = 0;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
public void Dispose()
{
Loaded = 0;
Utils.Reclaim(mLoader);
ResList.Clear();
mDepsSigned?.Clear();
CompleteEvent?.RemoveAllListeners();
RemoteAssetUpdated?.RemoveAllListeners();
CompleteEvent = default;
RemoteAssetUpdated = default;
mLoader = default;
mDepsSigned = default;
}
public void addResTest1()
{
Main main = null;
Resources target = new Resources(main);
User user = new User(1, "", "", new Race(1, "1"));
ResList resources = new ResList();
resources[ResType.Erz] = 1;
resources[ResType.Kurbidium] = 10;
resources[ResType.Unobtanium] = 200;
Assert.AreEqual(target.getResource(user, ResType.Erz), 0);
Assert.AreEqual(target.getResource(user, ResType.Kurbidium), 0);
Assert.AreEqual(target.getResource(user, ResType.Unobtanium), 0);
target.addRes(user, resources);
Assert.AreEqual(target.getResource(user, ResType.Erz), 1);
Assert.AreEqual(target.getResource(user, ResType.Kurbidium), 10);
Assert.AreEqual(target.getResource(user, ResType.Unobtanium), 200);
}
public void haveResTest()
{
Main main = null;
Resources target = new Resources(main);
User user = new User(1, "", "", new Race(1, "1"));
ResList price = new ResList();
price[ResType.Erz] = 100;
bool expected = false;
bool actual;
actual = target.haveRes(user, price);
Assert.AreEqual(expected, actual);
target.addRes(user, price);
expected = true;
actual = target.haveRes(user, price);
Assert.AreEqual(expected, actual);
}
private ResList getResourceListFromPanel(TextboxList holder)
{
ResList list = new ResList();
foreach (ResType type in Enum.GetValues(typeof(ResType)))
{
double value = getResourceFromPage(holder, type);
list[type] = value;
}
return list;
}
private void setResourceOnPage(ResList list, TextboxList holder)
{
foreach (KeyValuePair<ResType, double> ent in list)
{
setResourceOnPage(holder, ent.Key, ent.Value);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//To get the string to search in facility table
string departmentID = Request.QueryString["DepartmentID"];
string block = Request.QueryString["Block"];
string level = Request.QueryString["Level"];
string name = Request.QueryString["Name"];
//format of date yyyy-MMM-dd
string date = Request.QueryString["Date"];
var sqlResList = new ResList();
sqlResList.Reservations = new List<ResObject>();
//if date is blank, return current system date
if( date == "" )
{
DateTime dateToday = DateTime.Today;
DateTime dateStart = new DateTime(dateToday.Year, dateToday.Month, dateToday.Day, 08, 00, 00);
DateTime dateEnd = new DateTime(dateToday.Year, dateToday.Month, dateToday.Day, 18, 00, 00);
using (var db = new KioskContext())
{
var facilityRes = from fr in db.FacilityReservations
where fr.Facility.Department.DepartmentID == departmentID
&& fr.Facility.Block.Contains(block) && fr.Facility.Level.Contains(level)
&& fr.Facility.Name.Contains(name)
&& fr.StartDateTime >= dateStart
&& fr.EndDateTime <= dateEnd
orderby fr.FacilityID, fr.StartDateTime
select new
{
fr.FacilityReservationID,
fr.FacilityID,
fr.StartDateTime,
fr.EndDateTime,
fr.UseShortDescription,
fr.UseDescription
};
foreach (var res in facilityRes)
{
ResObject resobject = new ResObject(res.FacilityReservationID, res.FacilityID, res.StartDateTime.Value, res.EndDateTime.Value,
res.UseShortDescription, res.UseDescription);
sqlResList.Reservations.Add(resobject);
}
}
//Serialize into json format output (string)
string json = JsonConvert.SerializeObject(sqlResList, Formatting.Indented);
//codes to pass back the json string to the iPad
Response.Write(json);
Response.End();
}
//else return only specified date
else
{
//convert string date to datetime
DateTime datePass = DateTime.ParseExact(date, "yyyy-MMM-dd", CultureInfo.InvariantCulture);
DateTime dateStart = new DateTime(datePass.Year, datePass.Month, datePass.Day, 08, 00, 00);
DateTime dateEnd = new DateTime(datePass.Year, datePass.Month, datePass.Day, 18, 00, 00);
using (var db = new KioskContext())
{
var facilityRes = from fr in db.FacilityReservations
where fr.Facility.Department.DepartmentID == departmentID
&& fr.Facility.Block.Contains(block) && fr.Facility.Level.Contains(level)
&& fr.Facility.Name.Contains(name)
&& fr.StartDateTime >= dateStart
&& fr.EndDateTime <= dateEnd
orderby fr.FacilityID, fr.StartDateTime
select new
{
fr.FacilityReservationID,
fr.FacilityID,
fr.StartDateTime,
fr.EndDateTime,
fr.UseShortDescription,
fr.UseDescription
};
foreach (var res in facilityRes)
{
ResObject resobject = new ResObject(res.FacilityReservationID, res.FacilityID, res.StartDateTime.Value, res.EndDateTime.Value,
res.UseShortDescription, res.UseDescription);
sqlResList.Reservations.Add(resobject);
}
}
//Serialize into json format output (string)
string json = JsonConvert.SerializeObject(sqlResList, Formatting.Indented);
//logging
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string day = DateTime.Now.Day.ToString();
string fulldateTime = DateTime.Now.ToString();
string full = "[Executed on " + fulldateTime + " ]";
string path = "c:\\LogTest\\GetFacilityReservations-" + year + "-" + month + "-" + day + ".txt";
string line = "-----------------------------------------------------";
using (StreamWriter file = (File.Exists(path)) ? File.AppendText(path) : File.CreateText(path))
{
file.WriteLine(full);
file.WriteLine(line);
file.Close();
}
//codes to pass back the json string to the iPad
Response.Write(json);
Response.End();
}
}
/// <summary>
/// Überprüft ob ein Spieler mehr als einen bestimmten Betrag an Resourcen besitzt.
/// </summary>
/// <param name="user">Benutzer, für den die abfrage durchgeführt werden soll</param>
/// <param name="price">ResList Objekt mit den Kosten</param>
/// <returns>Boolscher Wert, der angibt, ob ein Spieler die benötigten Resouren besitzt</returns>
public bool haveRes(User user, ResList price)
{
ResList have = getResources(user);
foreach (KeyValuePair<ResType, double> want in price)
{
if (want.Value > have[want.Key])
{
return false;
}
}
return true;
}
