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