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 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) { 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; } } }
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(); } }
/// <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); } }
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 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>"); } } }
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>"); } } }
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()); } } }
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); }
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(); } }
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 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); }
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); } }
/// <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) { 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>"); } }
/// <summary> /// 拒绝签收 /// </summary> /// <param name="OrderId"></param> /// <param name="refuseContext"></param> /// <returns></returns> public static int RefuseGet(string OrderId, string refuseContext) { OrderId = KillSqlIn.Form_ReplaceByString(OrderId, 50); refuseContext = KillSqlIn.Form_ReplaceByString(refuseContext, 500); string strSQL = "update T_Order_info set isdis=0,isRefuseGet=1,isPostmanConfirm=0,refuseTime='" + DateTime.Now + "',refuseContext='" + refuseContext + "' where orderId='" + OrderId + "';"; int rows = adoHelper.ExecuteSqlNonQuery(strSQL); if (rows > 0) { adoHelper.ExecuteSqlNonQuery("update T_Order_WaitingDeal set isdis=0 where orderId='" + OrderId + "' "); return(1); } else { return(0); } }
protected void btSend_Click(object sender, EventArgs e) { string mobile = KillSqlIn.Form_ReplaceByString(txtPhone.Text, 20); string url = "http://elife2.hzst.com/ServiceInterface/Member/Mobile.ashx?flag=yzm&mobile=" + mobile; Response.Redirect(url); return; //WebRequest r = WebRequest.Create(url); //WebResponse response = r.GetResponse(); //StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding("gb2312")); //string str = reader.ReadToEnd(); //reader.Close(); //reader.Dispose(); //response.Close(); //txtYZM.Text = str; }
/// <summary> /// 6.取消已经抢到的订单 /// </summary> /// <param name="orderId"></param> /// <param name="shopId"></param> /// <returns></returns> public static int CancelGrabOrder(string orderId, string shopId) { orderId = KillSqlIn.Form_ReplaceByString(orderId, 50); shopId = KillSqlIn.Form_ReplaceByString(shopId, 50); string strSQL = "update T_Order_WaitingDeal set isGrab=0 , GrabTime=getdate(), shopId='" + shopId + "' where orderId='" + orderId + "';"; string strGoods = "select sysnumber=newId(),goodsId,goodsName,orderId,detailId,grabTime,0,1991-1-1,shopId from T_Order_WaitingDeal where orderId='" + orderId + "';"; DataSet ds = adoHelper.ExecuteSqlDataset(strGoods); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { 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_Order_InfoDetail set ProviderInfo='' where orderId='" + orderId + "';"; SqlErr(strSQL, "CancelGrabOrder"); int row = adoHelper.ExecuteSqlNonQuery(strSQL); return(row); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { serviceId = KillSqlIn.Form_ReplaceByString(Request.QueryString["id"], 50); string strSQL = "select * from T_Goods_Service where serviceId='" + serviceId + "';"; strSQL += "select * from T_Goods_ServiceDetail where serviceId='" + serviceId + "';"; ds = adoHelper.ExecuteSqlDataset(strSQL); if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1) { return; } if (!IsPostBack) { BindData(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["courseId"] != null) { this.hidCourseId.Value = Request.QueryString["courseId"]; courseId = KillSqlIn.Form_ReplaceByString(Request.QueryString["courseId"], 20); } if (Request.QueryString["courseId"] != null) { this.hidTestSysnumber.Value = Request.QueryString["testSysnumber"]; testSysnumber = KillSqlIn.Form_ReplaceByString(Request.QueryString["testSysnumber"], 50); } if (!IsPostBack) { this.dtAll = GetAll(); BindTreeView(); } }