protected void FillFeild() { if (_id != "0") { model = bll.GetModel(this._id); model.templateId = this._id; } else { model.templateId = IdCreator.CreateId("T_ShortMessage_Template", "templateId"); model.isUse = 1; } model.flag = this.ddlParentCategory.SelectedValue; //标识 model.supplierId = this.ddlSupplierCategory.SelectedValue; //供应商 if (!string.IsNullOrEmpty(model.supplierId)) { ShortMsgSupModel modelSup = new ShortMsgSupBll().GetModel(model.supplierId); if (modelSup != null) { model.supplierFlag = modelSup.flag; } } model.templateCode = KillSqlIn.Form_ReplaceByString(Request.Form["txtCode"], 200); model.templateParam = KillSqlIn.Form_ReplaceByString(Request.Form["txtParam"], 200); }
protected void Page_Load(object sender, EventArgs e) { //Ajax方法 AjaxPro.Utility.RegisterTypeForAjax(typeof(AppModules_Goods_T_Forms_Resource)); if (Request.QueryString["del"] != null) { string strSQL = "delete T_Goods_Pic where sysnumber='" + KillSqlIn.Form_ReplaceByString(Request.QueryString["del"], 100) + "';"; AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance); int row = adohelper.ExecuteSqlNonQuery(strSQL); Response.Clear(); if (row > 0) { Response.Write("success"); } else { Response.Write("fail"); } Response.End(); } this.goodsId = (Request["goodsId"] == null) ? "" : StarTech.KillSqlIn.Url_ReplaceByString(Request["goodsId"], 50); if (!IsPostBack) { InitForm(); BindVideoAndPic(); } }
private string GetFilter(string searchfilter) { Hashtable hTable = JSONHelper.GetSearchFilter(searchfilter); string filter = " 1=1 "; if (hTable != null && hTable.Count > 0) { string SafeStr = ""; if (hTable.Contains("activity_title") && hTable["activity_title"].ToString().Trim() != "") { SafeStr = KillSqlIn.Form_ReplaceByString(hTable["activity_title"].ToString().Trim(), Int32.MaxValue); filter += " and activity_title like '%" + SafeStr + "%'"; } if (hTable.Contains("if_approved") && hTable["if_approved"].ToString().Trim() != "") { SafeStr = Common.NullToZero(hTable["if_approved"]).ToString(); filter += " and if_approved = " + SafeStr; } if (hTable.Contains("activity_status") && hTable["activity_status"].ToString().Trim() != "") { SafeStr = Common.NullToZero(hTable["activity_status"]).ToString(); filter += " and activity_status = " + SafeStr; } } return(filter); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { id = KillSqlIn.Form_ReplaceByString(Request.QueryString["id"], 10); } if (!IsPostBack) { if (this.id != "") { GoodsTypeModel mod = bll.GetModel(this.id); if (mod != null) { //this.ddlType.SelectedValue = mod.CategoryToTypeId; //this.ddlPCategory.SelectedValue = mod.PCategoryId; this.cSelect.categoryID = mod.PCategoryId; this.txtMenuName.Text = mod.CategoryName; this.txtSort.Text = mod.Orderby.ToString(); this.cbIsVisible.Checked = (mod.CategoryFlag == "Course") ? true : false; if (mod.Url != null) { imgUrl = "<img src='" + mod.Url + "' width='100' height='100' />"; } ViewState["Old_PId"] = mod.PCategoryId; } } else { //this.ddlPCategory.SelectedValue = this.pCatatoryId; //this.cSelect.categoryID = this.pCatatoryId; } } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = bll.GetModel(Convert.ToInt32(_Pid)); model.replyContent = this.fckBody.Text; model.replyPeople = KillSqlIn.Form_ReplaceByString(this.txtContent.Text.Trim(), 200); if (this.txtReleaseDate.Text.Trim() == "") { model.replyTime = DateTime.Now; } else { model.replyTime = DateTime.Parse(this.txtReleaseDate.Text.Trim()); } model.state = 1; if (_Pid != "SysError") { model.id = Convert.ToInt32(_Pid); } if (_Pid != "SysError") { if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('保存信息成功');layer_close_refresh();</script>"); } } }
/// <summary> /// 7.卖家完成配货 /// </summary> /// <param name="orderId"></param> /// <param name="shopId"></param> /// <returns></returns> public static int DisOrder(string orderId, string shopId) { orderId = KillSqlIn.Form_ReplaceByString(orderId, 50); shopId = KillSqlIn.Form_ReplaceByString(shopId, 50); string strSQL = " BEGIN TRANSACTION "; string strGoods = "select sysnumber=newId(),goodsId,goodsName,orderId,detailId,grabTime,1,'" + DateTime.Now + "',shopId,num from T_Order_WaitingDeal where orderId='" + orderId + "' and shopId='" + shopId + "';"; DataSet ds = adoHelper.ExecuteSqlDataset(strGoods); string goodsList = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (i != 0) { goodsList += ","; } if (ds.Tables[0].Rows[i]["shopId"].ToString() != shopId) { continue; } strSQL += "insert T_Order_GrabLog values('" + ds.Tables[0].Rows[i][0] + "','" + ds.Tables[0].Rows[i][1] + "','" + ds.Tables[0].Rows[i][2] + "','" + ds.Tables[0].Rows[i][3] + "','" + ds.Tables[0].Rows[i][4] + "','" + ds.Tables[0].Rows[i][5] + "'," + ds.Tables[0].Rows[i][6] + ",'" + ds.Tables[0].Rows[i][7] + "','" + ds.Tables[0].Rows[i][8] + "','已配货');"; strSQL += "update T_Shop_Goods set shopgoods_amount=shopgoods_amount-" + ds.Tables[0].Rows[i]["num"] + " where goodsId='" + ds.Tables[0].Rows[i][1] + "' and ShopId='" + shopId + "';"; strSQL += "update T_Order_WaitingDeal set isDis=1 where detailId='" + ds.Tables[0].Rows[i]["detailId"] + "';"; } strSQL += "if((select count(sysnumber) from T_Order_InfoDetail where orderId='" + orderId + "')=(select count(sysnumber) from T_Order_WaitingDeal where orderId='" + orderId + "' and isDis=1)) update T_Order_Info set isDis=1,disTime='" + DateTime.Now + "' where orderId='" + orderId + "';"; strSQL += " COMMIT TRANSACTION "; SqlErr(strSQL, "DisOrder"); int row = adoHelper.ExecuteSqlNonQuery(strSQL); return(row); }
/// <summary> /// 3.返回信誉参数,根绝卖家的相关条件,比如开店时间,保证金,来确认信誉,越高的信誉返回越高的值,这个值将影响卖家抢单表的速度 /// </summary> /// <returns></returns> public static float GetCredit(string shopId) { shopId = KillSqlIn.Form_ReplaceByString(shopId, 20); string strSQL = "select * from T_Shop_User where shopId='" + shopId + "';"; SqlErr(strSQL, "GetCredit"); DataSet ds = adoHelper.ExecuteSqlDataset(strSQL); float credit = 0.0f; if (ds == null || ds.Tables.Count < 1 && ds.Tables[0].Rows.Count < 1) { return(0.0f); } if (ds.Tables[0].Rows[0]["ShopMoney"] != DBNull.Value && Convert.ToDecimal(ds.Tables[0].Rows[0]["ShopMoney"]) > 0) { credit += 0.5f; } if (ds.Tables[0].Rows[0]["ApplyTime"] != DBNull.Value) { DateTime applytime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ApplyTime"]); int c = (DateTime.Now - applytime).Days / 365; credit += 0.1f * c; } return(credit); }
protected void btnSave_Click(object sender, EventArgs e) { model.flag_name = KillSqlIn.Form_ReplaceByString(Request.Form["txtTitle"], 200); //string BackUrl = "CategoryTree.aspx"; if (_id != "0") { model.flag_id = _id; bll.Update(model); ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('修改成功!');layer_close_refresh();</script>"); //JSUtility.AlertAndRedirect("修改成功!", BackUrl); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (" + _ACid + ")"; //string function = "修改"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } else { model.if_use = 1; model.flag_id = IdCreator.CreateId("T_Base_Flag", "flag_id"); bll.Add(model); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (select top 1 CategoryId from T_Category order by CategoryId desc)"; //string function = "添加"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } }
private void GetList() { string searchfilter = Request["searchfilter"] == null ? "" : KillSqlIn.Url_ReplaceByString(Server.UrlDecode(Request.QueryString["searchfilter"]), Int32.MaxValue); string rows = Request["rows"] == null ? "10" : KillSqlIn.Url_ReplaceByString(Request.QueryString["rows"], Int32.MaxValue); //显示数量 string page = Request["page"] == null ? "1" : KillSqlIn.Url_ReplaceByString(Request.QueryString["page"], Int32.MaxValue); //当前页 string sidx = Request["sidx"] == null ? "" : KillSqlIn.Url_ReplaceByString(Request.QueryString["sidx"], Int32.MaxValue); //排序字段 string sord = Request["sord"] == null ? "desc" : KillSqlIn.Url_ReplaceByString(Request.QueryString["sord"], Int32.MaxValue); //排序规则 string table = " t_task_node_config "; string fields = "node_id,node_code,node_sn,node_name,remarks,if_use, '' as cmd_col";//字段顺序和必须前台jggrid设置的一样 string filter = GetFilter(searchfilter); string sort = "order by " + sidx + " " + sord + ""; int totalRecords = 0; // bll.GetRecordCount(filter); int start = (Convert.ToInt32(page) - 1) * Convert.ToInt32(rows) + 1; int end = Convert.ToInt32(page) * Convert.ToInt32(rows); if (sidx.Equals("cmd_col")) { sort = " order by node_id asc "; } DataTable dtSource = new PaginationUtility().GetPaginationList(fields, table, filter, sort, Int32.Parse(page), Int32.Parse(rows), out totalRecords); EditDataSource(ref dtSource); int totalPages = JSONHelper.GetTotalPages(totalRecords, Int32.Parse(rows)); string json = JSONHelper.ToJGGridJson(page, totalPages.ToString(), totalRecords.ToString(), dtSource, fields.Replace("'' as ", "").Split(','), "node_id"); Response.Write(json); Response.End(); }
protected void btnSubmit_Click(object sender, EventArgs e) { SearchCodeInfo search = new SearchCodeInfo(); string ticket = search.GetAuthorizationTicket("xingzhen", "xz20100722"); JgdmInfo info = search.GetJgdmDetail(ticket, txtjgdm.Text.Trim().Replace("-", "").Replace("-", "")); if (info.State == "000001") { MemberInfoModel model = new MemberInfoModel(); if (checkUsername(KillSqlIn.Form_ReplaceByString(this.txtname.Text, 20)) == "0") { model.memberName = KillSqlIn.Form_ReplaceByString(this.txtname.Text, 20); model.password = KillSqlIn.Form_ReplaceByString(this.txtpw.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密 model.memberLevel = "20"; model.memberType = type; model.memberCompanyType = ""; model.areaName = ""; model.memberCompanyName = info.jgmc; model.memberCompanyCode = txtjgdm.Text; model.memberTrueName = ""; model.sex = ""; model.tel = ""; model.fax = ""; model.mobile = ""; model.address = ""; model.post = ""; model.email = ""; model.regTime = System.DateTime.Now; model.shFlag = 1; model.shTime = DateTime.Now; model.shPerson = "SYS"; model.unPassReason = ""; model.memberStatus = "ZC";//正常:ZC 禁用:JY model.buyMoneyAccount = 0; model.buyMoneyAccountUsed = 0; model.freeMoenyAccount = 0; model.freeMoenyAccountUsed = 0; int i = new MemberInfoBLL().Add(model); if (i > 0) { Session["MemberId"] = i.ToString(); Response.Write("<script>alert('注册成功!');layer_close();</script>"); } else { Response.Write("<script>alert('注册失败!');</script>"); } } else { Response.Write("<script>alert('该用户名已存在!');layer_close();</script>"); } } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('组织机构代码错误!');</script>"); return; } }
protected void btnSubmit_Click(object sender, EventArgs e) { model = bll.GetModel1(_Pid); model.value = KillSqlIn.Form_ReplaceByString(this.txtValue.Text, 200); model.Price = Convert.ToDecimal(this.txtPrice.Text); model.IsDefault = Convert.ToInt32(this.CheckDefault.SelectedValue); if (model != null) { if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model = new Goods_ServiceDetailModel(); model.sysnumber = Guid.NewGuid().ToString(); model.serviceId = _Pid; model.value = KillSqlIn.Form_ReplaceByString(this.txtValue.Text, 200); model.Price = Convert.ToDecimal(this.txtPrice.Text); model.IsDefault = Convert.ToInt32(this.CheckDefault.SelectedValue); if (bll.Add(model) != null) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('设置成功');layer_close_refresh();</script>"); } } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { string signname = KillSqlIn.Form_ReplaceByString(txtSignName.Text, 20); string remark = KillSqlIn.Form_ReplaceByString(txtRemark.Text, 20); AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance); string strSQL = ""; if (id == "") { DateTime atime = DateTime.Now; strSQL = "insert T_Goods_Sign values('" + signname + "','" + remark + "','" + atime + "');"; } else { strSQL = "update T_Goods_Sign set signName='" + signname + "',remark='" + remark + "' where signid='" + id + "';"; } int rows = adohelper.ExecuteSqlNonQuery(strSQL); if (rows > 0) { if (id == "") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('添加成功');layer_close_refresh();</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('修改成功');layer_close_refresh();</script>"); } } }
public GoodsModel GetModel() { model = new GoodsModel(); model.serviceId = Guid.NewGuid().ToString(); model.serviceName = KillSqlIn.Form_ReplaceByString(this.txtName.Text, 50); model.serviceContext = KillSqlIn.Form_ReplaceByString(this.txtMethod.Text, 200); model.orderby = string.IsNullOrEmpty(txtSort.Text) ? 0 : Convert.ToInt32(txtSort.Text, 10); return(model); }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model.Title = KillSqlIn.Form_ReplaceByString(this.txtTitle.Text, 100); model.DisplayMode = Convert.ToInt32(this.RadioButtonList1.SelectedValue); model.CategoryId = Convert.ToInt32(this.DrCategory.SelectedValue); model.Link = KillSqlIn.Form_ReplaceByString(this.txtLink.Text.Trim(), 100); model.sort = Convert.ToInt32(KillSqlIn.Form_ReplaceByString(this.txtSort.Text, 10)); model.StartTime = !string.IsNullOrEmpty(this.txtStartTime.Text) ? Convert.ToDateTime(this.txtStartTime.Text) : System.DateTime.Now; model.EndTime = !string.IsNullOrEmpty(this.txtEndTime.Text) ? Convert.ToDateTime(this.txtEndTime.Text) : System.DateTime.Now.AddDays(7); #region 保存图片 if (!this.picUpload.Value.Equals("")) { string FileTZM = this.picUpload.PostedFile.FileName.Substring(this.picUpload.PostedFile.FileName.LastIndexOf(".") + 1);//得到文件的扩展名 if (!IsPic(FileTZM.ToLower())) { JSUtility.Alert("上传图片格式不正确!"); return; } if (this.picUpload.PostedFile.ContentLength > 1048576) { JSUtility.Alert("上传图片过大!"); return; } Random rnd = new Random(); string UpLoadFileTime = DateTime.Now.ToString("HHmmss") + rnd.Next(9999).ToString("0000"); //生成一个新的数图片名称 string fileName = UpLoadFileTime + "." + FileTZM; //产生上传图片的名称 if (!Directory.Exists(Request.MapPath("~/upload/Link/"))) { Directory.CreateDirectory(Request.MapPath("~/upload/Link/")); } string Url = Request.MapPath("~/upload/Link/" + fileName); picUpload.PostedFile.SaveAs(Url); model.Image = "/upload/Link/" + fileName; } else { model.Image = ViewState["Image"] == null ? "" : ViewState["Image"].ToString(); } #endregion if (_Pid != "SysError") { model.AdId = Convert.ToInt32(_Pid); if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { if (bll.Add(model) != 0) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
protected void Page_Load(object sender, EventArgs e) { _id = KillSqlIn.Url_ReplaceByNumber(Request.QueryString["id"], 10); _rd = KillSqlIn.Url_ReplaceByNumber(Request.QueryString["rd"], 10); if (!IsPostBack) { //BindArticleCateoryDrp(); CheckPopedom(); } }
public AreaModel GetModel() { model = new AreaModel(); model.area_id = KillSqlIn.Form_ReplaceByString(this.txtAreaId.Text, 100); model.area_name = KillSqlIn.Form_ReplaceByString(this.txtName.Text, 200); model.area_pid = ddlPid.SelectedValue.Equals("0") ? "0" : ddlPid.SelectedValue; model.area_level = ddlPid.SelectedValue.Equals("0") ? 1 : bll.GetModel(model.area_pid).area_level + 1; model.orderby = string.IsNullOrEmpty(txtSort.Text) ? 0 : Convert.ToInt32(txtSort.Text, 10); return(model); }
private void AddXHMember() { if (checkUsername(this.txtMemberName.Text.Trim()) == "1") { Response.Write("<script>alert('该协会会员已存在!');</script>"); } else { try { MemberInfoModel model = new MemberInfoModel(); model.memberName = KillSqlIn.Form_ReplaceByString(this.txtMemberName.Text, 20); model.password = KillSqlIn.Form_ReplaceByString(this.txtPwd.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密 model.memberLevel = "0"; model.memberType = type; // model.memberCompanyType = this.ddlMemberType.SelectedValue; model.memberCompanyType = GetHyType(); model.areaName = ""; model.memberCompanyName = txtXHName.Text; model.memberCompanyCode = ""; model.memberTrueName = txtTrueName.Text; model.sex = ""; model.tel = txtTel.Text; model.fax = ""; model.mobile = ""; model.address = this.txtAddress.Text; model.post = ""; model.email = ""; model.regTime = System.DateTime.Now; model.shFlag = 1; model.shTime = DateTime.Now; model.shPerson = " "; model.unPassReason = ""; model.memberStatus = "ZC";//正常:ZC 禁用:JY model.buyMoneyAccount = 0; model.buyMoneyAccountUsed = 0; model.freeMoenyAccount = 0; model.freeMoenyAccountUsed = 0; int i = new MemberInfoBLL().Add(model); if (i > 0) { Response.Write("<script>alert('添加成功!');layer_close();</script>"); } else { Response.Write("<script>alert('添加失败!');</script>"); } } catch (Exception ee) { Response.Write("<script>alert('出错了, 原因:'" + ee.Message + "'');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { id = KillSqlIn.Form_ReplaceByString(Request.QueryString["id"], 10); if (!IsPostBack) { GetSign(); } } }
public MarketModel GetModel() { model = new MarketModel(); model.Market_id = KillSqlIn.Form_ReplaceByString(this.txtMarketId.Text, 100); model.Market_name = KillSqlIn.Form_ReplaceByString(this.txtMarketName.Text, 200); model.Area_id = ddlAreaId.SelectedValue.Equals("0") ? "0" : ddlAreaId.SelectedValue; model.Map_x = KillSqlIn.Form_ReplaceByString(this.txtMapX.Text, 100); model.Map_y = KillSqlIn.Form_ReplaceByString(this.txtMapY.Text, 100); model.orderby = string.IsNullOrEmpty(txtSort.Text) ? 0 : Convert.ToInt32(txtSort.Text, 10); return(model); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["categoryId"] != null) { categoryId += "&categoryId=" + KillSqlIn.Form_ReplaceByString(Request.QueryString["categoryId"], 20); } if (!IsPostBack) { BindTreeView(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { memberId = KillSqlIn.Form_ReplaceByString(Request.QueryString["id"], 20); if (memberId == "") { return; } GetMember(memberId); } }
public BuildingModel GetModel() { model = new BuildingModel(); model.Building_id = KillSqlIn.Form_ReplaceByString(this.txtBuildingId.Text, 100); model.Building_name = KillSqlIn.Form_ReplaceByString(this.txtBuildingName.Text, 200); model.Area_id = ddlAreaId.SelectedValue.Equals("0") ? "0" : ddlAreaId.SelectedValue; model.Map_x = KillSqlIn.Form_ReplaceByString(this.txtMapX.Text, 100); model.Map_y = KillSqlIn.Form_ReplaceByString(this.txtMapY.Text, 100); model.orderby = string.IsNullOrEmpty(txtSort.Text) ? 0 : Convert.ToInt32(txtSort.Text, 10); model.AddressDetail = KillSqlIn.Form_ReplaceByString(this.txtAddressDetail.Text, 250); return(model); }
/// <summary> /// 保存关键字信息 /// </summary> void UpdateData(int index, int type, string keywordList) { string sqlKy = KillSqlIn.Form_ReplaceByString(keywordList, 300); string strSQL = " update T_News set ShareToMarket=substring(ShareToMarket,2,500) where (patindex('%,%',ShareToMarket))=1 ;"; strSQL += " update T_News set ShareToSubject=substring(ShareToSubject,2,500) where (patindex('%,%',ShareToSubject))=1 ;"; strSQL += "update T_News set ShareToPlatform=substring(ShareToPlatform,2,500) where (patindex('%,%',ShareToPlatform))=1"; strSQL += " if((select count(*) from T_ShareNews where ShareIndex=" + index + " and ShareType=" + type + ")=0) "; strSQL += " insert T_ShareNews values(" + index + "," + type + ",'" + sqlKy + "','');"; strSQL += " else "; strSQL += " update T_ShareNews Set ShareIndex=" + index + ",ShareType=" + type + ",KeywordList='" + sqlKy + "' where ShareIndex=" + index + " and ShareType=" + type + ";"; AdoHelper helper = AdoHelper.CreateHelper("DB_Instance"); int row = helper.ExecuteSqlNonQuery(strSQL); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { task_id.Value = KillSqlIn.Form_ReplaceByString(Request.QueryString["id"], 20); if (task_id.Value == "") { return; } GetInfo(task_id.Value); } } }
protected void Page_Load(object sender, EventArgs e) { _Pid = KillSqlIn.Url_ReplaceByString(Request.QueryString["id"], 40); if (!IsPostBack) { if (_Pid != "SysError") { _pageTitle = "加工费设置"; GetAreaInfo(); } else { _pageTitle = "加工费设置"; } } }
protected void Page_Load(object sender, EventArgs e) { rd = Request.QueryString["rd"] == null ? "0" : KillSqlIn.Url_ReplaceByNumber(Request.QueryString["rd"].ToString(), 5); _Lid = Request.QueryString["LinkId"] == null ? "0" : KillSqlIn.Url_ReplaceByNumber(Request.QueryString["LinkId"].ToString(), 5); if (!IsPostBack) { BindLinkCateory(); CheckPopedom(); if (rd == "1") { SetReadOnlyPanel("readonly_input"); LinkButton1.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { _Pid = Server.UrlDecode(KillSqlIn.Url_ReplaceByString(Request.QueryString["id"], 30)); if (!IsPostBack) { if (_Pid != "SysError") { _pageTitle = "广告信息编辑"; GetAreaInfo(); } else { _pageTitle = "广告信息添加"; } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] == null) { return; } id = KillSqlIn.Form_ReplaceByString(Request.QueryString["id"], 50); if (id == "") { return; } if (!IsPostBack) { BindInfo(); } }
/// <summary> /// 完成签收 /// </summary> /// <param name="OrderId"></param> /// <param name="refuseContext"></param> /// <returns></returns> public static int Complete(string OrderId, string completeContext) { OrderId = KillSqlIn.Form_ReplaceByString(OrderId, 50); completeContext = KillSqlIn.Form_ReplaceByString(completeContext, 500); string strSQL = "update T_Order_info set isGet=1,gettime='" + DateTime.Now + "',GetRemarks='【派送员确认】" + completeContext + "' where orderId='" + OrderId + "';"; int rows = adoHelper.ExecuteSqlNonQuery(strSQL); if (rows > 0) { return(1); } else { return(0); } }
private void Update_AddXZMember() { try { MemberInfoModel model = new MemberInfoModel(); model.memberId = id; model.memberName = KillSqlIn.Form_ReplaceByString(this.txtXZMember.Text, 20); model.password = KillSqlIn.Form_ReplaceByString(this.txtXZPwd.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密 model.memberLevel = "0"; model.memberType = type; model.memberCompanyType = this.txtXZType.Text;//部门名称 model.areaName = ""; model.memberCompanyName = this.txtXZName.Text; model.memberCompanyCode = ""; model.memberTrueName = txtXZTrueName.Text; model.sex = ""; model.tel = txtXZTel.Text; model.fax = ""; model.mobile = ""; model.address = ""; model.post = ""; model.email = ""; model.regTime = System.DateTime.Now; model.shFlag = 1; model.shTime = DateTime.Now; model.shPerson = " "; model.unPassReason = ""; model.memberStatus = "ZC";//正常:ZC 禁用:JY model.buyMoneyAccount = 0; model.buyMoneyAccountUsed = 0; model.freeMoenyAccount = 0; model.freeMoenyAccountUsed = 0; int i = new MemberInfoBLL().Update(model); if (i > 0) { Response.Write("<script>alert('修改成功!');layer_close();</script>"); } else { Response.Write("<script>alert('修改失败!');</script>"); } } catch (Exception ee) { Response.Write("<script>alert('出错了, 原因:'" + ee.Message + "'');</script>"); } }