protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
SqlDataReader dr = SqlHelper.ExecuteReader("select * from hk_Ygtxl where id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (dr.Read())
{
Folder.Text = dr["FoldersName"].ToString();
PxNum.Text = dr["PxNum"].ToString();
FoldersID.Text = dr["FoldersID"].ToString();
Name.Text = dr["Name"].ToString();
Worknum.Text = dr["Worknum"].ToString();
Unit.Text = dr["Unit"].ToString();
Respon.Text = dr["Respon"].ToString();
Post.Text = dr["Post"].ToString();
Sex.Text = dr["Sex"].ToString();
Officetel.Text = dr["Officetel"].ToString();
Fax.Text = dr["Fax"].ToString();
MoveTel.Text = dr["MoveTel"].ToString();
HomeTel.Text = dr["HomeTel"].ToString();
Email.Text = dr["Email"].ToString();
QQNum.Text = dr["QQNum"].ToString();
MsnNum.Text = dr["MsnNum"].ToString();
NbNum.Text = dr["NbNum"].ToString();
Address.Text = dr["Address"].ToString();
ZipCode.Text = dr["ZipCode"].ToString();
Remark.Text = hkdb.TbToLb(dr["Remark"].ToString());
BothDay.Text = dr["BothDay"].ToString();
}
dr.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM hk_Seal WHERE sID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (datar.Read())
{
lblsName.Text = datar["sName"].ToString();
lblsType.Text = datar["sType"].ToString();
lblsStatus.Text = datar["sStatus"].ToString();
lblsRemark.Text = hkdb.TbToLb(datar["sRemark"].ToString());
sPicNewName.ImageUrl = "../../Attach/flow/Seal/" + datar["sPicNewName"].ToString();
}
datar.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_Seal A LEFT OUTER JOIN yh B ON(A.sUser=B.ui_id) WHERE sID='" + hkdb.GetStr(Request.QueryString["id"]) + "' AND sStatus='待审'");
if (datar.Read())
{
lblsName.Text = datar["sName"].ToString();
lblsType.Text = datar["sType"].ToString();
lblsStatus.Text = datar["sStatus"].ToString();
lbluID.Text = datar["sUser"].ToString();
lblsUser.Text = datar["ui_desc"].ToString();
lblsRemark.Text = hkdb.TbToLb(datar["sRemark"].ToString());
sPicNewName.ImageUrl = "../../Attach/flow/Seal/" + datar["sPicNewName"].ToString();
}
datar.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM hk_OffSeal WHERE oID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (datar.Read())
{
lbloName.Text = datar["oName"].ToString();
lbloRemark.Text = hkdb.TbToLb(datar["oRemark"].ToString());
oPicNewName.ImageUrl = "../../Attach/flow/Seal/" + datar["oPicNewName"].ToString();
}
datar.Close();
BindAttr();
//页面绑定
GridViewBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("10906", "0");
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT fcName,fcRemark from hk_FormClass WHERE fcID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (datar.Read())
{
fcName.Text = datar["fcName"].ToString();
fcRemark.Text = hkdb.TbToLb(datar["fcRemark"].ToString());
datar.Close();
}
else
{
datar.Close();
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("60301", "0");
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,(SELECT BM_MC FROM BM WHERE BM_ID=A.BM_SJBM)AS SJBMMC,(CASE WHEN BMGLQX='Y' THEN '允许管理子部门数据' ELSE '不允许管理子部门数据' END)AS BMGLQX_MC,B.mc FROM BM A LEFT OUTER JOIN hk_ZDYLX B ON(A.bm_lx=B.id) WHERE bm_id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (dr.Read())
{
showtitle = "部门详细信息";
bmbm.Text = dr["bm_bm"].ToString();
bmmc.Text = dr["bm_mc"].ToString();
sjbmmc.Text = dr["sjbmmc"].ToString();
bmfzr.Text = dr["bm_fzr"].ToString();
bmdh.Text = dr["bm_dh"].ToString();
bmcz.Text = dr["bm_cz"].ToString();
bmlx.Text = dr["mc"].ToString();
bz.Text = hkdb.TbToLb(dr["bm_bz"].ToString());
bmglqx.Text = dr["bmglqx_mc"].ToString();
//ModBtn.Visible = true;
//DelBtn.Visible = true;
//AddBtn.Visible = true;
OperQx();
}
else
{
showtitle = "暂未选中任何部门";
ModBtn.Visible = false;
DelBtn.Visible = false;
AddBtn.Visible = false;
}
dr.Close();
}
}