62,052
社区成员
发帖
与我相关
我的任务
分享
var result = window.showModalDialog(openUrl, "newwindow", "height=" + iHeight + ", width=" + iWidth + ", top=" + iTop + ", left=" + iLeft + "");
document.getElementById("txtQyxxID").value = result.split("|||")[0]; //返回值分别赋值给相关文本框
document.getElementById("txtQyxxName").value = result.split("|||")[1];
protected void Page_Load(object sender, EventArgs e)
{
string s = "";
string strSQL = "";
int i = 0;
OleDbConnection ConnAcc = new OleDbConnection(strConn);
OleDbCommand cmd;
OleDbDataReader dr;
ConnAcc.Open();
//如果传递参数进来
if (!IsPostBack)
{
btnUpdate.Text = "新增";
if (!string.IsNullOrEmpty(Request.QueryString["M"]))
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
if (Request.QueryString["M"].ToString() == "M")
{
strSQL = "SELECT * FROM bmxx_view where bmxx_id=" + Request.QueryString["id"].ToString() + " order by bmxx_id";
cmd = new OleDbCommand(strSQL, ConnAcc);
dr = cmd.ExecuteReader();
if (dr.Read())
{
txtID.Text = dr["bmxx_ID"].ToString();
txtName.Text = dr["bmxx_Name"].ToString();
taMemo.Text = dr["bmxx_Memo"].ToString();
txtQyxxID.Text = dr["qyxx_ID"].ToString();
txtQyxxName.Text = dr["qyxx_name"].ToString();
btnUpdate.Text = "更新";
}
dr.Close();
}
if (Request.QueryString["M"].ToString() == "D")
{
strSQL = "delete FROM bmxx where bmxx_id=" + Request.QueryString["id"].ToString() + "";
cmd = new OleDbCommand(strSQL, ConnAcc);
cmd.ExecuteNonQuery();
}
}
}
}
//生成下面的表格
strSQL = "SELECT * FROM bmxx_view order by bmxx_id";
cmd = new OleDbCommand(strSQL, ConnAcc);
dr = cmd.ExecuteReader();
s += " <table class='BmxxTableDetail'> ";
s += " <tr class='BmxxTableDetailTitle'> ";
s += " <td>ID</td> ";
s += " <td>企业名称</td> ";
s += " <td>部门名称</td> ";
s += " <td>备注</td> ";
s += " <td>操作</td> ";
s += " </tr> ";
s += " ";
i = 0;
while (dr.Read())
{
if (i % 2 == 0)
{
s += " <tr class='BmxxTR0'> ";
}
else
{
s += " <tr class='BmxxTR1'> ";
}
s += " <td> " + dr["Bmxx_ID"].ToString() + "</td>";
s += " <td> " + dr["Qyxx_Name"].ToString() + "</td>";
s += " <td> " + dr["Bmxx_Name"].ToString() + "</td>";
s += " <td> " + dr["Bmxx_Memo"].ToString() + "</td>";
s += " <td><a href='Bmxx.aspx?M=M&id=" + dr[0].ToString() + "' class='Modify'>修改</a> <a href='Bmxx.aspx?M=D&id=" + dr[0].ToString() + "' class='Modify' onclick=\"return confirm('确定要删除吗?')\">删除</a></td> ";
s += " </tr> ";
i++;
}
BmxxDetail.InnerHtml = s;
dr.Close();
ConnAcc.Close();
}