protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_ACTIVITY_SNCODE(); if(txtID.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.ID, Convert.ToDecimal(txtID.Value)); if(txtSN_CODE.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.SN_CODE, Convert.ToString(txtSN_CODE.Value)); if(txtAWARD_TYPE.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.AWARD_TYPE, Convert.ToString(txtAWARD_TYPE.Value)); if(txtSTATUS.Value !="" ) condObj.STATUS = Convert.ToInt32(txtSTATUS.Value); if(txtPHONE.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.PHONE, Convert.ToString(txtPHONE.Value)); if(txtWX_CODE.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.WX_CODE, Convert.ToString(txtWX_CODE.Value)); if(txtZJ_TIME.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.ZJ_TIME, Convert.ToDateTime(txtZJ_TIME.Value)); if(txtSY_TIME.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.SY_TIME, Convert.ToDateTime(txtSY_TIME.Value)); if(txtA_ID.Value !="" ) condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Convert.ToDecimal(txtA_ID.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_ACTIVITY_SNCODE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_ACTIVITY_SNCODE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["ID"])) { valObj = BLLTable<WEC_ACTIVITY_SNCODE>.GetRowData(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["ID"]); if(valObj==null) return ; txtID.Text = Convert.ToString(valObj.ID);//Convert.ToDecimal txtSN_CODE.Text = Convert.ToString(valObj.SN_CODE);//Convert.ToString txtAWARD_TYPE.Text = Convert.ToString(valObj.AWARD_TYPE);//Convert.ToString txtSTATUS.Text=valObj.STATUS.ToString(); txtPHONE.Text = Convert.ToString(valObj.PHONE);//Convert.ToString txtWX_CODE.Text = Convert.ToString(valObj.WX_CODE);//Convert.ToString txtZJ_TIME.Text = (valObj.ZJ_TIME == DateTime.MinValue) ? "" : valObj.ZJ_TIME.ToString("yyyy-MM-dd HH:mm"); txtSY_TIME.Text = (valObj.SY_TIME == DateTime.MinValue) ? "" : valObj.SY_TIME.ToString("yyyy-MM-dd HH:mm"); txtA_ID.Text = Convert.ToString(valObj.A_ID);//Convert.ToDecimal } } 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 Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["ID"])) { keyid = Request["ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtSTATUS.Items.AddRange(FormHelper.GetListItem(WEC_ACTIVITY_SNCODE.Attribute.STATUS)); txtZJ_TIME.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtSY_TIME.Value = (DateTime.Now).ToString("yyyy-MM-dd"); this.txtID.Disabled = true; this.txtID.Value = "0"; this.txtID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(WEC_ACTIVITY_SNCODE.Attribute.ID, keyid); if (valObj == null) { return; } txtID.Value = Convert.ToString(valObj.ID); //Convert.ToDecimal txtSN_CODE.Value = Convert.ToString(valObj.SN_CODE); //Convert.ToString txtAWARD_TYPE.Value = Convert.ToString(valObj.AWARD_TYPE); //Convert.ToString txtSTATUS.Value = valObj.STATUS.ToString(); txtPHONE.Value = Convert.ToString(valObj.PHONE); //Convert.ToString txtWX_CODE.Value = Convert.ToString(valObj.WX_CODE); //Convert.ToString txtZJ_TIME.Value = (valObj.ZJ_TIME == DateTime.MinValue) ? "" : valObj.ZJ_TIME.ToString("yyyy-MM-dd"); txtSY_TIME.Value = (valObj.SY_TIME == DateTime.MinValue) ? "" : valObj.SY_TIME.ToString("yyyy-MM-dd"); txtA_ID.Value = Convert.ToString(valObj.A_ID);//Convert.ToDecimal } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_ACTIVITY_SNCODE>(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_ACTIVITY_SNCODE>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelID"] != null) { int re = BLLTable <WEC_ACTIVITY_SNCODE> .Delete(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["DelID"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { WEC_ACTIVITY_SNCODE cond = new WEC_ACTIVITY_SNCODE(); cond.In(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["DelKeyIDS"]); int re = BLLTable <WEC_ACTIVITY_SNCODE> .Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { WEC_ACTIVITY_SNCODE val = new WEC_ACTIVITY_SNCODE(); val.ID = 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_ACTIVITY_SNCODE> .Update(val, WEC_ACTIVITY_SNCODE.Attribute.ID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP1); //hideTableColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP2); //hideTableColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP1); //hideFindColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP2); //hideFindColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP3); #endregion condObj.OrderBy(WEC_ACTIVITY_SNCODE.Attribute.ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { WEC_ACTIVITY_SNCODE roleOld = new WEC_ACTIVITY_SNCODE(); roleOld.Where(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["ids"].ToString()); listObj = BLLTable <WEC_ACTIVITY_SNCODE> .Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].ID + "',Name:'" + listObj[i].ID + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].ID; } } try { listObj = BLLTable <WEC_ACTIVITY_SNCODE> .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["DelID"] != null) { int re = BLLTable<WEC_ACTIVITY_SNCODE>.Delete(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["DelID"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { WEC_ACTIVITY_SNCODE cond = new WEC_ACTIVITY_SNCODE(); cond.In(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["DelKeyIDS"]); int re = BLLTable<WEC_ACTIVITY_SNCODE>.Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { WEC_ACTIVITY_SNCODE val = new WEC_ACTIVITY_SNCODE(); val.ID = 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_ACTIVITY_SNCODE>.Update(val, WEC_ACTIVITY_SNCODE.Attribute.ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { WEC_ACTIVITY conf2 = new WEC_ACTIVITY(); open_id = HttpUtil.GetReqStrValue("open_id"); a_id = HttpUtil.GetReqStrValue("a_id"); conf2.ID = Convert.ToDecimal(a_id); activity = BLLTable <WEC_ACTIVITY> .GetRowData(new WEC_ACTIVITY(), conf2); WEC_USER_ACTIVITY_DETAIL conf = new WEC_USER_ACTIVITY_DETAIL(); conf.USER_ID = open_id; conf.A_ID = Convert.ToDecimal(a_id); detail = BLLTable <WEC_USER_ACTIVITY_DETAIL> .GetRowData(new WEC_USER_ACTIVITY_DETAIL(), conf); if (detail == null) { detail = new WEC_USER_ACTIVITY_DETAIL(); detail.USER_ID = open_id; detail.A_ID = Convert.ToDecimal(a_id); detail.ISGET = 0; detail.ALL_PLAY = 0; detail.DAY_PLAY = 0; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Insert(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } else { if (detail.ISGET == 0) { isGet = false; } else { isGet = true; WEC_ACTIVITY_SNCODE conf3 = new WEC_ACTIVITY_SNCODE(); conf3.SN_CODE = detail.SN_CODE; WEC_ACTIVITY_SNCODE sncode = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(new WEC_ACTIVITY_SNCODE(), conf3); sn_code = sncode.SN_CODE; info = sncode.AWARD_NAME; phone = sncode.PHONE; } } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { recount = aspPager.RecordCount; if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_ACTIVITY_SNCODE>(hidCondition.Value); } List<WEC_ACTIVITY_SNCODE> listVal = BLLTable<WEC_ACTIVITY_SNCODE>.SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repList.DataSource = listVal; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_ACTIVITY_SNCODE>(hidCondition.Value); } listObj = BLLTable <WEC_ACTIVITY_SNCODE> .SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_ACTIVITY_SNCODE(); if(txtID.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.ID, Convert.ToDecimal(txtID.Value)); if(txtSN_CODE.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.SN_CODE, Convert.ToString(txtSN_CODE.Value)); if(txtAWARD_TYPE.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.AWARD_TYPE, Convert.ToString(txtAWARD_TYPE.Value)); if(txtSTATUS.Value !="" ) condObj.STATUS = Convert.ToInt32(txtSTATUS.Value); if(txtPHONE.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.PHONE, Convert.ToString(txtPHONE.Value)); if(txtWX_CODE.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.WX_CODE, Convert.ToString(txtWX_CODE.Value)); if(txtZJ_TIME.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.ZJ_TIME, Convert.ToDateTime(txtZJ_TIME.Value)); if(txtSY_TIME.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.SY_TIME, Convert.ToDateTime(txtSY_TIME.Value)); if(txtA_ID.Value !="" ) condObj.Like_OR(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Convert.ToDecimal(txtA_ID.Value)); try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable<WEC_ACTIVITY_SNCODE>.SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
private void BindList(WEC_ACTIVITY_SNCODE condObj, int curPage) { condObj.A_ID = Convert.ToInt32(HttpUtil.GetReqStrValue("a_id")); if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(WEC_ACTIVITY_SNCODE.Attribute.ID, Order.Desc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable <WEC_ACTIVITY_SNCODE> .SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
public void lottery() { WEC_ACTIVITY conf = new WEC_ACTIVITY(); conf.ID = Convert.ToDecimal(a_id); WEC_ACTIVITY activity = BLLTable <WEC_ACTIVITY> .GetRowData(new WEC_ACTIVITY(), conf); int zjl = activity.PROBABILITY; if (isGet) { } else { if (zjl >= 10000) { isGet = true; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List <WEC_ACTIVITY_SNCODE> list = BLLTable <WEC_ACTIVITY_SNCODE> .Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { isGet = false; return; } Random r = new Random(); int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable <WEC_ACTIVITY_SNCODE> .Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } else { bool[] bo = new bool[10000]; for (int i = 0; i < zjl; i++) { bo[i] = true; } Random r = new Random(); int j = r.Next(10000); if (bo[j]) { isGet = true; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List <WEC_ACTIVITY_SNCODE> list = BLLTable <WEC_ACTIVITY_SNCODE> .Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { isGet = false; return; } int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable <WEC_ACTIVITY_SNCODE> .Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } } } }
protected void btnOK_Click(object sender, EventArgs e) { try { WEC_ACTIVITY valObj = new WEC_ACTIVITY(); if(txtID.Value !="" ) valObj.ID = Convert.ToDecimal(txtID.Value); if(txtAID.Value !="" ) valObj.AID = Convert.ToDecimal(txtAID.Value); if(txtKEYWORD.Value !="" ) valObj.KEYWORD = Convert.ToString(txtKEYWORD.Value); if(txtTIME.Value !="" ) valObj.TIME = Convert.ToString(txtTIME.Value); // if(txtSTART_PICURL.Value !="" ) // valObj.START_PICURL = Convert.ToString(txtSTART_PICURL.Value); valObj.START_PICURL = hidSTART_PICURL.Value; if(txtEND_THEME.Value !="" ) valObj.END_THEME = Convert.ToString(txtEND_THEME.Value); valObj.END_PICURL = hidEND_PICURL.Value; // if(txtEND_PICURL.Value !="" ) // valObj.END_PICURL = Convert.ToString(txtEND_PICURL.Value); if(txtTYPE_ONE.Value !="" ) valObj.TYPE_ONE = Convert.ToString(txtTYPE_ONE.Value); if(txtNAME_ONE.Value !="" ) valObj.NAME_ONE = Convert.ToString(txtNAME_ONE.Value); if(txtNUM_ONE.Value !="" ) valObj.NUM_ONE = Convert.ToInt32(txtNUM_ONE.Value); if(txtTYPE_TWO.Value !="" ) valObj.TYPE_TWO = Convert.ToString(txtTYPE_TWO.Value); if(txtNAME_TWO.Value !="" ) valObj.NAME_TWO = Convert.ToString(txtNAME_TWO.Value); if(txtNUM_TWO.Value !="" ) valObj.NUM_TWO = Convert.ToInt32(txtNUM_TWO.Value); if(txtTYPE_THREE.Value !="" ) valObj.TYPE_THREE = Convert.ToString(txtTYPE_THREE.Value); if(txtNAME_THREE.Value !="" ) valObj.NAME_THREE = Convert.ToString(txtNAME_THREE.Value); if(txtNUM_THREE.Value !="" ) valObj.NUM_THREE = Convert.ToInt32(txtNUM_THREE.Value); if(txtTYPE_FOUR.Value !="" ) valObj.TYPE_FOUR = Convert.ToString(txtTYPE_FOUR.Value); if(txtNAME_FOUR.Value !="" ) valObj.NAME_FOUR = Convert.ToString(txtNAME_FOUR.Value); if(txtNUM_FOUR.Value !="" ) valObj.NUM_FOUR = Convert.ToInt32(txtNUM_FOUR.Value); if(txtTYPE_FIVE.Value !="" ) valObj.TYPE_FIVE = Convert.ToString(txtTYPE_FIVE.Value); if(txtNAME_FIVE.Value !="" ) valObj.NAME_FIVE = Convert.ToString(txtNAME_FIVE.Value); if(txtNUM_FIVE.Value !="" ) valObj.NUM_FIVE = Convert.ToInt32(txtNUM_FIVE.Value); if(txtTYPE_SIX.Value !="" ) valObj.TYPE_SIX = Convert.ToString(txtTYPE_SIX.Value); if(txtNAME_SIX.Value !="" ) valObj.NAME_SIX = Convert.ToString(txtNAME_SIX.Value); if(txtNUM_SIX.Value !="" ) valObj.NUM_SIX = Convert.ToInt32(txtNUM_SIX.Value); if(txtCONFIRM_PWD.Value !="" ) valObj.CONFIRM_PWD = Convert.ToString(txtCONFIRM_PWD.Value); if(txtNAME.Value !="" ) valObj.NAME = Convert.ToString(txtNAME.Value); if(txtCONTENT.Value !="" ) valObj.CONTENT = Convert.ToString(txtCONTENT.Value); if(txtINFO.Value !="" ) valObj.INFO = Convert.ToString(txtINFO.Value); if(txtEND_INSTRUCTION.Value !="" ) valObj.END_INSTRUCTION = Convert.ToString(txtEND_INSTRUCTION.Value); if(txtPROBABILITY.Value !="" ) valObj.PROBABILITY = Convert.ToInt32(txtPROBABILITY.Value); if(txtNUMBER_TIMES.Value !="" ) valObj.NUMBER_TIMES = Convert.ToInt32(txtNUMBER_TIMES.Value); if(txtINFORMATION.Value !="" ) valObj.INFORMATION = Convert.ToString(txtINFORMATION.Value); valObj.KIND = Convert.ToInt32(kind); if (keyid != "") { valObj.ID = Convert.ToDecimal(keyid); count = BLLTable<WEC_ACTIVITY>.Update(valObj, WEC_ACTIVITY.Attribute.ID); } else { keyid = valObj.ID.ToString(); WEC_REQUEST wec_request = new WEC_REQUEST(); wec_request.AID = Convert.ToInt32(userBase2.Curraid); wec_request.ADDTIME = DateTime.Now; wec_request.KEYWORD = valObj.KEYWORD; wec_request.KIND = 8; wec_request.MEMO = ""; wec_request.STATUS = 0; wec_request.MATCH_TYPE = 0; BLLTable<WEC_REQUEST>.Insert(wec_request,WEC_REQUEST.Attribute.TID); valObj.R_ID=wec_request.TID; count = BLLTable<WEC_ACTIVITY>.Insert(valObj, WEC_ACTIVITY.Attribute.ID); WEC_REQUEST_DETAIL detail = new WEC_REQUEST_DETAIL(); detail.TID = wec_request.TID; detail.SORT_ID = 1; detail.STATUS = 0; detail.PICURL =valObj.START_PICURL; detail.TITLE =valObj.NAME; detail.ADDTIME = DateTime.Now; ; detail.DESCRIPTION = valObj.INFO; detail.TYPE_ID = "4"; detail.TYPE_VALUE = ""; BLLTable<WEC_REQUEST_DETAIL>.Insert(detail,WEC_REQUEST_DETAIL.Attribute.ID); Random r=new Random(); int[] num_type = new int[] { valObj.NUM_ONE, valObj.NUM_TWO, valObj.NUM_THREE, valObj.NUM_FOUR, valObj.NUM_FIVE,valObj.NUM_SIX }; string[] type_type = new string[] {valObj.TYPE_ONE,valObj.TYPE_TWO,valObj._TYPE_THREE,valObj.TYPE_FOUR,valObj.TYPE_FIVE,valObj.TYPE_SIX }; string[] name_type = new string[] { valObj.NAME_ONE, valObj.NAME_TWO, valObj.NAME_THREE, valObj.NAME_FOUR, valObj.NAME_FIVE, valObj.NAME_SIX }; for (int j = 0; j < num_type.Length;j++ ) { for (int i = 0; i < num_type[j]; i++) { WEC_ACTIVITY_SNCODE sn = new WEC_ACTIVITY_SNCODE(); sn.A_ID = valObj.ID; sn.PHONE = ""; sn.WX_CODE = ""; sn.STATUS = 0; sn.AWARD_TYPE = j+1; sn.AWARD_NAME = name_type[j]; sn.SN_CODE = DateTime.Now.ToString("yyyyMMddHHmmss") + (r.Next(8999) + 1000 )+ ""; BLLTable<WEC_ACTIVITY_SNCODE>.Insert(sn, WEC_ACTIVITY_SNCODE.Attribute.ID); } } } 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", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } } else { txtID.Value =""; txtAID.Value =""; txtKEYWORD.Value =""; txtTIME.Value =""; // txtSTART_PICURL.Value =""; txtEND_THEME.Value =""; // txtEND_PICURL.Value =""; txtTYPE_ONE.Value =""; txtNAME_ONE.Value =""; txtNUM_ONE.Value =""; txtTYPE_TWO.Value =""; txtNAME_TWO.Value =""; txtNUM_TWO.Value =""; txtTYPE_THREE.Value =""; txtNAME_THREE.Value =""; txtNUM_THREE.Value =""; txtTYPE_FOUR.Value =""; txtNAME_FOUR.Value =""; txtNUM_FOUR.Value =""; txtTYPE_FIVE.Value =""; txtNAME_FIVE.Value =""; txtNUM_FIVE.Value =""; txtTYPE_SIX.Value =""; txtNAME_SIX.Value =""; txtNUM_SIX.Value =""; txtCONFIRM_PWD.Value =""; txtNAME.Value =""; txtCONTENT.Value =""; txtINFO.Value =""; txtEND_INSTRUCTION.Value =""; txtPROBABILITY.Value =""; txtNUMBER_TIMES.Value =""; txtINFORMATION.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { string a_id = HttpUtil.GetReqStrValue("a_id"); string code = HttpUtil.GetReqStrValue("code"); string open_id = HttpUtil.GetReqStrValue("open_id"); string tel = HttpUtil.GetReqStrValue("tel"); string kind = HttpUtil.GetReqStrValue("kind"); if ("1".Equals(kind))//ßÉßÉ¿¨ { WEC_ACTIVITY_SNCODE conf = new WEC_ACTIVITY_SNCODE(); conf.SN_CODE = code; conf.A_ID = Convert.ToDecimal(a_id); WEC_ACTIVITY_SNCODE sncode = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(new WEC_ACTIVITY_SNCODE(), conf); sncode.PHONE = tel; sncode.SY_TIME = DateTime.Now; sncode.STATUS = 1; sncode.WX_CODE = open_id; BLLTable <WEC_ACTIVITY_SNCODE> .Update(sncode, WEC_ACTIVITY_SNCODE.Attribute.ID); WEC_USER_ACTIVITY_DETAIL conf2 = new WEC_USER_ACTIVITY_DETAIL(); conf2.A_ID = Convert.ToDecimal(a_id); conf2.USER_ID = open_id; WEC_USER_ACTIVITY_DETAIL detail = BLLTable <WEC_USER_ACTIVITY_DETAIL> .GetRowData(new WEC_USER_ACTIVITY_DETAIL(), conf2); detail.ISGET = 1; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); Response.Write(" "); } else if ("2".Equals(kind))//´óתÅÌ { string sn_code = ""; string info = ""; string phone = ""; int type = 0; WEC_USER_ACTIVITY_DETAIL conf3 = new WEC_USER_ACTIVITY_DETAIL(); conf3.A_ID = Convert.ToDecimal(a_id); conf3.USER_ID = open_id; WEC_USER_ACTIVITY_DETAIL detail = BLLTable <WEC_USER_ACTIVITY_DETAIL> .GetRowData(new WEC_USER_ACTIVITY_DETAIL(), conf3); WEC_ACTIVITY conf = new WEC_ACTIVITY(); conf.ID = Convert.ToDecimal(a_id); WEC_ACTIVITY activity = BLLTable <WEC_ACTIVITY> .GetRowData(new WEC_ACTIVITY(), conf); int zjl = activity.PROBABILITY; if (zjl >= 10000) { WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List <WEC_ACTIVITY_SNCODE> list = BLLTable <WEC_ACTIVITY_SNCODE> .Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { return; } Random r = new Random(); int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; type = list[s_id].AWARD_TYPE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable <WEC_ACTIVITY_SNCODE> .Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } else { bool[] bo = new bool[10000]; for (int i = 0; i < zjl; i++) { bo[i] = true; } Random r = new Random(); int j = r.Next(10000); if (bo[j]) { detail.ISGET = 1; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List <WEC_ACTIVITY_SNCODE> list = BLLTable <WEC_ACTIVITY_SNCODE> .Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { detail.ISGET = 0; return; } int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable <WEC_ACTIVITY_SNCODE> .Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; } } detail.ALL_PLAY += 1; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); if (detail.ISGET == 1) { Response.Write("{\"name\":\"getsn\",\"msg\":\"¹§Ï²Öн±\",\"sn\":\"" + sn_code + "\",\"prizetype\":" + type + ",\"success\":true,\"allplay\":" + detail.ALL_PLAY + "}"); } else { Response.Write("{\"name\":\"invalid\",\"allplay\":" + detail.ALL_PLAY + "}"); } } else if ("21".Equals(kind)) { WEC_ACTIVITY_SNCODE conf = new WEC_ACTIVITY_SNCODE(); conf.SN_CODE = code; conf.A_ID = Convert.ToDecimal(a_id); WEC_ACTIVITY_SNCODE sncode = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(new WEC_ACTIVITY_SNCODE(), conf); sncode.PHONE = tel; sncode.SY_TIME = DateTime.Now; sncode.STATUS = 1; sncode.WX_CODE = open_id; BLLTable <WEC_ACTIVITY_SNCODE> .Update(sncode, WEC_ACTIVITY_SNCODE.Attribute.ID); WEC_USER_ACTIVITY_DETAIL conf2 = new WEC_USER_ACTIVITY_DETAIL(); conf2.A_ID = Convert.ToDecimal(a_id); conf2.USER_ID = open_id; WEC_USER_ACTIVITY_DETAIL detail = BLLTable <WEC_USER_ACTIVITY_DETAIL> .GetRowData(new WEC_USER_ACTIVITY_DETAIL(), conf2); detail.ISGET = 1; BLLTable <WEC_USER_ACTIVITY_DETAIL> .Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); Response.Write(" "); } }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new WEC_ACTIVITY_SNCODE(); if (txtID.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.ID, Convert.ToDecimal(txtID.Value)); } if (txtSN_CODE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.SN_CODE, Convert.ToString(txtSN_CODE.Value)); } if (txtAWARD_TYPE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.AWARD_TYPE, Convert.ToString(txtAWARD_TYPE.Value)); } if (txtSTATUS.Value != "") { condObj.STATUS = Convert.ToInt32(txtSTATUS.Value); } if (txtPHONE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.PHONE, Convert.ToString(txtPHONE.Value)); } if (txtWX_CODE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.WX_CODE, Convert.ToString(txtWX_CODE.Value)); } if (txtZJ_TIME.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.ZJ_TIME, Convert.ToDateTime(txtZJ_TIME.Value)); } if (txtSY_TIME.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.SY_TIME, Convert.ToDateTime(txtSY_TIME.Value)); } if (txtA_ID.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Convert.ToDecimal(txtA_ID.Value)); } listObj = BLLTable <WEC_ACTIVITY_SNCODE> .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) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelID"] != null) { int re = BLLTable<WEC_ACTIVITY>.Delete(WEC_ACTIVITY.Attribute.ID, Request["DelID"]); WEC_ACTIVITY conf = new WEC_ACTIVITY(); conf.ID = Convert.ToDecimal(Request["DelID"]); WEC_ACTIVITY activity = BLLTable<WEC_ACTIVITY>.GetRowData(new WEC_ACTIVITY(),conf); int re_r=BLLTable<WEC_REQUEST>.Delete(WEC_REQUEST.Attribute.TID,activity.R_ID); int re_s = BLLTable<WEC_ACTIVITY_SNCODE>.Delete(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Request["DelID"]); if (re > 0&&re_r>=0&&re_s>=0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { WEC_ACTIVITY cond = new WEC_ACTIVITY(); cond.In(WEC_ACTIVITY.Attribute.ID, Request["DelKeyIDS"]); List<WEC_ACTIVITY> list=BLLTable<WEC_ACTIVITY>.Select(new WEC_ACTIVITY(),cond); int re = BLLTable<WEC_ACTIVITY>.Delete(cond); string str = ""; foreach(WEC_ACTIVITY a in list){ str += a.R_ID + ","; } str=str.Substring(0,str.Length-1); WEC_REQUEST cond2 = new WEC_REQUEST(); cond2.In(WEC_REQUEST.Attribute.TID,str); int re_r = BLLTable<WEC_REQUEST>.Delete(cond2); WEC_ACTIVITY_SNCODE cond3 = new WEC_ACTIVITY_SNCODE(); cond3.In(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Request["DelKeyIDS"]); //WEC_ACTIVITY activity = BLLTable<WEC_ACTIVITY>.GetRowData(new WEC_ACTIVITY(), conf); //int re_r = BLLTable<WEC_REQUEST>.Delete(WEC_REQUEST.Attribute.TID, activity.R_ID); int re_s = BLLTable<WEC_ACTIVITY_SNCODE>.Delete(cond3); if (re > 0&&re_r>=0&&re_s>=0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { WEC_ACTIVITY val = new WEC_ACTIVITY(); val.ID = 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_ACTIVITY>.Update(val, WEC_ACTIVITY.Attribute.ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void btnOK_Click(object sender, EventArgs e) { try { WEC_ACTIVITY valObj = new WEC_ACTIVITY(); if (txtID.Value != "") { valObj.ID = Convert.ToDecimal(txtID.Value); } if (txtAID.Value != "") { valObj.AID = Convert.ToDecimal(txtAID.Value); } if (txtKEYWORD.Value != "") { valObj.KEYWORD = Convert.ToString(txtKEYWORD.Value); } if (txtTIME.Value != "") { valObj.TIME = Convert.ToString(txtTIME.Value); } // if(txtSTART_PICURL.Value !="" ) // valObj.START_PICURL = Convert.ToString(txtSTART_PICURL.Value); valObj.START_PICURL = hidSTART_PICURL.Value; if (txtEND_THEME.Value != "") { valObj.END_THEME = Convert.ToString(txtEND_THEME.Value); } valObj.END_PICURL = hidEND_PICURL.Value; // if(txtEND_PICURL.Value !="" ) // valObj.END_PICURL = Convert.ToString(txtEND_PICURL.Value); if (txtTYPE_ONE.Value != "") { valObj.TYPE_ONE = Convert.ToString(txtTYPE_ONE.Value); } if (txtNAME_ONE.Value != "") { valObj.NAME_ONE = Convert.ToString(txtNAME_ONE.Value); } if (txtNUM_ONE.Value != "") { valObj.NUM_ONE = Convert.ToInt32(txtNUM_ONE.Value); } if (txtTYPE_TWO.Value != "") { valObj.TYPE_TWO = Convert.ToString(txtTYPE_TWO.Value); } if (txtNAME_TWO.Value != "") { valObj.NAME_TWO = Convert.ToString(txtNAME_TWO.Value); } if (txtNUM_TWO.Value != "") { valObj.NUM_TWO = Convert.ToInt32(txtNUM_TWO.Value); } if (txtTYPE_THREE.Value != "") { valObj.TYPE_THREE = Convert.ToString(txtTYPE_THREE.Value); } if (txtNAME_THREE.Value != "") { valObj.NAME_THREE = Convert.ToString(txtNAME_THREE.Value); } if (txtNUM_THREE.Value != "") { valObj.NUM_THREE = Convert.ToInt32(txtNUM_THREE.Value); } if (txtTYPE_FOUR.Value != "") { valObj.TYPE_FOUR = Convert.ToString(txtTYPE_FOUR.Value); } if (txtNAME_FOUR.Value != "") { valObj.NAME_FOUR = Convert.ToString(txtNAME_FOUR.Value); } if (txtNUM_FOUR.Value != "") { valObj.NUM_FOUR = Convert.ToInt32(txtNUM_FOUR.Value); } if (txtTYPE_FIVE.Value != "") { valObj.TYPE_FIVE = Convert.ToString(txtTYPE_FIVE.Value); } if (txtNAME_FIVE.Value != "") { valObj.NAME_FIVE = Convert.ToString(txtNAME_FIVE.Value); } if (txtNUM_FIVE.Value != "") { valObj.NUM_FIVE = Convert.ToInt32(txtNUM_FIVE.Value); } if (txtTYPE_SIX.Value != "") { valObj.TYPE_SIX = Convert.ToString(txtTYPE_SIX.Value); } if (txtNAME_SIX.Value != "") { valObj.NAME_SIX = Convert.ToString(txtNAME_SIX.Value); } if (txtNUM_SIX.Value != "") { valObj.NUM_SIX = Convert.ToInt32(txtNUM_SIX.Value); } if (txtCONFIRM_PWD.Value != "") { valObj.CONFIRM_PWD = Convert.ToString(txtCONFIRM_PWD.Value); } if (txtNAME.Value != "") { valObj.NAME = Convert.ToString(txtNAME.Value); } if (txtCONTENT.Value != "") { valObj.CONTENT = Convert.ToString(txtCONTENT.Value); } if (txtINFO.Value != "") { valObj.INFO = Convert.ToString(txtINFO.Value); } if (txtEND_INSTRUCTION.Value != "") { valObj.END_INSTRUCTION = Convert.ToString(txtEND_INSTRUCTION.Value); } if (txtPROBABILITY.Value != "") { valObj.PROBABILITY = Convert.ToInt32(txtPROBABILITY.Value); } if (txtNUMBER_TIMES.Value != "") { valObj.NUMBER_TIMES = Convert.ToInt32(txtNUMBER_TIMES.Value); } if (txtINFORMATION.Value != "") { valObj.INFORMATION = Convert.ToString(txtINFORMATION.Value); } valObj.KIND = Convert.ToInt32(kind); if (keyid != "") { valObj.ID = Convert.ToDecimal(keyid); count = BLLTable <WEC_ACTIVITY> .Update(valObj, WEC_ACTIVITY.Attribute.ID); } else { keyid = valObj.ID.ToString(); WEC_REQUEST wec_request = new WEC_REQUEST(); wec_request.AID = Convert.ToInt32(userBase2.Curraid); wec_request.ADDTIME = DateTime.Now; wec_request.KEYWORD = valObj.KEYWORD; wec_request.KIND = 8; wec_request.MEMO = ""; wec_request.STATUS = 0; wec_request.MATCH_TYPE = 0; BLLTable <WEC_REQUEST> .Insert(wec_request, WEC_REQUEST.Attribute.TID); valObj.R_ID = wec_request.TID; count = BLLTable <WEC_ACTIVITY> .Insert(valObj, WEC_ACTIVITY.Attribute.ID); WEC_REQUEST_DETAIL detail = new WEC_REQUEST_DETAIL(); detail.TID = wec_request.TID; detail.SORT_ID = 1; detail.STATUS = 0; detail.PICURL = valObj.START_PICURL; detail.TITLE = valObj.NAME; detail.ADDTIME = DateTime.Now;; detail.DESCRIPTION = valObj.INFO; detail.TYPE_ID = "4"; detail.TYPE_VALUE = ""; BLLTable <WEC_REQUEST_DETAIL> .Insert(detail, WEC_REQUEST_DETAIL.Attribute.ID); Random r = new Random(); int[] num_type = new int[] { valObj.NUM_ONE, valObj.NUM_TWO, valObj.NUM_THREE, valObj.NUM_FOUR, valObj.NUM_FIVE, valObj.NUM_SIX }; string[] type_type = new string[] { valObj.TYPE_ONE, valObj.TYPE_TWO, valObj._TYPE_THREE, valObj.TYPE_FOUR, valObj.TYPE_FIVE, valObj.TYPE_SIX }; string[] name_type = new string[] { valObj.NAME_ONE, valObj.NAME_TWO, valObj.NAME_THREE, valObj.NAME_FOUR, valObj.NAME_FIVE, valObj.NAME_SIX }; for (int j = 0; j < num_type.Length; j++) { for (int i = 0; i < num_type[j]; i++) { WEC_ACTIVITY_SNCODE sn = new WEC_ACTIVITY_SNCODE(); sn.A_ID = valObj.ID; sn.PHONE = ""; sn.WX_CODE = ""; sn.STATUS = 0; sn.AWARD_TYPE = j + 1; sn.AWARD_NAME = name_type[j]; sn.SN_CODE = DateTime.Now.ToString("yyyyMMddHHmmss") + (r.Next(8999) + 1000) + ""; BLLTable <WEC_ACTIVITY_SNCODE> .Insert(sn, WEC_ACTIVITY_SNCODE.Attribute.ID); } } } 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", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } } else { txtID.Value = ""; txtAID.Value = ""; txtKEYWORD.Value = ""; txtTIME.Value = ""; // txtSTART_PICURL.Value =""; txtEND_THEME.Value = ""; // txtEND_PICURL.Value =""; txtTYPE_ONE.Value = ""; txtNAME_ONE.Value = ""; txtNUM_ONE.Value = ""; txtTYPE_TWO.Value = ""; txtNAME_TWO.Value = ""; txtNUM_TWO.Value = ""; txtTYPE_THREE.Value = ""; txtNAME_THREE.Value = ""; txtNUM_THREE.Value = ""; txtTYPE_FOUR.Value = ""; txtNAME_FOUR.Value = ""; txtNUM_FOUR.Value = ""; txtTYPE_FIVE.Value = ""; txtNAME_FIVE.Value = ""; txtNUM_FIVE.Value = ""; txtTYPE_SIX.Value = ""; txtNAME_SIX.Value = ""; txtNUM_SIX.Value = ""; txtCONFIRM_PWD.Value = ""; txtNAME.Value = ""; txtCONTENT.Value = ""; txtINFO.Value = ""; txtEND_INSTRUCTION.Value = ""; txtPROBABILITY.Value = ""; txtNUMBER_TIMES.Value = ""; txtINFORMATION.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["ID"])) { keyid = Request["ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtSTATUS.Items.AddRange(FormHelper.GetListItem(WEC_ACTIVITY_SNCODE.Attribute.STATUS)); txtZJ_TIME.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtSY_TIME.Value = (DateTime.Now).ToString("yyyy-MM-dd"); this.txtID.Disabled = true; this.txtID.Value = "0"; this.txtID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable<WEC_ACTIVITY_SNCODE>.GetRowData(WEC_ACTIVITY_SNCODE.Attribute.ID, keyid); if(valObj==null) return ; txtID.Value = Convert.ToString(valObj.ID);//Convert.ToDecimal txtSN_CODE.Value = Convert.ToString(valObj.SN_CODE);//Convert.ToString txtAWARD_TYPE.Value = Convert.ToString(valObj.AWARD_TYPE);//Convert.ToString txtSTATUS.Value=valObj.STATUS.ToString(); txtPHONE.Value = Convert.ToString(valObj.PHONE);//Convert.ToString txtWX_CODE.Value = Convert.ToString(valObj.WX_CODE);//Convert.ToString txtZJ_TIME.Value = (valObj.ZJ_TIME == DateTime.MinValue) ? "" : valObj.ZJ_TIME.ToString("yyyy-MM-dd"); txtSY_TIME.Value = (valObj.SY_TIME == DateTime.MinValue) ? "" : valObj.SY_TIME.ToString("yyyy-MM-dd"); txtA_ID.Value = Convert.ToString(valObj.A_ID);//Convert.ToDecimal } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnOK_Click(object sender, EventArgs e) { try { WEC_ACTIVITY_SNCODE valObj = new WEC_ACTIVITY_SNCODE(); if(txtID.Value !="" ) valObj.ID = Convert.ToDecimal(txtID.Value); if(txtSN_CODE.Value !="" ) valObj.SN_CODE = Convert.ToString(txtSN_CODE.Value); if(txtAWARD_TYPE.Value !="" ) valObj.AWARD_NAME = Convert.ToString(txtAWARD_TYPE.Value); if(txtSTATUS.Value !="" ) valObj.STATUS = Convert.ToInt32(txtSTATUS.Value); if(txtPHONE.Value !="" ) valObj.PHONE = Convert.ToString(txtPHONE.Value); if(txtWX_CODE.Value !="" ) valObj.WX_CODE = Convert.ToString(txtWX_CODE.Value); if(txtZJ_TIME.Value !="" ) valObj.ZJ_TIME = Convert.ToDateTime(txtZJ_TIME.Value); if(txtSY_TIME.Value !="" ) valObj.SY_TIME = Convert.ToDateTime(txtSY_TIME.Value); if(txtA_ID.Value !="" ) valObj.A_ID = Convert.ToDecimal(txtA_ID.Value); if (keyid != "") { valObj.ID = Convert.ToDecimal(keyid); count = BLLTable<WEC_ACTIVITY_SNCODE>.Update(valObj, WEC_ACTIVITY_SNCODE.Attribute.ID); } else { count = BLLTable<WEC_ACTIVITY_SNCODE>.Insert(valObj, WEC_ACTIVITY_SNCODE.Attribute.ID); keyid = valObj.ID.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 { txtID.Value =""; txtSN_CODE.Value =""; txtAWARD_TYPE.Value =""; txtSTATUS.Value =""; txtPHONE.Value =""; txtWX_CODE.Value =""; txtZJ_TIME.Value =""; txtSY_TIME.Value =""; txtA_ID.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_ACTIVITY_SNCODE(); if (txtID.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.ID, Convert.ToDecimal(txtID.Value)); } if (txtSN_CODE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.SN_CODE, Convert.ToString(txtSN_CODE.Value)); } if (txtAWARD_TYPE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.AWARD_TYPE, Convert.ToString(txtAWARD_TYPE.Value)); } if (txtSTATUS.Value != "") { condObj.STATUS = Convert.ToInt32(txtSTATUS.Value); } if (txtPHONE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.PHONE, Convert.ToString(txtPHONE.Value)); } if (txtWX_CODE.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.WX_CODE, Convert.ToString(txtWX_CODE.Value)); } if (txtZJ_TIME.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.ZJ_TIME, Convert.ToDateTime(txtZJ_TIME.Value)); } if (txtSY_TIME.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.SY_TIME, Convert.ToDateTime(txtSY_TIME.Value)); } if (txtA_ID.Value != "") { condObj.Like(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Convert.ToDecimal(txtA_ID.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
private void BindList(WEC_ACTIVITY_SNCODE condObj, int curPage) { condObj.A_ID = Convert.ToInt32(HttpUtil.GetReqStrValue("a_id")); if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(WEC_ACTIVITY_SNCODE.Attribute.ID, Order.Desc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable<WEC_ACTIVITY_SNCODE>.SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP1); //hideTableColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP2); //hideTableColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP1); //hideFindColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP2); //hideFindColumnList.Add(WEC_ACTIVITY_SNCODE.Attribute.EXP3); #endregion condObj.OrderBy(WEC_ACTIVITY_SNCODE.Attribute.ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { WEC_ACTIVITY_SNCODE roleOld = new WEC_ACTIVITY_SNCODE(); roleOld.Where(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["ids"].ToString()); listObj = BLLTable<WEC_ACTIVITY_SNCODE>.Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].ID + "',Name:'" + listObj[i].ID + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].ID; } } try { listObj = BLLTable<WEC_ACTIVITY_SNCODE>.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) { open_id = HttpUtil.GetReqStrValue("open_id"); a_id = HttpUtil.GetReqStrValue("a_id"); WEC_USER_ACTIVITY_DETAIL conf = new WEC_USER_ACTIVITY_DETAIL(); conf.USER_ID = open_id; conf.A_ID = Convert.ToDecimal(a_id); detail=BLLTable<WEC_USER_ACTIVITY_DETAIL>.GetRowData(new WEC_USER_ACTIVITY_DETAIL(),conf); if (detail == null) { detail = new WEC_USER_ACTIVITY_DETAIL(); detail.USER_ID = open_id; detail.A_ID = Convert.ToDecimal(a_id); detail.ISGET = 0; detail.ALL_PLAY = 0; detail.DAY_PLAY = 0; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Insert(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } else { if (detail.ISGET == 0) { isGet = false; } else { isGet = true; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.SN_CODE = detail.SN_CODE; WEC_ACTIVITY_SNCODE sncode = BLLTable<WEC_ACTIVITY_SNCODE>.GetRowData(new WEC_ACTIVITY_SNCODE(), conf2); sn_code = sncode.SN_CODE; info = sncode.AWARD_NAME; phone = sncode.PHONE; } } }
public void lottery() { WEC_ACTIVITY conf = new WEC_ACTIVITY(); conf.ID = Convert.ToDecimal(a_id); WEC_ACTIVITY activity = BLLTable<WEC_ACTIVITY>.GetRowData(new WEC_ACTIVITY(),conf); int zjl = activity.PROBABILITY; if (isGet) { } else { if (zjl >= 10000) { isGet = true; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List<WEC_ACTIVITY_SNCODE> list = BLLTable<WEC_ACTIVITY_SNCODE>.Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { isGet = false; return; } Random r = new Random(); int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable<WEC_ACTIVITY_SNCODE>.Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } else { bool[] bo=new bool[10000]; for (int i = 0; i < zjl;i++ ) { bo[i] = true; } Random r = new Random(); int j=r.Next(10000); if(bo[j]){ isGet = true; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List<WEC_ACTIVITY_SNCODE> list = BLLTable<WEC_ACTIVITY_SNCODE>.Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { isGet = false; return; } int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable<WEC_ACTIVITY_SNCODE>.Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } } } }
protected void Page_Load(object sender, EventArgs e) { string a_id = HttpUtil.GetReqStrValue("a_id"); string code = HttpUtil.GetReqStrValue("code"); string open_id = HttpUtil.GetReqStrValue("open_id"); string tel = HttpUtil.GetReqStrValue("tel"); string kind = HttpUtil.GetReqStrValue("kind"); if("1".Equals(kind)){//���ɿ� WEC_ACTIVITY_SNCODE conf = new WEC_ACTIVITY_SNCODE(); conf.SN_CODE = code; conf.A_ID=Convert.ToDecimal(a_id); WEC_ACTIVITY_SNCODE sncode=BLLTable<WEC_ACTIVITY_SNCODE>.GetRowData(new WEC_ACTIVITY_SNCODE(),conf); sncode.PHONE = tel; sncode.SY_TIME = DateTime.Now; sncode.STATUS = 1; sncode.WX_CODE = open_id; BLLTable<WEC_ACTIVITY_SNCODE>.Update(sncode,WEC_ACTIVITY_SNCODE.Attribute.ID); WEC_USER_ACTIVITY_DETAIL conf2 = new WEC_USER_ACTIVITY_DETAIL(); conf2.A_ID = Convert.ToDecimal(a_id); conf2.USER_ID = open_id; WEC_USER_ACTIVITY_DETAIL detail=BLLTable<WEC_USER_ACTIVITY_DETAIL>.GetRowData(new WEC_USER_ACTIVITY_DETAIL(),conf2); detail.ISGET = 1; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Update(detail,WEC_USER_ACTIVITY_DETAIL.Attribute.ID); Response.Write(" "); } else if ("2".Equals(kind))//��ת�� { string sn_code=""; string info=""; string phone=""; int type = 0; WEC_USER_ACTIVITY_DETAIL conf3=new WEC_USER_ACTIVITY_DETAIL(); conf3.A_ID=Convert.ToDecimal(a_id); conf3.USER_ID=open_id; WEC_USER_ACTIVITY_DETAIL detail=BLLTable<WEC_USER_ACTIVITY_DETAIL>.GetRowData(new WEC_USER_ACTIVITY_DETAIL(),conf3); WEC_ACTIVITY conf = new WEC_ACTIVITY(); conf.ID = Convert.ToDecimal(a_id); WEC_ACTIVITY activity = BLLTable<WEC_ACTIVITY>.GetRowData(new WEC_ACTIVITY(), conf); int zjl = activity.PROBABILITY; if (zjl >= 10000) { WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List<WEC_ACTIVITY_SNCODE> list = BLLTable<WEC_ACTIVITY_SNCODE>.Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { return; } Random r = new Random(); int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; type=list[s_id].AWARD_TYPE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable<WEC_ACTIVITY_SNCODE>.Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); } else { bool[] bo = new bool[10000]; for (int i = 0; i < zjl; i++) { bo[i] = true; } Random r = new Random(); int j = r.Next(10000); if (bo[j]) { detail.ISGET = 1; WEC_ACTIVITY_SNCODE conf2 = new WEC_ACTIVITY_SNCODE(); conf2.A_ID = conf.ID; conf2.STATUS = 0; List<WEC_ACTIVITY_SNCODE> list = BLLTable<WEC_ACTIVITY_SNCODE>.Select(new WEC_ACTIVITY_SNCODE(), conf2); if (list.Count == 0) { detail.ISGET = 0; return; } int s_id = r.Next(list.Count); sn_code = list[s_id].SN_CODE; info = list[s_id].AWARD_NAME; phone = list[s_id].PHONE; list[s_id].STATUS = 1; list[s_id].WX_CODE = open_id; list[s_id].ZJ_TIME = DateTime.Now; BLLTable<WEC_ACTIVITY_SNCODE>.Update(list[s_id], WEC_ACTIVITY_SNCODE.Attribute.ID); detail.ISGET = 1; detail.SN_CODE = sn_code; } } detail.ALL_PLAY += 1; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); if (detail.ISGET == 1) { Response.Write("{\"name\":\"getsn\",\"msg\":\"��ϲ�н�\",\"sn\":\"" + sn_code + "\",\"prizetype\":" + type + ",\"success\":true,\"allplay\":" + detail.ALL_PLAY + "}"); } else { Response.Write("{\"name\":\"invalid\",\"allplay\":" + detail.ALL_PLAY + "}"); } }else if("21".Equals(kind)){ WEC_ACTIVITY_SNCODE conf = new WEC_ACTIVITY_SNCODE(); conf.SN_CODE = code; conf.A_ID = Convert.ToDecimal(a_id); WEC_ACTIVITY_SNCODE sncode = BLLTable<WEC_ACTIVITY_SNCODE>.GetRowData(new WEC_ACTIVITY_SNCODE(), conf); sncode.PHONE = tel; sncode.SY_TIME = DateTime.Now; sncode.STATUS = 1; sncode.WX_CODE = open_id; BLLTable<WEC_ACTIVITY_SNCODE>.Update(sncode, WEC_ACTIVITY_SNCODE.Attribute.ID); WEC_USER_ACTIVITY_DETAIL conf2 = new WEC_USER_ACTIVITY_DETAIL(); conf2.A_ID = Convert.ToDecimal(a_id); conf2.USER_ID = open_id; WEC_USER_ACTIVITY_DETAIL detail = BLLTable<WEC_USER_ACTIVITY_DETAIL>.GetRowData(new WEC_USER_ACTIVITY_DETAIL(), conf2); detail.ISGET = 1; BLLTable<WEC_USER_ACTIVITY_DETAIL>.Update(detail, WEC_USER_ACTIVITY_DETAIL.Attribute.ID); Response.Write(" "); } }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelID"] != null) { int re = BLLTable <WEC_ACTIVITY> .Delete(WEC_ACTIVITY.Attribute.ID, Request["DelID"]); WEC_ACTIVITY conf = new WEC_ACTIVITY(); conf.ID = Convert.ToDecimal(Request["DelID"]); WEC_ACTIVITY activity = BLLTable <WEC_ACTIVITY> .GetRowData(new WEC_ACTIVITY(), conf); int re_r = BLLTable <WEC_REQUEST> .Delete(WEC_REQUEST.Attribute.TID, activity.R_ID); int re_s = BLLTable <WEC_ACTIVITY_SNCODE> .Delete(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Request["DelID"]); if (re > 0 && re_r >= 0 && re_s >= 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { WEC_ACTIVITY cond = new WEC_ACTIVITY(); cond.In(WEC_ACTIVITY.Attribute.ID, Request["DelKeyIDS"]); List <WEC_ACTIVITY> list = BLLTable <WEC_ACTIVITY> .Select(new WEC_ACTIVITY(), cond); int re = BLLTable <WEC_ACTIVITY> .Delete(cond); string str = ""; foreach (WEC_ACTIVITY a in list) { str += a.R_ID + ","; } str = str.Substring(0, str.Length - 1); WEC_REQUEST cond2 = new WEC_REQUEST(); cond2.In(WEC_REQUEST.Attribute.TID, str); int re_r = BLLTable <WEC_REQUEST> .Delete(cond2); WEC_ACTIVITY_SNCODE cond3 = new WEC_ACTIVITY_SNCODE(); cond3.In(WEC_ACTIVITY_SNCODE.Attribute.A_ID, Request["DelKeyIDS"]); //WEC_ACTIVITY activity = BLLTable<WEC_ACTIVITY>.GetRowData(new WEC_ACTIVITY(), conf); //int re_r = BLLTable<WEC_REQUEST>.Delete(WEC_REQUEST.Attribute.TID, activity.R_ID); int re_s = BLLTable <WEC_ACTIVITY_SNCODE> .Delete(cond3); if (re > 0 && re_r >= 0 && re_s >= 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { WEC_ACTIVITY val = new WEC_ACTIVITY(); val.ID = 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_ACTIVITY> .Update(val, WEC_ACTIVITY.Attribute.ID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void btnOK_Click(object sender, EventArgs e) { try { WEC_ACTIVITY_SNCODE valObj = new WEC_ACTIVITY_SNCODE(); if (txtID.Value != "") { valObj.ID = Convert.ToDecimal(txtID.Value); } if (txtSN_CODE.Value != "") { valObj.SN_CODE = Convert.ToString(txtSN_CODE.Value); } if (txtAWARD_TYPE.Value != "") { valObj.AWARD_NAME = Convert.ToString(txtAWARD_TYPE.Value); } if (txtSTATUS.Value != "") { valObj.STATUS = Convert.ToInt32(txtSTATUS.Value); } if (txtPHONE.Value != "") { valObj.PHONE = Convert.ToString(txtPHONE.Value); } if (txtWX_CODE.Value != "") { valObj.WX_CODE = Convert.ToString(txtWX_CODE.Value); } if (txtZJ_TIME.Value != "") { valObj.ZJ_TIME = Convert.ToDateTime(txtZJ_TIME.Value); } if (txtSY_TIME.Value != "") { valObj.SY_TIME = Convert.ToDateTime(txtSY_TIME.Value); } if (txtA_ID.Value != "") { valObj.A_ID = Convert.ToDecimal(txtA_ID.Value); } if (keyid != "") { valObj.ID = Convert.ToDecimal(keyid); count = BLLTable <WEC_ACTIVITY_SNCODE> .Update(valObj, WEC_ACTIVITY_SNCODE.Attribute.ID); } else { count = BLLTable <WEC_ACTIVITY_SNCODE> .Insert(valObj, WEC_ACTIVITY_SNCODE.Attribute.ID); keyid = valObj.ID.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 { txtID.Value = ""; txtSN_CODE.Value = ""; txtAWARD_TYPE.Value = ""; txtSTATUS.Value = ""; txtPHONE.Value = ""; txtWX_CODE.Value = ""; txtZJ_TIME.Value = ""; txtSY_TIME.Value = ""; txtA_ID.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["ID"])) { valObj = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["ID"]); if (valObj == null) { return; } txtID.Text = Convert.ToString(valObj.ID);//Convert.ToDecimal txtSN_CODE.Text = Convert.ToString(valObj.SN_CODE);//Convert.ToString txtAWARD_TYPE.Text = Convert.ToString(valObj.AWARD_TYPE);//Convert.ToString txtSTATUS.Text = valObj.STATUS.ToString(); txtPHONE.Text = Convert.ToString(valObj.PHONE);//Convert.ToString txtWX_CODE.Text = Convert.ToString(valObj.WX_CODE);//Convert.ToString txtZJ_TIME.Text = (valObj.ZJ_TIME == DateTime.MinValue) ? "" : valObj.ZJ_TIME.ToString("yyyy-MM-dd HH:mm"); txtSY_TIME.Text = (valObj.SY_TIME == DateTime.MinValue) ? "" : valObj.SY_TIME.ToString("yyyy-MM-dd HH:mm"); txtA_ID.Text = Convert.ToString(valObj.A_ID);//Convert.ToDecimal } } 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(); } } }