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