protected void btSubmit_Click(object sender, EventArgs e) { string strSql, strID, strTitle, strKeyWords, strDescription, strAuthor, strPageNameCalled; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strTitle = tbSeo_Title.Text; strKeyWords = tbSeo_Keywords.Text; strDescription = tbSeo_Description.Text; strAuthor = tbSeo_Author.Text; strPageNameCalled = tbPageNameCalled.Text; FunctionClass myFun = new FunctionClass(); strSql = "update T_Seo set Title=@Title,KeyWords=@KeyWords,Description=@Description,Author=@Author,PageNameCalled=@PageNameCalled where ID=@ID"; string[] ParamsName = new string[] { "@Title", "@KeyWords", "@Description", "@Author", "@ID", "@PageNameCalled" }; string[] ParamsValue = new string[] { strTitle, strKeyWords, strDescription, strAuthor, strID, strPageNameCalled }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID, strSql; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); strSql = "select * from T_PayType where ID=" + strID; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { tbTypeCalled.Text = myDr["TypeCalled"].ToString(); tbTip.Text = myDr["Tip"].ToString(); tbMemo.Text = myDr["Memo"].ToString(); cblIsShow.SelectedValue = myDr["IsShow"].ToString(); } myDr.Close(); myDr.Dispose(); myData.ConnClose(myConn); }
protected void btSubmit_Click(object sender, EventArgs e) { string strPID, strTypeCalled, strIsShow, strSql, strID; strID = Request.QueryString["id"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL地址错误!"); Response.End(); } strPID = ddlType.SelectedValue; strTypeCalled = tbTypeCalled.Text; strIsShow = cblIsShow.SelectedValue; //判断是否选自己为父ID if (strPID == strID) { FunctionClass.ShowMsgBox("不能选自己为父类别!"); Response.End(); } strSql = "update T_NewType set PID=@PID,TypeCalled=@TypeCalled,IsShow=@IsShow where ID=@ID"; string[] ParamsName = new string[] { "@PID", "@TypeCalled", "@IsShow", "@ID" }; string[] ParamsValue = new string[] { strPID, strTypeCalled, strIsShow, strID }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
/// <summary> /// 提交修改信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btSubmit_Click(object sender, EventArgs e) { string strID, strSql, strMemo; strMemo = tbMemo.Text; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { strID = "1"; } strSql = "update T_Info set Memo=@Memo where ID=@ID"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); string[] ParamsName = new string[] { "@Memo", "@ID" }; string[] ParamsValue = new string[] { strMemo, strID }; myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("信息更新成功!", FunctionClass.PageURL); Response.End(); }
protected void btSubmit_Click(object sender, EventArgs e) { string strID, strTip, strTypeCalled, strMemo, strIsShow, strSql; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strTypeCalled = tbTypeCalled.Text; strTip = tbTip.Text; strMemo = tbMemo.Text; strIsShow = cblIsShow.SelectedValue; strSql = "update T_PayType set Tip=@Tip,TypeCalled=@TypeCalled,IsShow=@IsShow,Memo=@Memo where ID=@ID"; string[] ParamsName = new string[] { "@Tip", "@TypeCalled", "@IsShow", "@Memo", "@ID" }; string[] ParamsValue = new string[] { strTip, strTypeCalled, strIsShow, strMemo, strID }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
protected void btSubmit_Click(object sender, EventArgs e) { string strID, strUserID, strPrice, strPayType, strIsShow, strMemo, strSql; strUserID = tbUserID.Text; strPrice = tbPrice.Text; strPayType = ddlPayType.SelectedValue; strIsShow = cblIsShow.SelectedValue; strMemo = tbMemo.Text; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strSql = "update T_PayLog set UserID=@UserID,Price=@Price,PayType=@PayType,IsShow=@IsShow,Memo=@Memo,NoteTime=getDate() where ID=@ID"; string[] ParamsName = new string[] { "@UserID", "@Price", "@PayType", "@IsShow", "@ID", "@Memo" }; string[] ParamsValue = new string[] { strUserID, strPrice, strPayType, strIsShow, strID, strMemo }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); long id = myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
protected void Button1_Click(object sender, EventArgs e) { //判断参数是否正确 string strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } //打开数据库连接 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //获取数据集 string strSql = "update T_User set AutoCheck=1 where ID=@ID"; string[] ParamsName = new string[] { "@ID" }; string[] ParamsValue = new string[] { strID }; myData.InsertData(strSql, ParamsName, ParamsValue, myConn); FunctionClass.ShowMsgBox("确认审核成功成功!", ""); //关闭数据库连接 myData.ConnClose(myConn); }
/// <summary> /// 点击删除所选按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void myTbDel_Click(object sender, EventArgs e) { string strSql, strNewType, strKeyWord, strTypeSql; strNewType = Request.QueryString["NewType"]; strKeyWord = Request.QueryString["KeyWord"]; strSql = "select ID from T_News where 1=1"; //判断是否有分类参数 if (strNewType == null || strNewType == "") { strNewType = "0";//0表示所有分类 } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //判断在不是0的情况下,加条件 if (strNewType != "0") { strTypeSql = myData.GetNewTypeIDSql(strNewType, myConn); if (strTypeSql.Length >= 4) { strTypeSql = FunctionClass.LeftString(strTypeSql, strTypeSql.Length - 4); strTypeSql = " or " + strTypeSql; } strSql += " and (NewType= " + strNewType + strTypeSql + ")";//加分类条件 } //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and Title like '%" + strKeyWord.Replace("'", "''") + "%'"; } strSql += " order by SID asc,id desc"; DataSet myDs = myData.GetDataSet(strSql, myConn); for (int i = 0; i < myDs.Tables[0].Rows.Count; i++) { string strRowID = myDs.Tables[0].Rows[i]["ID"].ToString(); CheckBox myTB = (CheckBox)form1.FindControl("cbSel_" + strRowID); if (myTB != null) { if (myTB.Checked) { myData.ExecuteSql("delete from T_News where ID=" + strRowID, myConn); } } } myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("删除成功!", ""); Response.End(); }
/// <summary> /// 点击更新排序按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void myTbOrder_Click(object sender, EventArgs e) { string strSql, strTypeID, strKeyWord, strTypeSql; strTypeID = Request.QueryString["TypeID"]; strKeyWord = Request.QueryString["KeyWord"]; strSql = "select ID from T_Products where 1=1"; //判断是否有分类参数 if (strTypeID == null || strTypeID == "") { strTypeID = "0";//0表示所有分类 } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //判断在不是0的情况下,加条件 if (strTypeID != "0") { strTypeSql = myData.GetProTypeIDSql(strTypeID, myConn); if (strTypeSql.Length >= 4) { strTypeSql = FunctionClass.LeftString(strTypeSql, strTypeSql.Length - 4); strTypeSql = " or " + strTypeSql; } strSql += " and (TypeID= " + strTypeID + strTypeSql + ")";//加分类条件 } //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and ProName like '%" + strKeyWord.Replace("'", "''") + "%'"; } strSql += " order by SID asc,id desc"; DataSet myDs = myData.GetDataSet(strSql, myConn); for (int i = 0; i < myDs.Tables[0].Rows.Count; i++) { string strRowID = myDs.Tables[0].Rows[i]["ID"].ToString(); TextBox myTB = (TextBox)form1.FindControl("SID_" + strRowID); if (myTB != null) { myData.ExecuteSql("update T_Products set SID=" + myTB.Text + " where ID=" + strRowID, myConn); } } myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("更新成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID, strSql; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet("select * from T_UserType order by sid,id", myConn); ddlUserType.DataSource = myDs; ddlUserType.DataTextField = "TypeCalled"; ddlUserType.DataValueField = "ID"; ddlUserType.DataBind(); myDs.Dispose(); strSql = "select * from T_User where ID=" + strID; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { tbUserName.Text = myDr["UserName"].ToString(); tbMobile.Text = myDr["Mobile"].ToString(); tbMobile.ToolTip = myDr["Mobile"].ToString(); tbPassWord.Text = myDr["PassWord"].ToString(); tbTel.Text = myDr["Tel"].ToString(); tbFax.Text = myDr["Fax"].ToString(); tbEMail.Text = myDr["EMail"].ToString(); tbCompany.Text = myDr["Company"].ToString(); tbAddress.Text = myDr["Address"].ToString(); cblIsLock.SelectedValue = myDr["IsLock"].ToString(); ddlUserType.SelectedValue = myDr["UserType"].ToString(); tbQQ.Text = myDr["QQ"].ToString(); tbMemo.Text = myDr["Memo"].ToString(); if (myDr["AutoCheck"].ToString() == "1") { plbt.Visible = false; } else { plbt.Visible = true; } } myDr.Close(); myDr.Dispose(); myData.ConnClose(myConn); }
protected void btSubmit_Click(object sender, EventArgs e) { string strID, strPID, strTitle, strLink, strIsShow, strAdminUser, strSql; strPID = ddlPID.SelectedValue; strTitle = tbTitle.Text; strLink = tbLink.Text; strIsShow = cblIsShow.SelectedValue; strAdminUser = ""; strID = Request.QueryString["id"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } //获取选中用户 for (int i = 0; i < cblAdminUser.Items.Count; i++) { if (cblAdminUser.Items[i].Selected) { strAdminUser += "|" + cblAdminUser.Items[i].Value + "|"; } } strSql = "update T_AdminMenu set PID=@PID,Title=@Title,Link=@Link,IsShow=@IsShow,AdminUser=@AdminUser where ID=@ID"; string[] ParamsName = new string[] { "@PID", "@Title", "@Link", "@IsShow", "@AdminUser", "@ID" }; string[] ParamsValue = new string[] { strPID, strTitle, strLink, strIsShow, strAdminUser, strID }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); long id = myData.InsertData(strSql, ParamsName, ParamsValue, myConn); //获取选中用户 for (int i = 0; i < cblAdminUser.Items.Count; i++) { if (cblAdminUser.Items[i].Selected) { strSql = "update T_Admin set UserMenu=UserMenu+'|" + strID + "|' where ID=" + cblAdminUser.Items[i].Value; } else { strSql = "update T_Admin set UserMenu=Replace(UserMenu,'|" + strID + "|','') where ID=" + cblAdminUser.Items[i].Value; } myData.ExecuteSql(strSql, myConn); } myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID, strSql; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strSql = "select * from T_OrderFormStatus order by sid,id;select * from T_OrderForm where ID=" + strID; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); ddlStatus.DataTextField = "TypeCalled"; ddlStatus.DataValueField = "ID"; ddlStatus.DataSource = myDs.Tables[0]; ddlStatus.DataBind(); DataView myDv = new DataView(myDs.Tables[1], "", "", DataViewRowState.CurrentRows); if (myDv.Count > 0) { ddlStatus.SelectedValue = myDv[0]["Status"].ToString(); ddlStatus.ToolTip = myDv[0]["Status"].ToString(); tbPrice.Text = myDv[0]["Price"].ToString(); tbPrice.ToolTip = myDv[0]["Price"].ToString(); tbPayPrice.Text = myDv[0]["PayPrice"].ToString(); cblIsBilling.SelectedValue = myDv[0]["IsBilling"].ToString(); lbPro.Text = myDv[0]["ProName"].ToString(); lbProName.Text = "<b>" + myDv[0]["ProName"].ToString() + " 下单时间:" + myDv[0]["NoteTime"].ToString() + "</b><br>" + myDv[0]["Detail"].ToString(); lbProName.ToolTip = myDv[0]["ProID"].ToString(); lbUserName.Text = myDv[0]["UserName"].ToString(); lbUserName.ToolTip = myDv[0]["UserID"].ToString(); tbMobile.Text = myDv[0]["Mobile"].ToString(); tbTel.Text = myDv[0]["Tel"].ToString(); tbFax.Text = myDv[0]["Fax"].ToString(); tbAddress.Text = myDv[0]["Address"].ToString(); tbEMail.Text = myDv[0]["EMail"].ToString(); tbCompany.Text = myDv[0]["Company"].ToString(); tbMemo.Text = myDv[0]["Memo"].ToString(); } myDv.Dispose(); myDs.Dispose(); myData.ConnClose(myConn); }
/// <summary> /// 删除图片 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtDelPic_Click(object sender, EventArgs e) { string strSql, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } string[] arrTs = ((LinkButton)sender).ToolTip.Split('|'); if (arrTs.Length == 2) { strSql = "update T_Products set ProPic"; if (arrTs[0] == "2") { strSql += "1"; } else if (arrTs[0] == "3") { strSql += "2"; } else if (arrTs[0] == "4") { strSql += "3"; } strSql += "='' where ID=" + strID; //更新数据 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.ExecuteSql(strSql, myConn); myData.ConnClose(myConn); //删除文件 if (arrTs[1].ToString().Trim() != "") { string strFilePath = Server.MapPath("../" + FunctionClass.GetUploadFileRelativeURL(arrTs[1])); if (System.IO.File.Exists(strFilePath)) { System.IO.File.Delete(strFilePath); } } FunctionClass.ShowMsgBox("删除成功!", "pro_mod.aspx?id=" + strID); } }
/// <summary> /// 绑定和读取数据 /// </summary> private void BindData() { //定义变量 string strSql, strID, strNewType; //赋值变量 strNewType = Request.QueryString["NewType"]; strID = Request.QueryString["id"]; //判断变量 if (!FunctionClass.CheckStr(strNewType, 1)) { strNewType = "1"; } if (!FunctionClass.CheckStr(strID, 1)) { strID = "3"; } //打开数据库连接 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); strSql = "select * from V_News where isShow=1 and id=" + strID; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { lbTitle.Text = myDr["Title"].ToString(); lbNoteTime.Text = myDr["NoteTime"].ToString(); lbOrigin.Text = myDr["Origin"].ToString(); lbAuthor.Text = myDr["Author"].ToString(); lbContent.Text = myDr["Content"].ToString(); include_head1.strSeoTitle = myDr["Seo_Title"].ToString(); include_head1.strSeoKeywords = myDr["Seo_Keywords"].ToString(); include_head1.strSeoDescription = myDr["Seo_Description"].ToString(); include_head1.strSeoAuthor = myDr["Seo_Author"].ToString(); lbCalled.Text = "新闻中心"; lbCalled1.Text = "News Center"; hyCalled.Text = "新闻中心"; hyCalled.NavigateUrl = "news.aspx"; } myDr.Close(); myDr.Dispose(); //关闭数据库连接 myData.ConnClose(myConn); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strSql, strID; strID = Request.QueryString["id"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL地址错误!"); Response.End(); } strSql = "select * from T_ProType order by PID,SID;select * from T_ProType where ID=" + strID; ddlType.Items.Add(new ListItem("无", "0")); DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); myData.InitProTypeList(myDs.Tables[0], 0, ddlType, ""); if (myDs.Tables[1].Rows.Count > 0) { ddlType.SelectedValue = myDs.Tables[1].Rows[0]["PID"].ToString(); tbTypeCalled.Text = myDs.Tables[1].Rows[0]["TypeCalled"].ToString(); if (myDs.Tables[1].Rows[0]["IsShow"].ToString() == "1") { cblIsShow.SelectedValue = "1"; } else { cblIsShow.SelectedValue = "0"; } tbContent.Text = myDs.Tables[1].Rows[0]["Memo"].ToString(); } else { myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("没有找到这条信息!"); Response.End(); } myDs.Dispose(); myData.ConnClose(myConn); }
/// <summary> /// 删除数据 /// </summary> private void DelData() { string strDel; strDel = Request.QueryString["del"]; if (FunctionClass.CheckStr(strDel, 1)) { DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.ExecuteSql("delete from T_PayLog where ID=" + strDel, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("删除成功!", ""); Response.End(); } }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID, strSql; strID = Request.QueryString["ID"]; //如果为空,默认第一条 if (strID == null || strID == "") { strID = "1"; } else { laMeno1.Text = ""; laMeno2.Text = ""; } if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL参数格式输入错误!"); Response.End(); } strSql = "select * from T_Info order by SID asc"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); //初始化下拉列表数据 while (myDr.Read()) { ddlType.Items.Add(new ListItem(myDr["Called"].ToString(), myDr["ID"].ToString())); if (strID == myDr["ID"].ToString()) { ddlType.SelectedValue = myDr["ID"].ToString(); tbMemo.Text = myDr["Memo"].ToString(); } } myDr.Close(); myDr.Dispose(); myData.ConnClose(myConn); Session["UserViewURL"] = FunctionClass.PageURL; }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet("select * from T_PayType order by sid,id;select * from V_PayLog where ID=" + strID, myConn); ddlPayType.DataTextField = "TypeCalled"; ddlPayType.DataValueField = "ID"; ddlPayType.DataSource = myDs; ddlPayType.DataBind(); myDs.Dispose(); ddlPayType.Items.Insert(0, new ListItem("请选择", "0")); //赋值 DataView myDv = new DataView(myDs.Tables[1], "", "", DataViewRowState.CurrentRows); if (myDv.Count > 0) { tbUserName.Text = myDv[0]["UserName"].ToString() + "[" + myDv[0]["Mobile"].ToString() + "]"; tbUserID.Text = myDv[0]["UserID"].ToString(); tbPrice.Text = myDv[0]["Price"].ToString(); ddlPayType.SelectedValue = myDv[0]["PayType"].ToString(); cblIsShow.SelectedValue = myDv[0]["IsShow"].ToString(); } myDv.Dispose(); myData.ConnClose(myConn); tbPrice.Attributes.Add("onKeyUp", "value=value.replace(/[^\\-\\.\\d]/g,'')"); tbUserName.Attributes.Add("onKeyUp", "GetUserList('" + lbUserList.ClientID + "',MM_findObj('" + tbUserName.ClientID + "').value)"); }
/// <summary> /// 绑定和读取数据 /// </summary> private void BindData() { //定义变量 string strSql, strID; //赋值变量 strID = Request.QueryString["ID"]; //判断变量 if (!FunctionClass.CheckStr(strID, 1)) { strID = "3"; } //打开数据库连接 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); strSql = "select * from T_Info where ID=" + strID; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { lbInfo3.Text = myDr["Memo"].ToString(); lbCalled.Text = myDr["Called"].ToString(); hyCalled.Text = myDr["Called"].ToString(); hyCalled.NavigateUrl = "about.aspx?id=" + strID; //判断英文 if (strID == "3") { lbCalled1.Text = "ABOUT US"; } else if (strID == "4") { lbCalled1.Text = "CONTACT US"; } } myDr.Close(); myDr.Dispose(); //关闭数据库连接 myData.ConnClose(myConn); }
protected void btSubmit_Click(object sender, EventArgs e) { string strID, strRealName, strTel, strEMail, strQQ, strIsShow, strTitle, strMemo, strReplyTime, strReply, strSql; string strIsRecommend, strAddress; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strRealName = tbRealName.Text; strTel = tbTel.Text; strEMail = tbEMail.Text; strQQ = tbQQ.Text; strIsShow = cblIsShow.SelectedValue; strTitle = tbTitle.Text; strMemo = tbMemo.Text; strReplyTime = tbReplyTime.Text; strReply = tbReply.Text; strIsRecommend = rblIsRecommend.SelectedValue; strAddress = tbAddress.Text; strSql = "update T_Book set RealName=@RealName,Tel=@Tel,EMail=@EMail,QQ=@QQ,IsShow=@IsShow,Title=@Title," + "Memo=@Memo,ReplyTime=@ReplyTime,Reply=@Reply,IsRecommend=@IsRecommend,Address=@Address where ID=@ID"; string[] ParamsName = new string[] { "@RealName", "@Tel", "@EMail", "@QQ", "@IsShow", "@Title", "@Memo", "@ReplyTime", "@Reply", "@IsRecommend", "@Address", "@ID" }; string[] ParamsValue = new string[] { strRealName, strTel, strEMail, strQQ, strIsShow, strTitle, strMemo, strReplyTime, strReply, strIsRecommend, strAddress, strID }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); long id = myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
/// <summary> /// 点击删除所选按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void myTbDel_Click(object sender, EventArgs e) { string strSql, strKeyWord; strKeyWord = Request.QueryString["KeyWord"]; strSql = "select ID from T_Admin where 1=1"; //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and (UserName like '%" + strKeyWord.Replace("'", "''") + "%' or UserRoleCalled like '%" + strKeyWord.Replace("'", "''") + "%')"; } strSql += " order by id"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); for (int i = 0; i < myDs.Tables[0].Rows.Count; i++) { string strRowID = myDs.Tables[0].Rows[i]["ID"].ToString(); CheckBox myTB = (CheckBox)form1.FindControl("cbSel_" + strRowID); if (myTB != null) { if (myTB.Checked) { myData.ExecuteSql("delete from T_Admin where ID=" + strRowID, myConn); } } } myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("删除成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strSql, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strSql = "select * from T_Seo where ID=" + strID; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); if (myDs.Tables[0].Rows.Count > 0) { lbPageName.Text = myDs.Tables[0].Rows[0]["PageName"].ToString(); tbSeo_Title.Text = myDs.Tables[0].Rows[0]["Title"].ToString(); tbSeo_Keywords.Text = myDs.Tables[0].Rows[0]["Keywords"].ToString(); tbSeo_Description.Text = myDs.Tables[0].Rows[0]["Description"].ToString(); tbSeo_Author.Text = myDs.Tables[0].Rows[0]["Author"].ToString(); tbPageNameCalled.Text = myDs.Tables[0].Rows[0]["PageNameCalled"].ToString(); } else { myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("没有找到这条数据记录!"); Response.End(); } myDs.Dispose(); myData.ConnClose(myConn); }
protected void btSubmit_Click(object sender, EventArgs e) { string strSql, strTypeID, strCalled, strLink, strPic, strIsShow, strIsShowOther, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strTypeID = ddlType.SelectedValue; strCalled = tbCalled.Text; strLink = tbLink.Text; strIsShow = cblIsShow.SelectedValue; strIsShowOther = cblIsShowOther.SelectedValue; FunctionClass myFun = new FunctionClass(); strPic = myFun.UploadFile(fuProPic, "../upload/", "jpg|png|gif", 512); strSql = "update T_Link set TypeID=@TypeID,Called=@Called,Link=@Link,IsShow=@IsShow,IsShowOther=@IsShowOther where ID=@ID"; string[] ParamsName = new string[] { "@TypeID", "@Called", "@Link", "@IsShow", "@ID", "@IsShowOther" }; string[] ParamsValue = new string[] { strTypeID, strCalled, strLink, strIsShow, strID, strIsShowOther }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); if (strPic != "") { myData.ExecuteSql("update T_Link set Pic='" + strPic + "' where ID=" + strID, myConn); } myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strNewType, strSql; strSql = "select * from T_NewType order by sid,id desc"; ddlNewType.Items.Add(new ListItem("请选择新闻分类", "0")); DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); myData.InitProTypeList(myDs.Tables[0], 0, ddlNewType, ""); myDs.Dispose(); myData.ConnClose(myConn); //判断是否有传入参数 strNewType = Request.QueryString["NewType"]; if (FunctionClass.CheckStr(strNewType, 1)) { ddlNewType.SelectedValue = strNewType; } }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strSql, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strSql = "select * from T_Book where ID=" + strID; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { lbNoteTime.Text = myDr["NoteTime"].ToString() + " [" + myDr["IP"].ToString() + "]"; tbRealName.Text = myDr["RealName"].ToString(); tbTel.Text = myDr["Tel"].ToString(); tbEMail.Text = myDr["EMail"].ToString(); tbQQ.Text = myDr["QQ"].ToString(); cblIsShow.SelectedValue = myDr["IsShow"].ToString(); tbTitle.Text = myDr["Title"].ToString(); tbMemo.Text = myDr["Memo"].ToString(); tbReplyTime.Text = myDr["ReplyTime"].ToString() == "" ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : myDr["ReplyTime"].ToString(); tbReply.Text = myDr["Reply"].ToString(); rblIsRecommend.SelectedValue = myDr["IsRecommend"].ToString(); tbAddress.Text = myDr["Address"].ToString(); } myDr.Close(); myData.ConnClose(myConn); }
/// <summary> /// 点击更新排序按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void myTbOrder_Click(object sender, EventArgs e) { string strSql, strKeyWord; strKeyWord = Request.QueryString["KeyWord"]; strSql = "select ID from T_ProType where 1=1"; //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and TypeCalled like '%" + strKeyWord.Replace("'", "''") + "%'"; } strSql += " order by SID asc,id desc"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); for (int i = 0; i < myDs.Tables[0].Rows.Count; i++) { string strRowID = myDs.Tables[0].Rows[i]["ID"].ToString(); TextBox myTB = (TextBox)form1.FindControl("SID_" + strRowID); if (myTB != null) { myData.ExecuteSql("update T_ProType set SID=" + myTB.Text + " where ID=" + strRowID, myConn); } } myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("更新成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strPage, strTypeID, strKeyWord, strSql; int intPage, intPageSize, intRsCount; double dbPageCount = 1; strPage = Request.QueryString["page"]; strKeyWord = Request.QueryString["KeyWord"]; strTypeID = Request.QueryString["TypeID"]; //判断页参数是否存在 if (!FunctionClass.CheckStr(strPage, 1)) { strPage = "1"; } //赋值页和页数 intPage = Convert.ToInt32(strPage); intPageSize = 10; //初始化sql语句 strSql = "select * from V_PayLog where 1=1"; //判断是否有分类参数 if (strTypeID == null || strTypeID == "") { strTypeID = "0";//0表示所有分类 } //判断TypeID参数是否正确 if (!FunctionClass.CheckStr(strTypeID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //删除超过7天的支付记录(未到帐的) myData.ExecuteSql("delete from T_PayLog where IsShow=0 and Datediff(day,NoteTime,getDate())>7", myConn); //判断在不是0的情况下,加条件 if (strTypeID != "0") { strSql += " and PayType=" + strTypeID;//加分类条件 } //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and UserName like '%" + strKeyWord.Replace("'", "''") + "%'"; } strSql += " order by id desc;select * from T_PayType order by SID,ID desc"; DataSet myDs = myData.GetDataSet(strSql, myConn); //赋值分类下拉框 ddlType.DataTextField = "TypeCalled"; ddlType.DataValueField = "ID"; ddlType.DataSource = myDs.Tables[1]; ddlType.DataBind(); ddlType.Items.Insert(0, new ListItem("所有分类", "0")); ddlType.SelectedValue = strTypeID; //获取总记录数 intRsCount = myDs.Tables[0].Rows.Count; //计算总页数 dbPageCount = Math.Ceiling((double)intRsCount / (double)intPageSize); //如果现有页数大于总页数,那么设定为总页数 if (intPage > dbPageCount) { intPage = Convert.ToInt32(dbPageCount); } if (intPage < 1) { intPage = 1; } //读取数据 for (int i = 0; i < intPageSize; i++) { int intCurrentRow = i + (intPage - 1) * intPageSize; //判断是否已经没有数据 if (intCurrentRow + 1 > intRsCount) { break; } TableRow myTr = new TableRow(); myTr.Attributes.Add("style", "CURSOR: hand"); myTr.Attributes.Add("onMouseOver", "this.style.backgroundColor = '#FFFFFF'"); myTr.Attributes.Add("onmouseout", "this.style.backgroundColor = ''"); myTr.Attributes.Add("bgColor", "#ebf2f9"); TableCell myTc1 = new TableCell(); myTc1.Text = myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); TableCell myTc2 = new TableCell(); if (myDs.Tables[0].Rows[intCurrentRow]["IsShow"].ToString() == "1") { myTc2.Text = "<FONT color=blue>√</FONT>"; } else { myTc2.Text = "<FONT color=red>×</FONT>"; } myTc2.Attributes.Add("onclick", "SetShowOrFalse(this,'10','" + myDs.Tables[0].Rows[intCurrentRow]["IsShow"].ToString() + "','" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString() + "')"); TableCell myTc8 = new TableCell(); myTc8.Text = myDs.Tables[0].Rows[intCurrentRow]["UserName"].ToString(); TableCell myTc3 = new TableCell(); myTc3.Text = myDs.Tables[0].Rows[intCurrentRow]["Mobile"].ToString(); TableCell myTc4 = new TableCell(); myTc4.Text = myDs.Tables[0].Rows[intCurrentRow]["Price"].ToString(); TableCell myTc10 = new TableCell(); myTc10.Text = myDs.Tables[0].Rows[intCurrentRow]["TypeCalled"].ToString(); TableCell myTc5 = new TableCell(); myTc5.Text = myDs.Tables[0].Rows[intCurrentRow]["NoteTime"].ToString(); TableCell myTc11 = new TableCell(); myTc11.Text = myDs.Tables[0].Rows[intCurrentRow]["Memo"].ToString(); myTr.Cells.Add(myTc1); myTr.Cells.Add(myTc2); myTr.Cells.Add(myTc8); myTr.Cells.Add(myTc3); myTr.Cells.Add(myTc4); myTr.Cells.Add(myTc10); myTr.Cells.Add(myTc5); myTr.Cells.Add(myTc11); TableCell myTc6 = new TableCell(); myTc6.Width = 60; myTc6.Text = "<a href='paylog_mod.aspx?id=" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString() + "' style='color:#330099;'>修改</a> <a href='paylog.aspx?del=" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString() + "' style='color:#330099;' onclick='return confirm(\"是否要删除这条信息?\")'>删除</a>"; TableCell myTc7 = new TableCell(); CheckBox myCB = new CheckBox(); myCB.ID = "cbSel_" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); myCB.ToolTip = myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); myTc7.Width = 20; myTc7.Controls.Add(myCB); myTr.Cells.Add(myTc6); myTr.Cells.Add(myTc7); tableMain.Rows.Add(myTr); } myDs.Dispose(); myData.ConnClose(myConn); //添加按钮行 TableRow myTrBt = new TableRow(); myTrBt.Attributes.Add("bgColor", "#ebf2f9"); TableCell myTcA = new TableCell(); myTcA.ColumnSpan = 8; TableCell myTcC = new TableCell(); myTcC.ColumnSpan = 2; Button myTbDel = new Button(); myTbDel.ID = "tbDelSelected"; myTbDel.Text = "删除所选"; myTbDel.OnClientClick = "return confirm('是否删除选中信息?');"; myTbDel.Width = 60; myTbDel.Click += new EventHandler(myTbDel_Click); myTcC.Controls.Add(myTbDel); myTrBt.Cells.Add(myTcA); myTrBt.Cells.Add(myTcC); tableMain.Rows.Add(myTrBt); //添加分页行 TableRow myTrPage = new TableRow(); myTrPage.Attributes.Add("bgColor", "#d7e4f7"); TableCell myTcP = new TableCell(); myTcP.ColumnSpan = 10; myTcP.Text = "<div style='width:50%;text-align:left;float:left;'>总共 <font color=red>" + intRsCount + "</font> 条信息 当前页:<font color=red>" + intPage + "</font>/" + dbPageCount + " 每页显示:<font color=red>" + intPageSize + "</font>条</div>"; myTcP.Text += "<div style='width:50%;text-align:right;float:left;'><a href=\"" + FunctionClass.GetNewURL("page", "1", FunctionClass.PageURL) + "\">首页</a> "; int intPrevPage = intPage < 2 ? 1 : intPage - 1; myTcP.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intPrevPage.ToString(), FunctionClass.PageURL) + "\">上一页</a> "; int intNextPage = intPage >= dbPageCount ? (int)dbPageCount : intPage + 1; myTcP.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intNextPage.ToString(), FunctionClass.PageURL) + "\">下一页</a> "; myTcP.Text += "<a href=\"" + FunctionClass.GetNewURL("page", dbPageCount.ToString(), FunctionClass.PageURL) + "\">尾页</a> "; myTcP.Text += "跳转至<input type=\"text\" name=\"gotoPage\" id=\"gotoPage\" style=\"width:20px;height:18px;\" value=\"" + intPage + "\" onKeyUp=\"value=value.replace(/[^\\d]/g,'')\" />页"; myTcP.Text += " <INPUT style='WIDTH: 20px; HEIGHT: 18px' class=button onclick=\"GotoPage('" + FunctionClass.GetNewURL("page", "", FunctionClass.PageURL) + "','gotoPage')\" value=GO type=button "; myTcP.Text += "name=submitSkip> </div>"; myTrPage.Cells.Add(myTcP); tableMain.Rows.Add(myTrPage); Session["UserViewURL"] = FunctionClass.PageURL; }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strPage, strKeyWord, strSql; int intPage, intPageSize, intRsCount; double dbPageCount = 1; strPage = Request.QueryString["page"]; strKeyWord = Request.QueryString["KeyWord"]; //判断页参数是否存在 if (!FunctionClass.CheckStr(strPage, 1)) { strPage = "1"; } //赋值页和页数 intPage = Convert.ToInt32(strPage); intPageSize = 10; //初始化sql语句 strSql = "select * from T_Admin where 1=1"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and (UserName like '%" + strKeyWord.Replace("'", "''") + "%' or UserRoleCalled like '%" + strKeyWord.Replace("'", "''") + "%')"; } strSql += " order by id"; DataSet myDs = myData.GetDataSet(strSql, myConn); //获取总记录数 intRsCount = myDs.Tables[0].Rows.Count; //计算总页数 dbPageCount = Math.Ceiling((double)intRsCount / (double)intPageSize); //如果现有页数大于总页数,那么设定为总页数 if (intPage > dbPageCount) { intPage = Convert.ToInt32(dbPageCount); } if (intPage < 1) { intPage = 1; } //读取数据 for (int i = 0; i < intPageSize; i++) { int intCurrentRow = i + (intPage - 1) * intPageSize; //判断是否已经没有数据 if (intCurrentRow + 1 > intRsCount) { break; } TableRow myTr = new TableRow(); myTr.Attributes.Add("style", "CURSOR: hand"); myTr.Attributes.Add("onMouseOver", "this.style.backgroundColor = '#FFFFFF'"); myTr.Attributes.Add("onmouseout", "this.style.backgroundColor = ''"); myTr.Attributes.Add("bgColor", "#ebf2f9"); TableCell myTc1 = new TableCell(); myTc1.Text = myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); TableCell myTc2 = new TableCell(); if (myDs.Tables[0].Rows[intCurrentRow]["IsLock"].ToString() == "1") { myTc2.Text = "<FONT color=blue>√</FONT>"; } else { myTc2.Text = "<FONT color=red>×</FONT>"; } myTc2.Attributes.Add("onclick", "SetShowOrFalse(this,'5','" + myDs.Tables[0].Rows[intCurrentRow]["IsLock"].ToString() + "','" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString() + "')"); TableCell myTc8 = new TableCell(); myTc8.Text = myDs.Tables[0].Rows[intCurrentRow]["UserName"].ToString(); TableCell myTc3 = new TableCell(); myTc3.Text = myDs.Tables[0].Rows[intCurrentRow]["PassWord"].ToString(); TableCell myTc4 = new TableCell(); myTc4.Text = myDs.Tables[0].Rows[intCurrentRow]["UserRole"].ToString(); TableCell myTc5 = new TableCell(); myTc5.Text = myDs.Tables[0].Rows[intCurrentRow]["UserRoleCalled"].ToString(); TableCell myTc10 = new TableCell(); myTc10.Text = myDs.Tables[0].Rows[intCurrentRow]["UserMenu"].ToString(); myTr.Cells.Add(myTc1); myTr.Cells.Add(myTc2); myTr.Cells.Add(myTc8); myTr.Cells.Add(myTc3); myTr.Cells.Add(myTc4); myTr.Cells.Add(myTc5); myTr.Cells.Add(myTc10); //TableCell myTc9 = new TableCell(); //TextBox myTb = new TextBox(); //myTb.ID = "SID_" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); //myTb.Width = 40; //myTb.Text = myDs.Tables[0].Rows[intCurrentRow]["SID"].ToString(); //myTb.Attributes.Add("onkeyup", "value=value.replace(/[^\\d]/g,'')"); //myTc9.Controls.Add(myTb); TableCell myTc6 = new TableCell(); myTc6.Width = 60; myTc6.Text = "<a href='admin_mod.aspx?id=" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString() + "' style='color:#330099;'>修改</a> <a href='admin.aspx?del=" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString() + "' style='color:#330099;' onclick='return confirm(\"是否要删除这条信息?\")'>删除</a>"; TableCell myTc7 = new TableCell(); CheckBox myCB = new CheckBox(); myCB.ID = "cbSel_" + myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); myCB.ToolTip = myDs.Tables[0].Rows[intCurrentRow]["ID"].ToString(); myTc7.Width = 20; myTc7.Controls.Add(myCB); //myTr.Cells.Add(myTc9); myTr.Cells.Add(myTc6); myTr.Cells.Add(myTc7); tableMain.Rows.Add(myTr); } myDs.Dispose(); myData.ConnClose(myConn); //添加按钮行 TableRow myTrBt = new TableRow(); myTrBt.Attributes.Add("bgColor", "#ebf2f9"); TableCell myTcA = new TableCell(); myTcA.ColumnSpan = 7; //TableCell myTcB = new TableCell(); //Button myTbOrder = new Button(); //myTbOrder.ID = "tbUpdateOrder"; //myTbOrder.Text = "更新排序"; //myTbOrder.Width = 50; //myTbOrder.Click += new EventHandler(myTbOrder_Click); //myTcB.Controls.Add(myTbOrder); TableCell myTcC = new TableCell(); myTcC.ColumnSpan = 2; Button myTbDel = new Button(); myTbDel.ID = "tbDelSelected"; myTbDel.Text = "删除所选"; myTbDel.OnClientClick = "return confirm('是否删除选中信息?');"; myTbDel.Width = 60; myTbDel.Click += new EventHandler(myTbDel_Click); myTcC.Controls.Add(myTbDel); myTrBt.Cells.Add(myTcA); //myTrBt.Cells.Add(myTcB); myTrBt.Cells.Add(myTcC); tableMain.Rows.Add(myTrBt); //添加分页行 TableRow myTrPage = new TableRow(); myTrPage.Attributes.Add("bgColor", "#d7e4f7"); TableCell myTcP = new TableCell(); myTcP.ColumnSpan = 9; myTcP.Text = "<div style='width:50%;text-align:left;float:left;'>总共 <font color=red>" + intRsCount + "</font> 条信息 当前页:<font color=red>" + intPage + "</font>/" + dbPageCount + " 每页显示:<font color=red>" + intPageSize + "</font>条</div>"; myTcP.Text += "<div style='width:50%;text-align:right;float:left;'><a href=\"" + FunctionClass.GetNewURL("page", "1", FunctionClass.PageURL) + "\">首页</a> "; int intPrevPage = intPage < 2 ? 1 : intPage - 1; myTcP.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intPrevPage.ToString(), FunctionClass.PageURL) + "\">上一页</a> "; int intNextPage = intPage >= dbPageCount ? (int)dbPageCount : intPage + 1; myTcP.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intNextPage.ToString(), FunctionClass.PageURL) + "\">下一页</a> "; myTcP.Text += "<a href=\"" + FunctionClass.GetNewURL("page", dbPageCount.ToString(), FunctionClass.PageURL) + "\">尾页</a> "; myTcP.Text += "跳转至<input type=\"text\" name=\"gotoPage\" id=\"gotoPage\" style=\"width:20px;height:18px;\" value=\"" + intPage + "\" onKeyUp=\"value=value.replace(/[^\\d]/g,'')\" />页"; myTcP.Text += " <INPUT style='WIDTH: 20px; HEIGHT: 18px' class=button onclick=\"GotoPage('" + FunctionClass.GetNewURL("page", "", FunctionClass.PageURL) + "','gotoPage')\" value=GO type=button "; myTcP.Text += "name=submitSkip> </div>"; myTrPage.Cells.Add(myTcP); tableMain.Rows.Add(myTrPage); Session["UserViewURL"] = FunctionClass.PageURL; }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strSql, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL参数错误!"); Response.End(); } strSql = "select * from T_NewType order by sid;select * from V_News where ID=" + strID; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); ddlNewType.Items.Add(new ListItem("请选择新闻分类", "0")); myData.InitProTypeList(myDs.Tables[0], 0, ddlNewType, ""); if (myDs.Tables[1].Rows.Count > 0) { ddlNewType.SelectedValue = myDs.Tables[1].Rows[0]["NewType"].ToString(); tbTitle.Text = myDs.Tables[1].Rows[0]["Title"].ToString(); tbAuthor.Text = myDs.Tables[1].Rows[0]["Author"].ToString(); tbOrigin.Text = myDs.Tables[1].Rows[0]["Origin"].ToString(); if (myDs.Tables[1].Rows[0]["IsShow"].ToString() == "1") { cblIsShow.SelectedValue = "1"; } else { cblIsShow.SelectedValue = "0"; } if (myDs.Tables[1].Rows[0]["IsRecommend"].ToString() == "1") { cblIsRecommend.SelectedValue = "1"; } else { cblIsRecommend.SelectedValue = "0"; } tbKeyWords.Text = myDs.Tables[1].Rows[0]["KeyWords"].ToString(); tbContent.Text = myDs.Tables[1].Rows[0]["Content"].ToString(); imgProPic.ImageUrl = "../" + myDs.Tables[1].Rows[0]["NewPic"].ToString(); lbDoc.Text = myDs.Tables[1].Rows[0]["NewPic"].ToString(); if (myDs.Tables[1].Rows[0]["NewPic"].ToString() == "") { imgProPic.Visible = false; } tbNewTip.Text = myDs.Tables[1].Rows[0]["NewTip"].ToString(); if (imgProPic.ImageUrl == "") { imgProPic.Width = 10; } else { imgProPic.Width = 100; } tbSeo_Title.Text = myDs.Tables[1].Rows[0]["Seo_Title"].ToString(); tbSeo_Keywords.Text = myDs.Tables[1].Rows[0]["Seo_Keywords"].ToString(); tbSeo_Description.Text = myDs.Tables[1].Rows[0]["Seo_Description"].ToString(); tbSeo_Author.Text = myDs.Tables[1].Rows[0]["Seo_Author"].ToString(); } else { FunctionClass.ShowMsgBox("没有找到这条信息!", ""); myDs.Dispose(); myData.ConnClose(myConn); Response.End(); } myDs.Dispose(); myData.ConnClose(myConn); }
/// <summary> /// 保存数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btSubmit_Click(object sender, EventArgs e) { string strNewType, strTitle, strAuthor, strOrigin, strIsRecommend, strIsShow, strKeyWords, strContent, strNewPic; string strSeo_Title, strSeo_Keywords, strSeo_Description, strSeo_Author; string strSql, strID, strNewTip; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL参数错误!"); Response.End(); } strNewType = ddlNewType.SelectedValue; strTitle = tbTitle.Text; strAuthor = tbAuthor.Text; strOrigin = tbOrigin.Text; strIsRecommend = cblIsRecommend.SelectedValue; strIsShow = cblIsShow.SelectedValue; strKeyWords = tbKeyWords.Text; strContent = tbContent.Text; strNewTip = tbNewTip.Text; //SEO选项 strSeo_Title = tbSeo_Title.Text; strSeo_Keywords = tbSeo_Keywords.Text; strSeo_Description = tbSeo_Description.Text; strSeo_Author = tbSeo_Author.Text; //判断title是否为空 if (strSeo_Title == "") { strSeo_Title = strTitle; } FunctionClass myFun = new FunctionClass(); strNewPic = myFun.UploadFile(fuProPic, "../upload/", "jpg|png|gif|doc|xls|txt|docx|xlsx", 512 * 10); strSql = "update T_News set NewType=@NewType,Title=@Title,Author=@Author,Origin=@Origin,IsRecommend=@IsRecommend,IsShow=@IsShow," + "KeyWords=@KeyWords,[Content]=@Content,NoteTime=getDate(),NewTip=@NewTip,Seo_Title=@Seo_Title,Seo_Keywords=@Seo_Keywords," + "Seo_Description=@Seo_Description,Seo_Author=@Seo_Author where ID=@ID"; string[] ParamName = new string[] { "@NewType", "@Title", "@Author", "@Origin", "@IsRecommend", "@IsShow", "@KeyWords", "@Content", "@ID", "@NewTip", "@Seo_Title", "@Seo_Keywords", "@Seo_Description", "@Seo_Author" }; string[] ParamValue = new string[] { strNewType, strTitle, strAuthor, strOrigin, strIsRecommend, strIsShow, strKeyWords, strContent, strID, strNewTip, strSeo_Title, strSeo_Keywords, strSeo_Description, strSeo_Author }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamName, ParamValue, myConn); //判断是否更新图片 if (strNewPic != "") { myData.ExecuteSql("update T_News set NewPic='" + strNewPic + "' where ID=" + strID, myConn); } myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }