public WeiXinUtil(string sourceId) { WEC_PUBLICLIST conf = new WEC_PUBLICLIST(); conf.PLC_SOURCEID = sourceId; this.wx_publiclist = BLLTable <WEC_PUBLICLIST> .GetRowData(new WEC_PUBLICLIST(), conf); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_PUBLICLIST>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_PUBLICLIST>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_PUBLICLIST>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { string result = ""; string username = HttpUtil.GetReqStrValue("username"); string password = HttpUtil.GetReqStrValue("password"); string imgVerify = HttpUtil.GetReqStrValue("imgVerify"); string num = Convert.ToString(Request["num"]); string num2 = HttpUtil.GetReqStrValue("num"); string serverFilePath = @"E:\AppInOne_Solution\Site\UploadFiles\WecHeader"; WEC_PUBLICLIST wec1 = new WEC_PUBLICLIST(); try { TestCase.IServiceChannel iService = ChannelFactory <TestCase.IServiceChannel> .CreateChannel(new NetTcpBinding(SecurityMode.None), new EndpointAddress("net.tcp://localhost:8081/TestCase.WecService")); iService.OperationTimeout = new TimeSpan(1, 0, 5); iService.Open(new TimeSpan(0, 0, 10)); if ("1".Equals(num)) { result = iService.wecAddUser(username, password, imgVerify, serverFilePath); } else { result = iService.getStatus(username, password, ref wec1); // if (wec1._PLC_SOURCEID != null) { WEC_PUBLICLIST cond1 = new WEC_PUBLICLIST(); cond1._PLC_SOURCEID = wec1._PLC_SOURCEID; if (wec1.APPID != null) { cond1.APPID = wec1.APPID; } if (wec1.APPSESECRET != null) { cond1.APPSESECRET = wec1.APPSESECRET; } if (wec1.IsNotNull() && cond1.IsNotNull()) { if (BLLTable <WEC_PUBLICLIST> .Factory(conn).Exists(cond1)) { //BLLTable<WEC_PUBLICLIST>.Factory(conn).Update(wec1, cond1); } else { BLLTable <WEC_PUBLICLIST> .Factory(conn).Insert(wec1, WEC_PUBLICLIST.Attribute.AID); } } } } Response.Write("{\"result\":\"" + result + "\"}"); }catch (Exception ee) { Response.Write("{\"result\":\"绑定出错\"}"); } }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(WEC_PUBLICLIST.Attribute.EXP1); //hideTableColumnList.Add(WEC_PUBLICLIST.Attribute.EXP2); //hideTableColumnList.Add(WEC_PUBLICLIST.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(WEC_PUBLICLIST.Attribute.EXP1); //hideFindColumnList.Add(WEC_PUBLICLIST.Attribute.EXP2); //hideFindColumnList.Add(WEC_PUBLICLIST.Attribute.EXP3); #endregion condObj.OrderBy(WEC_PUBLICLIST.Attribute.AID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { WEC_PUBLICLIST roleOld = new WEC_PUBLICLIST(); roleOld.Where(WEC_PUBLICLIST.Attribute.AID, Request["ids"].ToString()); listObj = BLLTable <WEC_PUBLICLIST> .Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].AID + "',Name:'" + listObj[i].AID + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].AID; } } try { listObj = BLLTable <WEC_PUBLICLIST> .SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelAID"] != null) { int re = BLLTable <WEC_PUBLICLIST> .Delete(WEC_PUBLICLIST.Attribute.AID, Request["DelAID"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { WEC_PUBLICLIST cond = new WEC_PUBLICLIST(); cond.In(WEC_PUBLICLIST.Attribute.AID, Request["DelKeyIDS"]); int re = BLLTable <WEC_PUBLICLIST> .Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { WEC_PUBLICLIST val = new WEC_PUBLICLIST(); val.AID = int.Parse(Request["FieldKeyID"]); List <AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]); } } BLLTable <WEC_PUBLICLIST> .Update(val, WEC_PUBLICLIST.Attribute.AID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelAID"] != null) { int re = BLLTable<WEC_PUBLICLIST>.Delete(WEC_PUBLICLIST.Attribute.AID, Request["DelAID"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { WEC_PUBLICLIST cond = new WEC_PUBLICLIST(); cond.In(WEC_PUBLICLIST.Attribute.AID, Request["DelKeyIDS"]); int re = BLLTable<WEC_PUBLICLIST>.Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { WEC_PUBLICLIST val = new WEC_PUBLICLIST(); val.AID = int.Parse(Request["FieldKeyID"]); List<AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]); } } BLLTable<WEC_PUBLICLIST>.Update(val, WEC_PUBLICLIST.Attribute.AID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { string result = ""; string username = HttpUtil.GetReqStrValue("username"); string password = HttpUtil.GetReqStrValue("password"); string imgVerify = HttpUtil.GetReqStrValue("imgVerify"); string num = Convert.ToString(Request["num"]); string num2 = HttpUtil.GetReqStrValue("num"); string serverFilePath = @"E:\AppInOne_Solution\Site\UploadFiles\WecHeader"; WEC_PUBLICLIST wec1 = new WEC_PUBLICLIST(); try { TestCase.IServiceChannel iService = ChannelFactory<TestCase.IServiceChannel>.CreateChannel(new NetTcpBinding(SecurityMode.None), new EndpointAddress("net.tcp://localhost:8081/TestCase.WecService")); iService.OperationTimeout = new TimeSpan(1, 0, 5); iService.Open(new TimeSpan(0, 0, 10)); if ("1".Equals(num)) { result = iService.wecAddUser(username, password, imgVerify, serverFilePath); } else { result = iService.getStatus(username, password, ref wec1); // if(wec1._PLC_SOURCEID!=null) { WEC_PUBLICLIST cond1 = new WEC_PUBLICLIST(); cond1._PLC_SOURCEID = wec1._PLC_SOURCEID; if (wec1.APPID != null) cond1.APPID = wec1.APPID; if (wec1.APPSESECRET != null) cond1.APPSESECRET = wec1.APPSESECRET; if (wec1.IsNotNull() && cond1.IsNotNull()) { if (BLLTable<WEC_PUBLICLIST>.Factory(conn).Exists(cond1)) { //BLLTable<WEC_PUBLICLIST>.Factory(conn).Update(wec1, cond1); } else { BLLTable<WEC_PUBLICLIST>.Factory(conn).Insert(wec1, WEC_PUBLICLIST.Attribute.AID); } } } } Response.Write("{\"result\":\"" + result + "\"}"); }catch(Exception ee){ Response.Write("{\"result\":\"绑定出错\"}"); } }
/// <summary> /// 保存用户信息 /// ygh 2014/3/16 /// </summary> /// <param name="openid"></param> /// <param name="type"></param> /// <param name="content"></param> /// <param name="channelid"></param> public void saveUserMessage(string openid, int type, string content, int channelid, string toUserName) { string access_token = HttpUtil.getAccessToken(this.APPID, this.APPSECRET); string user_info = HttpUtil.httpForm("", "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + access_token + "&openid=" + openid + "&lang=zh_CN", "GET"); JavaScriptSerializer jss = new JavaScriptSerializer(); Dictionary <string, object> map = (Dictionary <string, object>)jss.DeserializeObject(user_info); WEC_XX_MESSAGE message = new WEC_XX_MESSAGE(); message.OPENID = openid; message.TYPE = type; WEC_PUBLICLIST conf = new WEC_PUBLICLIST(); conf.PLC_SOURCEID = toUserName; WEC_PUBLICLIST publiclist = BLLTable <WEC_PUBLICLIST> .GetRowData(new WEC_PUBLICLIST(), conf); message.AID = publiclist.AID;//公众号编号, message.ADDTIME = DateTime.Now; if (type != 1) { if (map.ContainsKey("province")) { message.PROVINCE = (string)map["province"]; message.CITY = (string)map["city"]; message.COUNTRY = (string)map["country"]; message.HEADIMGURL = (string)map["headimgurl"]; message.CHANNELID = channelid; } } if (type == 2 || type == 3) { message.S_CONTENT = content; WEC_WZ_LOCATION conf2 = new WEC_WZ_LOCATION(); conf2.OPENID = openid; conf2.af_WhereSQL = " ORDER BY ADDTIME"; WEC_WZ_LOCATION location = BLLTable <WEC_WZ_LOCATION> .GetRowData(new WEC_WZ_LOCATION(), conf2); if (location != null) { message.LATITUDE = location.LATITUDE; message.LONGITUDE = location.LONGITUDE; message.PRECISION = location.PRECISION; message.CHANNELID = channelid; } } BLLTable <WEC_XX_MESSAGE> .Insert(message, WEC_XX_MESSAGE.Attribute.ID); }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_PUBLICLIST>(hidCondition.Value); } listObj = BLLTable <WEC_PUBLICLIST> .SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_PUBLICLIST>(hidCondition.Value); } listObj = BLLTable<WEC_PUBLICLIST>.SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
private void BindList(WEC_PUBLICLIST condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(WEC_PUBLICLIST.Attribute.AID, Order.Desc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable <WEC_PUBLICLIST> .SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
/// <summary> /// 当用户发送信息或者订阅时保存用户信息 /// ygh 2014/4/24 /// </summary> /// <param name="openid"></param> /// <param name="type"></param> public void saveUser(string openid, int type, int channelid, string toUserName) { string access_token = HttpUtil.getAccessToken(this.APPID, this.APPSECRET); string user_info = HttpUtil.httpForm("", "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + access_token + "&openid=" + openid + "&lang=zh_CN", "GET"); JavaScriptSerializer jss = new JavaScriptSerializer(); Dictionary <string, object> map = (Dictionary <string, object>)jss.DeserializeObject(user_info); WEC_U_USER user = new WEC_U_USER(); WEC_PUBLICLIST conf = new WEC_PUBLICLIST(); conf.PLC_SOURCEID = toUserName; WEC_PUBLICLIST publiclist = BLLTable <WEC_PUBLICLIST> .GetRowData(new WEC_PUBLICLIST(), conf); user.AID = publiclist.AID;//用户所订阅公众号ID user.OPENID = openid; //如果公众号没有访问用户信息的借口的权限则报错,则不包含以下键值 if (map.ContainsKey("nickname")) { user.USERNAME = (string)map["nickname"]; int sex = (int)map["sex"]; if (sex == 0) { user.SEX = "未知"; } else if (sex == 1) { user.SEX = "男"; } else if (sex == 2) { user.SEX = "女"; } user.ADDTIME = GetTime(map["subscribe_time"] + ""); } if (!isExist(user)) { BLLTable <WEC_U_USER> .Insert(user, WEC_U_USER.Attribute.ID); } else { BLLTable <WEC_U_USER> .Update(user, WEC_U_USER.Attribute.ID); } saveUserMessage(openid, type, "", channelid, toUserName); }
protected void Page_Load(object sender, EventArgs e) { String aid = HttpUtil.GetReqStrValue("aid"); if (string.IsNullOrEmpty(aid)) { //从数据库获取第一个aid WEC_PUBLICLIST val = new WEC_PUBLICLIST(); WEC_PUBLICLIST conf = new WEC_PUBLICLIST(); conf.USER_ID = userBase.UserID; WEC_PUBLICLIST data1 = BLLTable<WEC_PUBLICLIST>.GetRowData(val, conf); if (data1 != null && data1.IsNotNull()) { aid = data1.AID.ToString(); } } if (string.IsNullOrEmpty(aid)) { aid = "1"; } this.Server.Transfer("Index.aspx?appid=2&aid=" + aid, true); return; }
protected void Page_Load(object sender, EventArgs e) { String aid = HttpUtil.GetReqStrValue("aid"); if (string.IsNullOrEmpty(aid)) { //从数据库获取第一个aid WEC_PUBLICLIST val = new WEC_PUBLICLIST(); WEC_PUBLICLIST conf = new WEC_PUBLICLIST(); conf.USER_ID = userBase.UserID; WEC_PUBLICLIST data1 = BLLTable <WEC_PUBLICLIST> .GetRowData(val, conf); if (data1 != null && data1.IsNotNull()) { aid = data1.AID.ToString(); } } if (string.IsNullOrEmpty(aid)) { aid = "1"; } this.Server.Transfer("Index.aspx?appid=2&aid=" + aid, true); return; }
protected void btnOK_Click(object sender, EventArgs e) { try { WEC_PUBLICLIST valObj = new WEC_PUBLICLIST(); if (txtAID.Value != "") { valObj.AID = Convert.ToDecimal(txtAID.Value); } if (txtUSER_ID.Value != "") { valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value); } if (txtPLC_NAME.Value != "") { valObj.PLC_NAME = Convert.ToString(txtPLC_NAME.Value); } if (txtPLC_SOURCEID.Value != "") { valObj.PLC_SOURCEID = Convert.ToString(txtPLC_SOURCEID.Value); } if (txtWECHAT_ID.Value != "") { valObj.WECHAT_ID = Convert.ToString(txtWECHAT_ID.Value); } if (txtAVATAR_URL.Value != "") { valObj.AVATAR_URL = Convert.ToString(txtAVATAR_URL.Value); } if (txtAPI_KEY.Value != "") { valObj.API_KEY = Convert.ToString(txtAPI_KEY.Value); } if (txtTOKEN.Value != "") { valObj.TOKEN = Convert.ToString(txtTOKEN.Value); } if (txtLOCATION.Value != "") { valObj.LOCATION = Convert.ToString(txtLOCATION.Value); } if (txtEMAIL.Value != "") { valObj.EMAIL = Convert.ToString(txtEMAIL.Value); } if (txtFUNS.Value != "") { valObj.FUNS = Convert.ToInt32(txtFUNS.Value); } if (txtTYPE.Value != "") { valObj.TYPE = Convert.ToInt32(txtTYPE.Value); } if (txtSTART_DAY.Value != "") { valObj.START_DAY = Convert.ToDateTime(txtSTART_DAY.Value); } if (txtEND_DAY.Value != "") { valObj.END_DAY = Convert.ToDateTime(txtEND_DAY.Value); } if (txtSTATUS.Value != "") { valObj.STATUS = Convert.ToInt32(txtSTATUS.Value); } if (txtPACKAGE_ID.Value != "") { valObj.PACKAGE_ID = Convert.ToDecimal(txtPACKAGE_ID.Value); } if (txtIS_NEWS.Value != "") { valObj.IS_NEWS = Convert.ToInt32(txtIS_NEWS.Value); } if (txtDEFAULT_REPLAY.Value != "") { valObj.DEFAULT_REPLAY = Convert.ToString(txtDEFAULT_REPLAY.Value); } if (txtDEFAULT_REPLAY_FALG.Value != "") { valObj.DEFAULT_REPLAY_FALG = Convert.ToInt32(txtDEFAULT_REPLAY_FALG.Value); } if (txtLBS_DISTANCE.Value != "") { valObj.LBS_DISTANCE = Convert.ToDecimal(txtLBS_DISTANCE.Value); } if (txtAPPID.Value != "") { valObj.APPID = Convert.ToString(txtAPPID.Value); } if (txtAPPSESECRET.Value != "") { valObj.APPSESECRET = Convert.ToString(txtAPPSESECRET.Value); } if (keyid != "") { valObj.AID = Convert.ToDecimal(keyid); count = BLLTable <WEC_PUBLICLIST> .Update(valObj, WEC_PUBLICLIST.Attribute.AID); } else { count = BLLTable <WEC_PUBLICLIST> .Insert(valObj, WEC_PUBLICLIST.Attribute.AID); keyid = valObj.AID.ToString(); } if (count > 0) { StringBuilder sbData = new StringBuilder("{valObj:''"); List <AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valObj.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } sbData.Append("}"); if (ViewState["sbData"] == null) { ViewState["sbData"] = sbData.ToString(); } else { ViewState["sbData"] += "," + sbData.ToString(); } Button btn = (Button)sender; if (btn.ID.IndexOf("btnOK") != -1) { if (ViewState["sbData"] == null) { string dataStr = "[" + ViewState["sbData"].ToString() + "]"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "window.returnValue=\"" + dataStr + "\";window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "window.returnValue=\"re\";window.close();", true); } } else { txtAID.Value = ""; txtUSER_ID.Value = ""; txtPLC_NAME.Value = ""; txtPLC_SOURCEID.Value = ""; txtWECHAT_ID.Value = ""; txtAVATAR_URL.Value = ""; txtAPI_KEY.Value = ""; txtTOKEN.Value = ""; txtLOCATION.Value = ""; txtEMAIL.Value = ""; txtFUNS.Value = ""; txtTYPE.Value = ""; txtSTART_DAY.Value = ""; txtEND_DAY.Value = ""; txtSTATUS.Value = ""; txtPACKAGE_ID.Value = ""; txtIS_NEWS.Value = ""; txtDEFAULT_REPLAY.Value = ""; txtDEFAULT_REPLAY_FALG.Value = ""; txtLBS_DISTANCE.Value = ""; txtAPPID.Value = ""; txtAPPSESECRET.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["AID"])) { valObj = BLLTable<WEC_PUBLICLIST>.GetRowData(WEC_PUBLICLIST.Attribute.AID, Request["AID"]); if(valObj==null) return ; txtAID.Text = Convert.ToString(valObj.AID);//Convert.ToDecimal txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtPLC_NAME.Text = Convert.ToString(valObj.PLC_NAME);//Convert.ToString txtPLC_SOURCEID.Text = Convert.ToString(valObj.PLC_SOURCEID);//Convert.ToString txtWECHAT_ID.Text = Convert.ToString(valObj.WECHAT_ID);//Convert.ToString txtAVATAR_URL.Text = Convert.ToString(valObj.AVATAR_URL);//Convert.ToString txtAPI_KEY.Text = Convert.ToString(valObj.API_KEY);//Convert.ToString txtTOKEN.Text = Convert.ToString(valObj.TOKEN);//Convert.ToString txtLOCATION.Text = Convert.ToString(valObj.LOCATION);//Convert.ToString txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString txtFUNS.Text = Convert.ToString(valObj.FUNS);//Convert.ToInt32 txtTYPE.Text = Convert.ToString(valObj.TYPE);//Convert.ToInt32 txtSTART_DAY.Text = (valObj.START_DAY == DateTime.MinValue) ? "" : valObj.START_DAY.ToString("yyyy-MM-dd HH:mm"); txtEND_DAY.Text = (valObj.END_DAY == DateTime.MinValue) ? "" : valObj.END_DAY.ToString("yyyy-MM-dd HH:mm"); txtSTATUS.Text = Convert.ToString(valObj.STATUS);//Convert.ToInt32 txtPACKAGE_ID.Text = Convert.ToString(valObj.PACKAGE_ID);//Convert.ToDecimal txtIS_NEWS.Text=valObj.IS_NEWS.ToString(); txtDEFAULT_REPLAY.Text = Convert.ToString(valObj.DEFAULT_REPLAY);//Convert.ToString txtDEFAULT_REPLAY_FALG.Text=valObj.DEFAULT_REPLAY_FALG.ToString(); txtLBS_DISTANCE.Text = Convert.ToString(valObj.LBS_DISTANCE);//Convert.ToDecimal txtAPPID.Text = Convert.ToString(valObj.APPID);//Convert.ToString txtAPPSESECRET.Text = Convert.ToString(valObj.APPSESECRET);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//���������Ϊ�������� //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_PUBLICLIST(); if(txtAID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.AID, Convert.ToDecimal(txtAID.Value)); if(txtUSER_ID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value)); if(txtPLC_NAME.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.PLC_NAME, Convert.ToString(txtPLC_NAME.Value)); if(txtPLC_SOURCEID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.PLC_SOURCEID, Convert.ToString(txtPLC_SOURCEID.Value)); if(txtWECHAT_ID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.WECHAT_ID, Convert.ToString(txtWECHAT_ID.Value)); if(txtAVATAR_URL.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.AVATAR_URL, Convert.ToString(txtAVATAR_URL.Value)); if(txtAPI_KEY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.API_KEY, Convert.ToString(txtAPI_KEY.Value)); if(txtTOKEN.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.TOKEN, Convert.ToString(txtTOKEN.Value)); if(txtLOCATION.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.LOCATION, Convert.ToString(txtLOCATION.Value)); if(txtEMAIL.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value)); if(txtFUNS.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.FUNS, Convert.ToInt32(txtFUNS.Value)); if(txtTYPE.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.TYPE, Convert.ToInt32(txtTYPE.Value)); if(txtSTART_DAY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.START_DAY, Convert.ToDateTime(txtSTART_DAY.Value)); if(txtEND_DAY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.END_DAY, Convert.ToDateTime(txtEND_DAY.Value)); if(txtSTATUS.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.STATUS, Convert.ToInt32(txtSTATUS.Value)); if(txtPACKAGE_ID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.PACKAGE_ID, Convert.ToDecimal(txtPACKAGE_ID.Value)); if(txtIS_NEWS.Value !="" ) condObj.IS_NEWS = Convert.ToInt32(txtIS_NEWS.Value); if(txtDEFAULT_REPLAY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.DEFAULT_REPLAY, Convert.ToString(txtDEFAULT_REPLAY.Value)); if(txtDEFAULT_REPLAY_FALG.Value !="" ) condObj.DEFAULT_REPLAY_FALG = Convert.ToInt32(txtDEFAULT_REPLAY_FALG.Value); if(txtLBS_DISTANCE.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.LBS_DISTANCE, Convert.ToDecimal(txtLBS_DISTANCE.Value)); if(txtAPPID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.APPID, Convert.ToString(txtAPPID.Value)); if(txtAPPSESECRET.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.APPSESECRET, Convert.ToString(txtAPPSESECRET.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_PUBLICLIST(); if (txtAID.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.AID, Convert.ToDecimal(txtAID.Value)); } if (txtUSER_ID.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value)); } if (txtPLC_NAME.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.PLC_NAME, Convert.ToString(txtPLC_NAME.Value)); } if (txtPLC_SOURCEID.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.PLC_SOURCEID, Convert.ToString(txtPLC_SOURCEID.Value)); } if (txtWECHAT_ID.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.WECHAT_ID, Convert.ToString(txtWECHAT_ID.Value)); } if (txtAVATAR_URL.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.AVATAR_URL, Convert.ToString(txtAVATAR_URL.Value)); } if (txtAPI_KEY.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.API_KEY, Convert.ToString(txtAPI_KEY.Value)); } if (txtTOKEN.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.TOKEN, Convert.ToString(txtTOKEN.Value)); } if (txtLOCATION.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.LOCATION, Convert.ToString(txtLOCATION.Value)); } if (txtEMAIL.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value)); } if (txtFUNS.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.FUNS, Convert.ToInt32(txtFUNS.Value)); } if (txtTYPE.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.TYPE, Convert.ToInt32(txtTYPE.Value)); } if (txtSTART_DAY.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.START_DAY, Convert.ToDateTime(txtSTART_DAY.Value)); } if (txtEND_DAY.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.END_DAY, Convert.ToDateTime(txtEND_DAY.Value)); } if (txtSTATUS.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.STATUS, Convert.ToInt32(txtSTATUS.Value)); } if (txtPACKAGE_ID.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.PACKAGE_ID, Convert.ToDecimal(txtPACKAGE_ID.Value)); } if (txtIS_NEWS.Value != "") { condObj.IS_NEWS = Convert.ToInt32(txtIS_NEWS.Value); } if (txtDEFAULT_REPLAY.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.DEFAULT_REPLAY, Convert.ToString(txtDEFAULT_REPLAY.Value)); } if (txtDEFAULT_REPLAY_FALG.Value != "") { condObj.DEFAULT_REPLAY_FALG = Convert.ToInt32(txtDEFAULT_REPLAY_FALG.Value); } if (txtLBS_DISTANCE.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.LBS_DISTANCE, Convert.ToDecimal(txtLBS_DISTANCE.Value)); } if (txtAPPID.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.APPID, Convert.ToString(txtAPPID.Value)); } if (txtAPPSESECRET.Value != "") { condObj.Like(WEC_PUBLICLIST.Attribute.APPSESECRET, Convert.ToString(txtAPPSESECRET.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
private void BindList(WEC_PUBLICLIST condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(WEC_PUBLICLIST.Attribute.AID, Order.Desc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable<WEC_PUBLICLIST>.SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_PUBLICLIST>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnOK_Click(object sender, EventArgs e) { try { WEC_PUBLICLIST valObj = new WEC_PUBLICLIST(); if(txtAID.Value !="" ) valObj.AID = Convert.ToDecimal(txtAID.Value); if(txtUSER_ID.Value !="" ) valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value); if(txtPLC_NAME.Value !="" ) valObj.PLC_NAME = Convert.ToString(txtPLC_NAME.Value); if(txtPLC_SOURCEID.Value !="" ) valObj.PLC_SOURCEID = Convert.ToString(txtPLC_SOURCEID.Value); if(txtWECHAT_ID.Value !="" ) valObj.WECHAT_ID = Convert.ToString(txtWECHAT_ID.Value); if(txtAVATAR_URL.Value !="" ) valObj.AVATAR_URL = Convert.ToString(txtAVATAR_URL.Value); if(txtAPI_KEY.Value !="" ) valObj.API_KEY = Convert.ToString(txtAPI_KEY.Value); if(txtTOKEN.Value !="" ) valObj.TOKEN = Convert.ToString(txtTOKEN.Value); if(txtLOCATION.Value !="" ) valObj.LOCATION = Convert.ToString(txtLOCATION.Value); if(txtEMAIL.Value !="" ) valObj.EMAIL = Convert.ToString(txtEMAIL.Value); if(txtFUNS.Value !="" ) valObj.FUNS = Convert.ToInt32(txtFUNS.Value); if(txtTYPE.Value !="" ) valObj.TYPE = Convert.ToInt32(txtTYPE.Value); if(txtSTART_DAY.Value !="" ) valObj.START_DAY = Convert.ToDateTime(txtSTART_DAY.Value); if(txtEND_DAY.Value !="" ) valObj.END_DAY = Convert.ToDateTime(txtEND_DAY.Value); if(txtSTATUS.Value !="" ) valObj.STATUS = Convert.ToInt32(txtSTATUS.Value); if(txtPACKAGE_ID.Value !="" ) valObj.PACKAGE_ID = Convert.ToDecimal(txtPACKAGE_ID.Value); if(txtIS_NEWS.Value !="" ) valObj.IS_NEWS = Convert.ToInt32(txtIS_NEWS.Value); if(txtDEFAULT_REPLAY.Value !="" ) valObj.DEFAULT_REPLAY = Convert.ToString(txtDEFAULT_REPLAY.Value); if(txtDEFAULT_REPLAY_FALG.Value !="" ) valObj.DEFAULT_REPLAY_FALG = Convert.ToInt32(txtDEFAULT_REPLAY_FALG.Value); if(txtLBS_DISTANCE.Value !="" ) valObj.LBS_DISTANCE = Convert.ToDecimal(txtLBS_DISTANCE.Value); if(txtAPPID.Value !="" ) valObj.APPID = Convert.ToString(txtAPPID.Value); if(txtAPPSESECRET.Value !="" ) valObj.APPSESECRET = Convert.ToString(txtAPPSESECRET.Value); if (keyid != "") { valObj.AID = Convert.ToDecimal(keyid); count = BLLTable<WEC_PUBLICLIST>.Update(valObj, WEC_PUBLICLIST.Attribute.AID); } else { count = BLLTable<WEC_PUBLICLIST>.Insert(valObj, WEC_PUBLICLIST.Attribute.AID); keyid = valObj.AID.ToString(); } if (count > 0) { StringBuilder sbData = new StringBuilder("{valObj:''"); List<AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valObj.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } sbData.Append("}"); if (ViewState["sbData"] == null) { ViewState["sbData"] = sbData.ToString(); } else { ViewState["sbData"] += ","+sbData.ToString(); } Button btn = (Button)sender; if (btn.ID.IndexOf("btnOK")!=-1) { if (ViewState["sbData"] == null) { string dataStr = "[" + ViewState["sbData"] .ToString()+ "]"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "window.returnValue=\"" + dataStr + "\";window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "window.returnValue=\"re\";window.close();", true); } } else { txtAID.Value =""; txtUSER_ID.Value =""; txtPLC_NAME.Value =""; txtPLC_SOURCEID.Value =""; txtWECHAT_ID.Value =""; txtAVATAR_URL.Value =""; txtAPI_KEY.Value =""; txtTOKEN.Value =""; txtLOCATION.Value =""; txtEMAIL.Value =""; txtFUNS.Value =""; txtTYPE.Value =""; txtSTART_DAY.Value =""; txtEND_DAY.Value =""; txtSTATUS.Value =""; txtPACKAGE_ID.Value =""; txtIS_NEWS.Value =""; txtDEFAULT_REPLAY.Value =""; txtDEFAULT_REPLAY_FALG.Value =""; txtLBS_DISTANCE.Value =""; txtAPPID.Value =""; txtAPPSESECRET.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["AID"])) { keyid = Request["AID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtSTART_DAY.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtEND_DAY.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtIS_NEWS.Items.AddRange(FormHelper.GetListItem(WEC_PUBLICLIST.Attribute.IS_NEWS)); txtDEFAULT_REPLAY_FALG.Items.AddRange(FormHelper.GetListItem(WEC_PUBLICLIST.Attribute.DEFAULT_REPLAY_FALG)); this.txtAID.Disabled = true; this.txtAID.Value = "0"; this.txtAID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable<WEC_PUBLICLIST>.GetRowData(WEC_PUBLICLIST.Attribute.AID, keyid); if (valObj == null) return; txtAID.Value = Convert.ToString(valObj.AID);//Convert.ToDecimal txtUSER_ID.Value = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtPLC_NAME.Value = Convert.ToString(valObj.PLC_NAME);//Convert.ToString txtPLC_SOURCEID.Value = Convert.ToString(valObj.PLC_SOURCEID);//Convert.ToString txtWECHAT_ID.Value = Convert.ToString(valObj.WECHAT_ID);//Convert.ToString txtAVATAR_URL.Value = Convert.ToString(valObj.AVATAR_URL);//Convert.ToString txtAPI_KEY.Value = Convert.ToString(valObj.API_KEY);//Convert.ToString txtTOKEN.Value = Convert.ToString(valObj.TOKEN);//Convert.ToString txtLOCATION.Value = Convert.ToString(valObj.LOCATION);//Convert.ToString txtEMAIL.Value = Convert.ToString(valObj.EMAIL);//Convert.ToString txtFUNS.Value = Convert.ToString(valObj.FUNS);//Convert.ToInt32 txtTYPE.Value = Convert.ToString(valObj.TYPE);//Convert.ToInt32 txtSTART_DAY.Value = (valObj.START_DAY == DateTime.MinValue) ? "" : valObj.START_DAY.ToString("yyyy-MM-dd"); txtEND_DAY.Value = (valObj.END_DAY == DateTime.MinValue) ? "" : valObj.END_DAY.ToString("yyyy-MM-dd"); txtSTATUS.Value = Convert.ToString(valObj.STATUS);//Convert.ToInt32 txtPACKAGE_ID.Value = Convert.ToString(valObj.PACKAGE_ID);//Convert.ToDecimal txtIS_NEWS.Value = valObj.IS_NEWS.ToString(); txtDEFAULT_REPLAY.Value = Convert.ToString(valObj.DEFAULT_REPLAY);//Convert.ToString txtDEFAULT_REPLAY_FALG.Value = valObj.DEFAULT_REPLAY_FALG.ToString(); txtLBS_DISTANCE.Value = Convert.ToString(valObj.LBS_DISTANCE);//Convert.ToDecimal txtAPPID.Value = Convert.ToString(valObj.APPID);//Convert.ToString txtAPPSESECRET.Value = Convert.ToString(valObj.APPSESECRET);//Convert.ToString } else { txtUSER_ID.Value = Convert.ToString(userBase.UserID); } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new WEC_PUBLICLIST(); if(txtAID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.AID, Convert.ToDecimal(txtAID.Value)); if(txtUSER_ID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value)); if(txtPLC_NAME.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.PLC_NAME, Convert.ToString(txtPLC_NAME.Value)); if(txtPLC_SOURCEID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.PLC_SOURCEID, Convert.ToString(txtPLC_SOURCEID.Value)); if(txtWECHAT_ID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.WECHAT_ID, Convert.ToString(txtWECHAT_ID.Value)); if(txtAVATAR_URL.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.AVATAR_URL, Convert.ToString(txtAVATAR_URL.Value)); if(txtAPI_KEY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.API_KEY, Convert.ToString(txtAPI_KEY.Value)); if(txtTOKEN.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.TOKEN, Convert.ToString(txtTOKEN.Value)); if(txtLOCATION.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.LOCATION, Convert.ToString(txtLOCATION.Value)); if(txtEMAIL.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value)); if(txtFUNS.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.FUNS, Convert.ToInt32(txtFUNS.Value)); if(txtTYPE.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.TYPE, Convert.ToInt32(txtTYPE.Value)); if(txtSTART_DAY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.START_DAY, Convert.ToDateTime(txtSTART_DAY.Value)); if(txtEND_DAY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.END_DAY, Convert.ToDateTime(txtEND_DAY.Value)); if(txtSTATUS.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.STATUS, Convert.ToInt32(txtSTATUS.Value)); if(txtPACKAGE_ID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.PACKAGE_ID, Convert.ToDecimal(txtPACKAGE_ID.Value)); if(txtIS_NEWS.Value !="" ) condObj.IS_NEWS = Convert.ToInt32(txtIS_NEWS.Value); if(txtDEFAULT_REPLAY.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.DEFAULT_REPLAY, Convert.ToString(txtDEFAULT_REPLAY.Value)); if(txtDEFAULT_REPLAY_FALG.Value !="" ) condObj.DEFAULT_REPLAY_FALG = Convert.ToInt32(txtDEFAULT_REPLAY_FALG.Value); if(txtLBS_DISTANCE.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.LBS_DISTANCE, Convert.ToDecimal(txtLBS_DISTANCE.Value)); if(txtAPPID.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.APPID, Convert.ToString(txtAPPID.Value)); if(txtAPPSESECRET.Value !="" ) condObj.Like(WEC_PUBLICLIST.Attribute.APPSESECRET, Convert.ToString(txtAPPSESECRET.Value)); listObj = BLLTable<WEC_PUBLICLIST>.SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; }
protected void Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(WEC_PUBLICLIST.Attribute.EXP1); //hideTableColumnList.Add(WEC_PUBLICLIST.Attribute.EXP2); //hideTableColumnList.Add(WEC_PUBLICLIST.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(WEC_PUBLICLIST.Attribute.EXP1); //hideFindColumnList.Add(WEC_PUBLICLIST.Attribute.EXP2); //hideFindColumnList.Add(WEC_PUBLICLIST.Attribute.EXP3); #endregion condObj.OrderBy(WEC_PUBLICLIST.Attribute.AID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { WEC_PUBLICLIST roleOld = new WEC_PUBLICLIST(); roleOld.Where(WEC_PUBLICLIST.Attribute.AID, Request["ids"].ToString()); listObj = BLLTable<WEC_PUBLICLIST>.Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].AID + "',Name:'" + listObj[i].AID + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].AID; } } try { listObj = BLLTable<WEC_PUBLICLIST>.SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["AID"])) { valObj = BLLTable <WEC_PUBLICLIST> .GetRowData(WEC_PUBLICLIST.Attribute.AID, Request["AID"]); if (valObj == null) { return; } txtAID.Text = Convert.ToString(valObj.AID);//Convert.ToDecimal txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtPLC_NAME.Text = Convert.ToString(valObj.PLC_NAME);//Convert.ToString txtPLC_SOURCEID.Text = Convert.ToString(valObj.PLC_SOURCEID);//Convert.ToString txtWECHAT_ID.Text = Convert.ToString(valObj.WECHAT_ID);//Convert.ToString txtAVATAR_URL.Text = Convert.ToString(valObj.AVATAR_URL);//Convert.ToString txtAPI_KEY.Text = Convert.ToString(valObj.API_KEY);//Convert.ToString txtTOKEN.Text = Convert.ToString(valObj.TOKEN);//Convert.ToString txtLOCATION.Text = Convert.ToString(valObj.LOCATION);//Convert.ToString txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString txtFUNS.Text = Convert.ToString(valObj.FUNS);//Convert.ToInt32 txtTYPE.Text = Convert.ToString(valObj.TYPE);//Convert.ToInt32 txtSTART_DAY.Text = (valObj.START_DAY == DateTime.MinValue) ? "" : valObj.START_DAY.ToString("yyyy-MM-dd HH:mm"); txtEND_DAY.Text = (valObj.END_DAY == DateTime.MinValue) ? "" : valObj.END_DAY.ToString("yyyy-MM-dd HH:mm"); txtSTATUS.Text = Convert.ToString(valObj.STATUS);//Convert.ToInt32 txtPACKAGE_ID.Text = Convert.ToString(valObj.PACKAGE_ID);//Convert.ToDecimal txtIS_NEWS.Text = valObj.IS_NEWS.ToString(); txtDEFAULT_REPLAY.Text = Convert.ToString(valObj.DEFAULT_REPLAY);//Convert.ToString txtDEFAULT_REPLAY_FALG.Text = valObj.DEFAULT_REPLAY_FALG.ToString(); txtLBS_DISTANCE.Text = Convert.ToString(valObj.LBS_DISTANCE);//Convert.ToDecimal txtAPPID.Text = Convert.ToString(valObj.APPID);//Convert.ToString txtAPPSESECRET.Text = Convert.ToString(valObj.APPSESECRET);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文 //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_PUBLICLIST(); if (txtAID.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.AID, Convert.ToDecimal(txtAID.Value)); } if (txtUSER_ID.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value)); } if (txtPLC_NAME.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.PLC_NAME, Convert.ToString(txtPLC_NAME.Value)); } if (txtPLC_SOURCEID.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.PLC_SOURCEID, Convert.ToString(txtPLC_SOURCEID.Value)); } if (txtWECHAT_ID.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.WECHAT_ID, Convert.ToString(txtWECHAT_ID.Value)); } if (txtAVATAR_URL.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.AVATAR_URL, Convert.ToString(txtAVATAR_URL.Value)); } if (txtAPI_KEY.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.API_KEY, Convert.ToString(txtAPI_KEY.Value)); } if (txtTOKEN.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.TOKEN, Convert.ToString(txtTOKEN.Value)); } if (txtLOCATION.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.LOCATION, Convert.ToString(txtLOCATION.Value)); } if (txtEMAIL.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value)); } if (txtFUNS.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.FUNS, Convert.ToInt32(txtFUNS.Value)); } if (txtTYPE.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.TYPE, Convert.ToInt32(txtTYPE.Value)); } if (txtSTART_DAY.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.START_DAY, Convert.ToDateTime(txtSTART_DAY.Value)); } if (txtEND_DAY.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.END_DAY, Convert.ToDateTime(txtEND_DAY.Value)); } if (txtSTATUS.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.STATUS, Convert.ToInt32(txtSTATUS.Value)); } if (txtPACKAGE_ID.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.PACKAGE_ID, Convert.ToDecimal(txtPACKAGE_ID.Value)); } if (txtIS_NEWS.Value != "") { condObj.IS_NEWS = Convert.ToInt32(txtIS_NEWS.Value); } if (txtDEFAULT_REPLAY.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.DEFAULT_REPLAY, Convert.ToString(txtDEFAULT_REPLAY.Value)); } if (txtDEFAULT_REPLAY_FALG.Value != "") { condObj.DEFAULT_REPLAY_FALG = Convert.ToInt32(txtDEFAULT_REPLAY_FALG.Value); } if (txtLBS_DISTANCE.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.LBS_DISTANCE, Convert.ToDecimal(txtLBS_DISTANCE.Value)); } if (txtAPPID.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.APPID, Convert.ToString(txtAPPID.Value)); } if (txtAPPSESECRET.Value != "") { condObj.Like_OR(WEC_PUBLICLIST.Attribute.APPSESECRET, Convert.ToString(txtAPPSESECRET.Value)); } try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable <WEC_PUBLICLIST> .SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["AID"])) { keyid = Request["AID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtSTART_DAY.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtEND_DAY.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtIS_NEWS.Items.AddRange(FormHelper.GetListItem(WEC_PUBLICLIST.Attribute.IS_NEWS)); txtDEFAULT_REPLAY_FALG.Items.AddRange(FormHelper.GetListItem(WEC_PUBLICLIST.Attribute.DEFAULT_REPLAY_FALG)); this.txtAID.Disabled = true; this.txtAID.Value = "0"; this.txtAID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable <WEC_PUBLICLIST> .GetRowData(WEC_PUBLICLIST.Attribute.AID, keyid); if (valObj == null) { return; } txtAID.Value = Convert.ToString(valObj.AID); //Convert.ToDecimal txtUSER_ID.Value = Convert.ToString(valObj.USER_ID); //Convert.ToDecimal txtPLC_NAME.Value = Convert.ToString(valObj.PLC_NAME); //Convert.ToString txtPLC_SOURCEID.Value = Convert.ToString(valObj.PLC_SOURCEID); //Convert.ToString txtWECHAT_ID.Value = Convert.ToString(valObj.WECHAT_ID); //Convert.ToString txtAVATAR_URL.Value = Convert.ToString(valObj.AVATAR_URL); //Convert.ToString txtAPI_KEY.Value = Convert.ToString(valObj.API_KEY); //Convert.ToString txtTOKEN.Value = Convert.ToString(valObj.TOKEN); //Convert.ToString txtLOCATION.Value = Convert.ToString(valObj.LOCATION); //Convert.ToString txtEMAIL.Value = Convert.ToString(valObj.EMAIL); //Convert.ToString txtFUNS.Value = Convert.ToString(valObj.FUNS); //Convert.ToInt32 txtTYPE.Value = Convert.ToString(valObj.TYPE); //Convert.ToInt32 txtSTART_DAY.Value = (valObj.START_DAY == DateTime.MinValue) ? "" : valObj.START_DAY.ToString("yyyy-MM-dd"); txtEND_DAY.Value = (valObj.END_DAY == DateTime.MinValue) ? "" : valObj.END_DAY.ToString("yyyy-MM-dd"); txtSTATUS.Value = Convert.ToString(valObj.STATUS); //Convert.ToInt32 txtPACKAGE_ID.Value = Convert.ToString(valObj.PACKAGE_ID); //Convert.ToDecimal txtIS_NEWS.Value = valObj.IS_NEWS.ToString(); txtDEFAULT_REPLAY.Value = Convert.ToString(valObj.DEFAULT_REPLAY);//Convert.ToString txtDEFAULT_REPLAY_FALG.Value = valObj.DEFAULT_REPLAY_FALG.ToString(); txtLBS_DISTANCE.Value = Convert.ToString(valObj.LBS_DISTANCE); //Convert.ToDecimal txtAPPID.Value = Convert.ToString(valObj.APPID); //Convert.ToString txtAPPSESECRET.Value = Convert.ToString(valObj.APPSESECRET); //Convert.ToString } else { txtUSER_ID.Value = Convert.ToString(userBase.UserID); } } catch (Exception ex) { litWarn.Text = ex.Message; } } }