protected void btnCharge_Click(object sender, EventArgs e)
{
//var recharData = { "action": "IDIP_DO_PAY_CASH_REQ", "remark": "2017100402", "dis_uin": 10372, "src_uin": 10372, "role_name": "niuniu", "us_source": "2", "amount": "20", "ui_ip": "127.1.1.1", "gameId": "hlynzy", "sz_desc": "充值" };
//var strData = JSON.stringify(recharData);
string payMoney = "";
string payWapType = "4";
string payOutTradeNo = DateTime.Now.ToString("yyyyMMddhhmmss");
string paySubject = "";
if (this.SelectCount() == 1)
{
string strId = string.Empty;
foreach (GridViewRow gvrow in gvUsers.Rows)
{
CheckBox CheckBox = gvrow.FindControl("chbSelect") as CheckBox;
if (CheckBox.Checked)
{
payMoney = this.gvUsers.DataKeys[gvrow.RowIndex]["Mg_price"].ToString();
paySubject = this.gvUsers.DataKeys[gvrow.RowIndex]["Mg_Name"].ToString();
}
}
}
else if (this.SelectCount() == 0)
{
//Jswork.Alert("请选择一条记录进行修改", this.Page);
this.divAlert.Visible = true;
//this.lblAlert.Text = "请选择一条要购买的商品"; //"";
Jswork.Alert("请选择一条要购买的商品", this.Page);
return;
}
else
{
//Jswork.Alert("一次只能修改一条记录", this.Page);
this.divAlert.Visible = true;
//this.lblAlert.Text = "一次只能购买一个商品"; //"一次只能修改一条记录";
Jswork.Alert("一次只能购买一个商品", this.Page);
return;
}
//int payMoneyNum = Convert.ToInt32(payMoney) * 100;
string curuserId = Session["currentgameid"].ToString();
string trandeNo = PubFuncs.GenerateOrderNumber();
string payUrl = PayUlity.ZYFPay("9", payWapType, trandeNo, paySubject, curuserId);
//this.divAlert.Visible = true;
//this.lblAlert.Text = payOutTradeNo; //"一次只能修改一条记录";
if (!string.IsNullOrEmpty(payUrl))
{
Response.Redirect(payUrl);
}
/*
* var iUrl = "http://192.168.1.101:8888";
*
* using (var client = new WebClient())
* {
*
* Dictionary<string, string> dic = new Dictionary<string, string>();
* dic["action"] = "IDIP_DO_PAY_CASH_REQ";
* dic["remark"] = "2017100402";
* dic["dis_uin"] = "10372";
* dic["src_uin"] = "10372";
* dic["role_name"] = "niuniu";
* dic["us_source"] = "2";
* dic["amount"] = "20";
* dic["ui_ip"] = "127.1.1.1";
* dic["gameId"] = "hlynzy";
* dic["sz_desc"] = "充值";
* string json = new JavaScriptSerializer().Serialize(dic);
*
* string responseStr = HttpClientUlity.PostJsonData(iUrl, json);
*
* this.divAlert.Visible = true;
* this.lblAlert.Text = Resources.Resource.diamond_charge_suc; //"钻石充值成功";
* }
*/
}
protected StringBuilder BindTreeView()
{
string a = PlatformID;
StringBuilder str = new StringBuilder();
str.Append(ParentID + "_Child|||");
List <ModuleEO> modellist = new List <ModuleEO>();
//得到模块权限和角色的列表
List <RolemoduleEO> rmplist = new List <RolemoduleEO>();
rmplist = (List <RolemoduleEO>)System.Web.HttpContext.Current.Session["RmpList"];
//modellist = (List<ModuleEO>)mdManage.Get("Md_parentid='" + ParentID + "' AND Md_deleteFlag<>1 ORDER BY Md_filedOrder");
IList <MySqlParameter> parm = new List <MySqlParameter>();
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" Md_parentid=@Md_parentid AND Md_deleteFlag<>1 ORDER BY Md_filedOrder");
parm.Add(new MySqlParameter("@Md_parentid", ParentID));
modellist = (List <ModuleEO>)mdManage.Get(strWhere.ToString(), parm);
foreach (ModuleEO model in modellist)
{
//是否有下级内容
bool IsChild = true;
IList <MySqlParameter> parmC = new List <MySqlParameter>();
StringBuilder strWhereC = new StringBuilder();
strWhereC.Append(" Md_parentid=@Md_parentid and Md_existsTreeView='1' AND Md_deleteFlag<>1 ORDER BY Md_filedOrder");
parmC.Add(new MySqlParameter("@Md_parentid", model.MdId));
if (mdManage.Get(strWhereC.ToString(), parmC) != null)
//if (mdManage.Get("Md_parentid='" + model.MdId + "'and Md_existsTreeView='1' AND Md_deleteFlag<>1 ORDER BY Md_filedOrder") != null)
{
IsChild = true;
}
else
{
IsChild = false;
}
//最外层div格式
if (IsChild)
{
str.Append("<div id=" + model.MdId + " class=\"moduleChildYes\">");
}
else
{
str.Append("<div id=" + model.MdId + " class=\"moduleChildNo\">");
}
//最外层div中，顶级模块表格式
str.Append("<table class=\"ModuleTeble\">");
str.Append("<tr>");
str.Append("<td><div class=\"MapShow\" id=\"" + model.MdId + "_Map\"></div></td>");
if (IsChild)
{
if (model.MdImgUrl == "")
{
str.Append("<td></td>");
}
else
{
str.Append("<td><img src=\"" + model.MdImgUrl + "\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "')\"/ ></td>");
}
if (PubFuncs.IsLanguageEng())
{
str.Append("<td><div class=\"ChildTitleYes\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "')\" >" + model.MdText1.Trim() + "</a></td>");
}
else
{
str.Append("<td><div class=\"ChildTitleYes\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "')\" >" + model.MdName.Trim() + "</a></td>");
}
}
else
{
if (model.MdImgUrl == "")
{
str.Append("<td></td>");
}
else
{
str.Append("<td><img src=\"" + model.MdImgUrl + "\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','" + model.MdId.Trim() + "_Child','1','" + RoleID + "')\"/ ></td>");
}
str.Append("<td><div class=\"ChildTitleNo\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','1','" + RoleID + "')\" >" + model.MdName.Trim() + "</a></div></td>");
}
str.Append("</div>");
//加载权限列表
List <PermissionstatalEO> plist = new List <PermissionstatalEO>();
StringBuilder strWhereX = new StringBuilder();
strWhereX.Append(" 1=1");
IList <MySqlParameter> parmX = new List <MySqlParameter>();
strWhereX.Append(" and APerTat.Pt_del<>1 and APerTat.Pf_id=@Pf_id and AMoudlePer.Md_id = @Md_id");
parmX.Add(new MySqlParameter("@Pf_id", PlatformID));
parmX.Add(new MySqlParameter("@Md_id", model.MdId));
plist = (List <PermissionstatalEO>)ptManage.Gets(strWhereX.ToString(), parmX);
//plist = (List<PermissionstatalEO>)ptManage.Gets(" APerTat.Pt_del<>1 and APerTat.Pf_id='" + PlatformID + "' and AMoudlePer.Md_id = '" + model.MdId + "'");
//List<RolemoduleEO> mplist = new List<RolemoduleEO>();
string permissionsIdList = "";
int int_ls = 0;
StringBuilder strls = new StringBuilder();
foreach (PermissionstatalEO mpmodel in plist)
{
int_ls++;
StringBuilder strWhereL = new StringBuilder();
strWhereL.Append(" 1=1");
IList <MySqlParameter> parmL = new List <MySqlParameter>();
strWhereL.Append(" and Rl_id=@Rl_id and Md_id=@Md_id and Pt_id=@Pt_id");
parmL.Add(new MySqlParameter("@Rl_id", RoleID));
parmL.Add(new MySqlParameter("@Md_id", model.MdId));
parmL.Add(new MySqlParameter("@Pt_id", mpmodel.PtId));
if (rlmdManage.GetTable(strWhereL.ToString(), parmL).Rows.Count > 0)
//if (rlmdManage.GetTable("Rl_id='" + RoleID + "' and Md_id='" + model.MdId + "' and Pt_id='" + mpmodel.PtId + "'").Rows.Count > 0)
{
strls.Append("<input type=\"checkbox\" id=\"" + model.MdId + "_" + mpmodel.PtId + "\" checked=\"checked\" value=\"" + ISPermName(mpmodel.PtId, plist) + "\" onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\" />");
strls.Append("<span onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\">" + ISPermName(mpmodel.PtId, plist) + "</span>");
}
else
{
strls.Append("<input type=\"checkbox\" id=\"" + model.MdId + "_" + mpmodel.PtId + "\" value=\"" + ISPermName(mpmodel.PtId, plist) + "\" onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\" />");
strls.Append("<span onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\">" + ISPermName(mpmodel.PtId, plist) + "</span>");
}
if (int_ls == 1)
{
permissionsIdList += mpmodel.PtId;
}
else
{
permissionsIdList += "|" + mpmodel.PtId;
}
}
if (int_ls != 0)
{
str.Append("<td><div class=\"chackall\"><input type=\"checkbox\" id=\"" + model.MdId + "_all\" value=\"\" style=display:none onclick=\"Permsave('1','" + model.MdId + "','" + RoleID + "','','" + PlatformID + "')\"/><span> </span></div></td>");
str.Append("<td><div class=\"check\">");
str.Append(strls.ToString());
str.Append("</div><input type=\"hidden\" id=\"" + model.MdId + "_hidden\" value=\"" + permissionsIdList + "\">");
str.Append("</td>");
}
int_ls = 0;
str.Append("</tr>");
str.Append("</table>");
//下级最外层Div格式
if (IsChild)
{
str.Append("<div id=\"" + model.MdId.Trim() + "_Child\" class=\"moduleChild\" style=\"display:none;\"></div>");
}
str.Append("</div>");
}
return(str);
}
public PumpSystem(Guid ppGuid)
{
Guid = ppGuid;
Log.Inform();
Log.Inform($"--------- 开始构建机泵系统{Guid.ToFormatedString()} ---------");
Log.Inform();
#region 构建机泵部件
//部件部分
Pump = new Component(Guid, CompType.Pump)
{
NameRemark = "水泵"
};
Motor = new Component(Guid, CompType.Motor)
{
NameRemark = "电机"
};
Coupler = new Component(Guid, CompType.Coupler)
{
NameRemark = "联轴器"
};
//振动传感器部分
var vibrasensors = Repo.SensorList.Where(s => GuidExt.IsSameGuid(s.PPGUID, Guid)).ToList();
foreach (var vibrasensor in vibrasensors)
{
var td = new VibraTransducer(vibrasensor.SSGUID)
{
Signal = vibrasensor.ITEMCODE,
NameRemark = vibrasensor.SSNAME,
Position = PubFuncs.FindTdPosFromSignal(vibrasensor.ITEMCODE)
};
Transducers.Add(td);
Log.Inform($"添加振动传感器({td.NameRemark}): 信号量：{td.Signal} 位置：{td.Position}");
}
//非振动部分
foreach (var phydefnovibra in Repo.PhyDefNoVibra.Where(s => GuidExt.IsSameGuid(s.PPGUID, Guid)))
{
var type = PubFuncs.ParseSignalType(phydefnovibra.ITEMCODE);
if (type.HasValue)
{
var td = new NonVibraTransducer(phydefnovibra.PPGUID, type.Value, phydefnovibra.ID)
{
Signal = phydefnovibra.ITEMCODE,
NameRemark = phydefnovibra.PDNVNAME,
Position = PubFuncs.FindTdPosFromSignal(phydefnovibra.ITEMCODE)
};
Transducers.Add(td);
Log.Inform($"添加非振动传感器({td.NameRemark}): 信号量：{td.Signal} 位置：{td.Position}");
}
}
//还有一枚单独的转速变送器
var speedTd = new SpeedTransducer(Guid);
Transducers.Add(speedTd);
Log.Inform($"添加转速传感器({speedTd.NameRemark}): 信号量：{speedTd.Signal} 位置：{speedTd.Position}");
// var ta = Repo.PhyDefNoVibra.Select(p => p.ITEMCODE).ToList();
Add(Pump);
Add(Motor);
Add(Coupler);
AddRange(Transducers);
#endregion
#region 构建部件间接属性
foreach (DataRow row in PumpSysLib.TableIndirectProperty.Rows)
{
var prop = new Property {
Name = row["PropertyName"].ToString(),
Value = row["DefaultValue"].ToString(),
Variable = row["Variable"].ToString()
};
AllocateProperty(prop, row);
}
//连接点属性是间接属性的一部分,所以也加入
foreach (DataRow row in PumpSysLib.TableConnectorPointProperty.Rows)
{
var prop = new Property {
Name = row["PropertyName"].ToString(),
// Value = row["DefaultValue"].ToString(),
Variable = row["Variable"].ToString()
};
AllocateProperty(prop, row);
}
#endregion
#region 绑定传感器的自带信号量
foreach (var transducer in Transducers)
{
transducer.BindSignal();
}
#endregion
#region 设置振动传感器的图谱的信号量
foreach (var tdv in Transducers.Where(t => t.Type == CompType.Td_V))
{
foreach (var gType in Enum.GetNames(typeof(GraphType)))
{
var prop = tdv.Properties.Find(p => p.Variable == "@" + gType);
prop.Value = PubFuncs.FormatGraphSignal(tdv.Code, (GraphType)Enum.Parse(typeof(GraphType), gType));
}
}
#endregion
#region 根据引用属性，将间接属性的值绑定到信号量
foreach (DataRow row in PumpSysLib.TableRefProperty.Rows)
{
//找到要设置属性值的组件
BaseComponent comp = null;
var cpType = Repo.Map.TypeToEnum[row["TypeName"].ToString()];
switch (cpType)
{
case CompType.Pump:
comp = Pump;
break;
case CompType.Motor:
comp = Motor;
break;
case CompType.Coupler:
comp = Coupler;
break;
}
//找到要设置的属性值
var prop = comp?.Properties.Find(p => p.Variable == row["IndirectVariable"].ToString());
if (prop != null)
{
//先找是哪个类型的传感器
var tdtype = Repo.Map.TypeToEnum[row["RefType"].ToString()];
//再根据位置找到该传感器
var tdpos = (TdPos)Enum.Parse(typeof(TdPos), row["Position"].ToString());
var td = Transducers.Find(t => t.Type == tdtype && t.Position == tdpos);
//再找到传感器上的属性
var rp = td?.Properties.Find(p => p.Variable == row["RefVariable"].ToString());
if (rp != null)
{
prop.Value = rp.Value;
}
}
}
#endregion
#region 根据水泵guid，设置水泵轴承和电机轴承的各自的4个缺陷频率
foreach (var pumpBrInfo in DataDetailsOp.GetPumpBearingInfos(Guid))
{
Pump.Properties.First(p => p.Variable == pumpBrInfo.Key).Value = pumpBrInfo.Value.ToString();
}
foreach (var motorBrInfo in DataDetailsOp.GetMotorBearingInfos(Guid))
{
Motor.Properties.First(p => p.Variable == motorBrInfo.Key).Value = motorBrInfo.Value.ToString();
}
#endregion
#region 根据水泵guid，设置水泵叶片数
Pump.Properties.First(p => p.Variable == "@BladeNum").Value = DataDetailsOp.GetPumpFanCount(Guid).ToString();
#endregion
Log.Inform();
Log.Inform($"--------- 机泵系统{ppGuid} 构建结束---------");
Log.Inform();
}
protected void btnCharge_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtPlayerId.Text.Trim()))
{
ShowCommonDlg("请输入玩家ID！");
return;
}
if (string.IsNullOrEmpty(this.txtDiamondNum.Text.Trim()))
{
ShowCommonDlg("请输入钻石数量！");
return;
}
UsersEO um = umMange.GetUser(GetUserID());
string srcuid = string.Empty;
if (um != null)
{
srcuid = um.UrGameId;
}
string orderNo = PubFuncs.GenerateOrderNumber();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic["action"] = "IDIP_DO_PAY_CASH_REQ";
dic["remark"] = orderNo;//this.txtOrderNo.Text.Trim();
dic["dis_uin"] = this.txtPlayerId.Text.Trim();
dic["src_uin"] = srcuid;
dic["role_name"] = "niuniu";
dic["us_source"] = "2";
dic["amount"] = this.txtDiamondNum.Text.Trim();
dic["ui_ip"] = Common.PubFuncs.GetIpAddress();
dic["gameId"] = "hlynzy";
dic["sz_desc"] = this.txtDesc.Text.Trim();
string json = new JavaScriptSerializer().Serialize(dic);
string responseStr = HttpClientUlity.PostJsonData(serverUrl, json);
JObject jo = (JObject)JsonConvert.DeserializeObject(responseStr);
LogPaymentEO lp = new LogPaymentEO();
if (string.IsNullOrEmpty(this.txtDiamondNum.Text.Trim()))
{
return;
}
if ((Convert.ToInt32(this.txtDiamondNum.Text.Trim()) < 0))
{
ShowCommonDlg("请输入正确钻石数量！");
return;
}
int res = (Int32)jo["paystatus"];
lp.Remarkid = orderNo;
lp.Areaid = "1";
lp.Worldid = "1";
lp.Dstuin = this.txtPlayerId.Text.Trim();
lp.Roleid = "1";
lp.Rolename = "niuniu";
lp.Srcuin = srcuid;
lp.Source = "1";
lp.Amount = this.txtDiamondNum.Text.Trim();
lp.Uiip = Common.PubFuncs.GetIpAddress();
lp.Description = this.txtDesc.Text.Trim();;
if (res == 0)
{
lp.Paystatus = "0";
}
else
{
lp.Paystatus = "1";
}
lp.Paymsg = "Paymsg";
lp.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
lp.FinishTime = DateTime.Now.ToString("yyyy-MM-dd");
this.divAlert.Visible = true;
if (lpMange.addLg(lp) > 0)
{
//UsersEO um = umMange.GetUser(GetUserID());
int subDiamondNum = Convert.ToInt32(this.txtDiamondNum.Text.Trim());
int resNum = Convert.ToInt32(um.UrDiamondNum) - subDiamondNum;
int resUpdate = umMange.PutUrDiamondNumByPK(GetUserID(), resNum.ToString());
if (resUpdate > 0)
{
//this.lblAlert.Text = "充值成功";
ShowCommonDlg("充值成功");
}
else
{
//this.lblAlert.Text = "充值失败";
ShowCommonDlg("充值失败");
}
}
else
{
//this.lblAlert.Text = "充值失败";
ShowCommonDlg("充值失败");
}
}
/// <summary>
/// 验证页面表单合理性
/// </summary>
/// <returns></returns>
private bool CheckForms()
{
bool flg = true;
string strAlert = string.Empty;
if (string.IsNullOrEmpty(this.txtLoginName.Text.Trim()))
{
flg = false;
strAlert = Resources.Resource.Please_enter_a_user_account;// "请输入用户账号";
this.txtLoginName.Focus();
}
else if (string.IsNullOrEmpty(this.txtPass.Text.Trim()) && this.trPass.Visible == true)
{
flg = false;
strAlert = Resources.Resource.Please_enter_a_user_password;// "请输入用户密码";
this.txtPass.Focus();
}
else if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
flg = false;
strAlert = Resources.Resource.Please_enter_user_name;// "请输入用户姓名";
this.txtName.Focus();
}
else if (string.IsNullOrEmpty(this.ddlDepartment.SelectedValue))
{
flg = false;
strAlert = Resources.Resource.Please_select_user_department;//"请选择用户部门";
this.ddlDepartment.Focus();
}
else if (string.IsNullOrEmpty(this.cblRoles.SelectedValue))
{
flg = false;
strAlert = Resources.Resource.Please_select_a_character_name;// "请选择角色名";
}
//((?:(?:25[0-5]|2[0-4]\d|((1\d{2})|([1-9]?\d)))\.){3}(?:25[0-5]|2[0-4]\d|((1\d{2})|([1-9]?\d))));
if (!string.IsNullOrEmpty(txtUserIps.Text.Trim()))
{
#region 进行校验
string[] sArray = this.txtUserIps.Text.Split(',');
foreach (string s in sArray)
{
int resultIp = PubFuncs.ValidateIp(s);
if (resultIp != 0)
{
flg = false;
strAlert = string.Format("Error IP{0} value", s);// "ip格式";
}
}
#endregion
}
if (flg == true)
{
this.divAlert.Visible = false;
}
else
{
this.divAlert.Visible = true;
this.lblAlert.Text = strAlert;
}
return(flg);
}
// public double Speed { get; set; }
/// <summary>
/// 根据机泵运行情况构建的要获取的实时数据的结构
/// </summary>
public RtData()
{
#region 构建【单点数据】的结构，并设置如何映射到Redis中
foreach (var ppGuid in RuntimeRepo.RunningPumpGuids)
{
foreach (var phy in SysConstants.SENSORSETTING.Values)
{
var vibraSignal = $"${phy}_{ppGuid}";
SpData.Add(vibraSignal, default(double));
var sensor = Repo.SensorList.FirstOrDefault(p =>
SysConstants.SENSORSETTING[p.LOCATION + "_" + p.DIRECTION] == phy &&
ppGuid == p.PPGUID);
if (sensor != null)
{
var keyVibra = $"{{{sensor.SSGUID}}}_{SysConstants.VIBRADICT.OverAll}".ToUpper();
RedisKeyMap.Add(keyVibra, vibraSignal);
}
else
{
Log.Warn($"实时数据构建：振动传感器未找到: {phy} ppguid: {ppGuid} (将导致相关判据无法解析)");
}
}
foreach (var phynv in SysConstants.PHYDEF_NONVIBRA)
{
var noVibraSignal = $"${phynv}_{ppGuid}";
SpData.Add(noVibraSignal, default(double));
var sensor = Repo.PhyDefNoVibra.FirstOrDefault(p => p.REMARK == phynv && ppGuid == p.PPGUID);
if (sensor != null)
{
var keyNoVibra = $"{{{ppGuid}}}_{sensor.PDNVCODE}".ToUpper();
RedisKeyMap.Add(keyNoVibra, noVibraSignal);
}
else
{
Log.Warn($"实时数据构建：非振动传感器未找到: {phynv} ppguid: {ppGuid} (将导致相关判据无法解析)");
}
}
var speedSignal = SpeedTransducer.FormatTdSpeedSignal(ppGuid.ToString());
SpData.Add(speedSignal, default(double));
var keySpeed = $"{{{ppGuid}}}_{SysConstants.VIBRADICT.Speed}".ToUpper();
RedisKeyMap.Add(keySpeed, speedSignal);
}
#endregion
#region 构建【振动图谱数据】的结构
int graphNumber = 1;
foreach (var pumpGuid in RuntimeRepo.RunningPumpGuids)
{
foreach (var sensorSetting in SysConstants.SENSORSETTING)
{
var sensor =
Repo.SensorList.FirstOrDefault(
p => p.LOCATION + "_" + p.DIRECTION == sensorSetting.Key && pumpGuid == p.PPGUID);
var pos = FindPosFromSignal(sensorSetting.Value);
Debug.Assert(pos != null, "sensorSetting 传感器位置无法解析");
if (sensor == null)
{
continue;
}
Graphs.Add(new Graph {
Signal = PubFuncs.FormatGraphSignal(sensor.SSGUID.ToString(), GraphType.Spectrum),
Number = graphNumber++,
Pos = pos.Value,
Type = GraphType.Spectrum
});
Graphs.Add(new Graph {
Signal = PubFuncs.FormatGraphSignal(sensor.SSGUID.ToString(), GraphType.TimeWave),
Number = graphNumber++,
Pos = pos.Value,
Type = GraphType.TimeWave
});
}
}
#endregion
}
/// <summary>
/// 绑定日志数据
/// </summary>
private DataTable BindLogs()
{
string STime = txtStartTime.Text.Trim();
string ETime = txtEndTime.Text.Trim();
if (string.IsNullOrEmpty(STime) || string.IsNullOrEmpty(ETime))
{
PubFuncs.ResponseRandomAlert("查询开始时间或者结束时间不能为空", this);
return(null);
}
TimeSpan timespan = (TimeSpan)(DateTime.Parse(ETime) - DateTime.Parse(STime));
if (timespan.Days > 32)
{
PubFuncs.ResponseRandomAlert("查询天数不能大于30天", this);
return(null);
}
else
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1");
IList <MySqlParameter> parm = new List <MySqlParameter>();
//if (!string.IsNullOrEmpty(this.ddlPf.SelectedValue))
//{
// //strWhere.Append(string.Format(" And log.Lg_text2 = '{0}' ", ddlPf.SelectedValue));
// strWhere.Append(" And log.Lg_text2 = @SelectedValue ");
// parm.Add(new MySqlParameter("@SelectedValue", this.ddlPf.SelectedValue));
//}
//else
//{
// if (GetUserLeave() < 90)
// {
// CloseDivImplementation();
// Jswork.Alert("请选择要查询的平台");
// return null;
// }
//}
//if (!string.IsNullOrEmpty(this.txtName.Text.Trim()))
//{
// //strWhere.Append(string.Format(" And log.Lg_name like '%{0}%'",this.txtName.Text.Trim()));
// strWhere.Append(" And log.Lg_name like @Cnname");
// parm.Add(new MySqlParameter("@Cnname", "%" + this.txtName.Text.Trim() + "%"));
//}
if (!string.IsNullOrEmpty(this.txtUrName.Text.Trim()))
{
//strWhere.Append(string.Format(" And users.Ur_name like '%{0}%'",this.txtUrName.Text.Trim()));
strWhere.Append(" And users.Ur_name like @Unname");
parm.Add(new MySqlParameter("@Unname", "%" + this.txtUrName.Text.Trim() + "%"));
}
if (!string.IsNullOrEmpty(this.txtStartTime.Text.Trim()))
{
//strWhere.Append(string.Format(" And log.Lg_addtime >= '{0}'", Convert.ToDateTime(this.txtStartTime.Text.Trim())));
strWhere.Append(" And log.Lg_addtime >= @Lgaddtime");
parm.Add(new MySqlParameter("@Lgaddtime", Convert.ToDateTime(this.txtStartTime.Text.Trim())));
}
if (!string.IsNullOrEmpty(this.txtEndTime.Text.Trim()))
{
//strWhere.Append(string.Format(" And log.Lg_addtime < '{0}'", Convert.ToDateTime(this.txtEndTime.Text.Trim())));
strWhere.Append(" And log.Lg_addtime < @LgEddtime");
parm.Add(new MySqlParameter("@LgEddtime", Convert.ToDateTime(this.txtEndTime.Text.Trim())));
}
//DataTable dt = loPfanage.GetList(strWhere.ToString());
DataTable dt = new NxLogMO().GetTableBySql(strWhere.ToString(), parm);
DataView view = dt.DefaultView;
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
view.Sort = sort;
this.gvLogs.DataSource = view;
this.gvLogs.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
this.divAlert.Visible = true;
this.lblAlert.Text = "一共：" + view.Count.ToString() + "数据";
this.btnExport.Enabled = true;
}
else
{
this.divAlert.Visible = false;
this.btnExport.Enabled = false;
}
return(dt);
}
}
