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