//任务性质
public void DropDownListBind()
{
string sql_rwxz = "select id,mc FROM hk_ZDYLX where fl='o10' and zt<>'删除'";
bd.Bind_DropDownList(rwxz, sql_rwxz, "id", "mc", "", "全部");
bd.Bind_DropDownList_bm(fbbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
//文件密级
string sql_mini = "SELECT ID,MC FROM hk_zdylx where fl='o06' AND zt='正常'";
bd.Bind_DropDownList(Miji, sql_mini, "ID", "MC", "", "");
//紧急等级
string sql_dengji = "SELECT ID,MC FROM hk_zdylx where fl='o07' AND zt='正常'";
bd.Bind_DropDownList(Dengji, sql_dengji, "ID", "MC", "", "");
//文件分类
string sql_wjtype = "SELECT ID,MC FROM hk_zdylx where fl='o08' AND zt='正常'";
bd.Bind_DropDownList(WjType, sql_wjtype, "ID", "MC", "", "");
//公文类别
string sql_gwtype = "SELECT ID,MC FROM hk_zdylx where fl='o09' AND zt='正常'";
bd.Bind_DropDownList(GwType, sql_gwtype, "ID", "MC", "", "");
//所属案卷
string sql_filesname = "select * from oa_FilesManage where (CHARINDEX('," + this.Session["deptid"] + ",',','+QxUnitId+',')>0) order by id desc";
bd.Bind_DropDownList(FilesName, sql_filesname, "ID", "name", "", "");
}
//dp绑定
public void DropDownListBind()
{
//所属公司
string sql_ssgs = "SELECT QY_ID,QY_QC FROM QY ORDER BY QY_ID";
bd.Bind_DropDownList(ssgs, sql_ssgs, "qy_id", "qy_qc", "", "");
//角色
string sql_js = null;
if (Request.QueryString["id"].ToString() == "admin")
{
sql_js = "SELECT ROLE_ID,ROLE_NAME FROM JS WHERE ROLE_LX='企业' ORDER BY ROLE_ID";
}
else
{
sql_js = "SELECT ROLE_ID,ROLE_NAME FROM JS WHERE ROLE_LX='企业' AND ROLE_ID<>'1' ORDER BY ROLE_ID";
}
bd.Bind_DropDownList(gwjs, sql_js, "role_id", "role_name", "", "");
//职位
string sql_zw = "SELECT ZWID,ZWMC FROM ZW ORDER BY ZWID";
bd.Bind_DropDownList(zwmc, sql_zw, "zwid", "zwmc", "", "");
//部门
bd.Bind_DropDownList_bm(bm, "", "", "");
}
public void DropDownListBind_sjmk()
{
moduupid.Items.Clear();
string sql_modu = "SELECT MODU_ID,MODU_MC FROM HK_MODU WHERE MODU_UPID=0 AND MODU_LX<>'G' AND MODU_LX='" + modu_lx.SelectedValue + "' ORDER BY ORDERID";
bd.Bind_DropDownList(moduupid, sql_modu, "MODU_ID", "MODU_MC", "0", "");
}
//dp绑定
public void DropDownListBind_sqzy()
{
string sql_sqzy = "select djid,CAST(djid AS VARCHAR(10))+'-'+zymc as zymc from OA_ZYDJ order by djid";
bd.Bind_DropDownList(sqzy, sql_sqzy, "djid", "zymc", "", "");
string sql_zyfl = "select flid,CAST(flid AS VARCHAR(10))+'-'+flmc AS flmc from OA_ZYFL order by flid";
bd.Bind_DropDownList(zyfl, sql_zyfl, "flid", "flmc", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_xycl = "select id,clmc from oa_clda";
bd.Bind_DropDownList(xycl, sql_xycl, "id", "clmc", "", "");
string sql_jsy = "select xm,id from OA_JSYDA order by id";
bd.Bind_DropDownList(jsy, sql_jsy, "id", "xm", "", "");
bd.Bind_DropDownList_bm(sqbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
// SqlDataReader datar = SqlHelper.ExecuteReader("select id,clmc from oa_clda where id not in (select xycl from oa_clsq where zt in ('审批中','已同意') and (getdate() between xssj_s and xssj_e))");
string sql_xycl = "select id,clmc from oa_clda where clzt='未借出'";
bd.Bind_DropDownList(xycl, sql_xycl, "id", "clmc", "", "");
string sql_jsy = "select xm,id from OA_JSYDA order by id";
bd.Bind_DropDownList(jsy, sql_jsy, "id", "xm", "", "");
bd.Bind_DropDownList_bm(sqbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_hylx = "select mc,id FROM hk_ZDYLX where fl='o01' and zt<>'删除' order by id";
bd.Bind_DropDownList(hylx, sql_hylx, "id", "mc", "", "");
string sql_zkdd = "select hys_id,hys_mc from oa_hys order by hys_id";
bd.Bind_DropDownList(zkdd, sql_zkdd, "hys_id", "hys_mc", "", "");
bd.Bind_DropDownList_bm(dept, "", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("10111", "0");
BindAttr();
DropDownListBind();
//dp绑定
//Random f = new Random();
//string sjs = f.Next(10000).ToString();
//Number.Text = "" + System.DateTime.Now.Year.ToString() + "" + System.DateTime.Now.Month.ToString() + "" + System.DateTime.Now.Day.ToString() + "" + System.DateTime.Now.Hour.ToString() + "" + System.DateTime.Now.Minute.ToString() + "" + System.DateTime.Now.Second.ToString() + "" + System.DateTime.Now.Millisecond.ToString() + "" + sjs + "";
if (!IsPostBack)
{
SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_KnowLedge where ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (datar.Read())
{
BigName.SelectedValue = datar["Bigid"].ToString();
//知识小类
LittleName.Items.Clear();
string sql_LittleName = "select ID,Name from OA_KlClassSub where BigId='" + BigName.SelectedValue + "' order by ID";
bd.Bind_DropDownList(LittleName, sql_LittleName, "ID", "Name", "", "");
TitleName.Text = datar["Title"].ToString();
Content.Text = datar["Content"].ToString();
AthourSay.Text = datar["AthourSay"].ToString();
KeyWord.Text = datar["KeyWord"].ToString();
UserName.Text = datar["QxYdRealname"].ToString();
UserID.Text = datar["QxYdUsername"].ToString();
LittleName.SelectedValue = datar["LittleId"].ToString();
Number.Text = datar["Number"].ToString();
datar.Close();
}
else
{
datar.Close();
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("10108", "0");
//短信
dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());
//资源分类
string sql_zyfl = "select flmc,flid from OA_ZYFL order by flid";
bd.Bind_DropDownList(zyfl, sql_zyfl, "flid", "flmc", "", "");
//Init
//SaveBtn.Enabled = false;
txtSdate.Text = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
txtEdate.Text = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
//绑定部门
DropDownListBind_sjbm();
sybm.SelectedValue = this.Session["deptid"].ToString();
}
}
//dp绑定
public void DropDownListBind()
{
string Sql1 = " where produid NOT IN('Y','X')";
if (this.Session["systype"].ToString() == "A") //主登录页
{
string str = null;
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT ProduID FROM hk_Init");
while (datar1.Read())
{
str = str + "','" + datar1["ProduID"].ToString();
}
datar1.Close();
Sql1 = Sql1 + " and ProduID in ('" + str + "')";
}
else //子登录页
{
if (this.Session["systype"].ToString() == "M")
{
Sql1 = Sql1 + " and (ProduID='G' or ProduID='P')";
}
else
{
Sql1 = Sql1 + " and (ProduID='" + this.Session["systype"] + "' or ProduID='P')";
}
}
string sql = "SELECT produid,produname FROM hk_init " + Sql1 + " ORDER BY InitType";
bd.Bind_DropDownList(xt, sql, "produid", "produname", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
BindAttr();
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (dr.Read())
{
fnNum.Text = dr["fnNum"].ToString();
fnName.Text = dr["fnName"].ToString();
lblwfno.Text = dr["FK_wfno"].ToString();
lblfno.Text = dr["FK_fno"].ToString();
strlist = "" + dr["NextNodeNum"].ToString() + "0";
}
dr.Close();
string sql_dpStep = "SELECT fnID,fnName FROM hk_WorkFlowNode WHERE fnNum IN (" + strlist + ") AND FK_wfno='" + lblwfno.Text + "'";
bd.Bind_DropDownList(dpStep, sql_dpStep, "fnID", "fnName", "请选择", "请选择");
}
if (dpStep.SelectedValue != "请选择")
{
GridVidwBind("WHERE fbTofnid='" + dpStep.SelectedValue + "' AND FK_fnid='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
}
else
{
GridVidwBind("WHERE fbTofnid='0'");
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
BindAttr();
}
if (!IsPostBack)
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlow WHERE wfNo='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "'");
if (dr.Read())
{
lblfid.Text = dr["FK_fid"].ToString();
lblfno.Text = dr["FK_fno"].ToString();
lblwfid.Text = dr["wfID"].ToString();
}
dr.Close();
//电子印章
string sql_seal = "SELECT clNo,clName FROM hk_FormColumn WHERE FK_fno='" + lblfno.Text + "'AND clType='[电子印章]'";
bd.Bind_DropDownList(sealarea, sql_seal, "clNo", "clName", "请选择", "请选择");
}
}
protected void Page_Load(object sender, EventArgs e)
{
mydb hkdb = new mydb();
hkdb.VeriSess("4");
usname = this.Session["username"].ToString();
this.SaveBtn.Attributes.Add("onclick", "javascript: SaveFile();");
if (!IsPostBack)
{
adfile = Request.QueryString["file"].ToString();
number = Request.QueryString["number"].ToString();
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT attName FROM hk_AttUpload WHERE attNewName='" + hkdb.GetStr(Request.QueryString["file"]) + "' AND attClass='w01'");
if (dr.Read())
{
adname = dr["attName"].ToString();
}
dr.Close();
if (Request.QueryString["filetype"].ToString() == ".doc" || Request.QueryString["filetype"].ToString() == ".DOC")
{
prnBtn.Visible = true;
clrTrkBtn.Visible = true;
TrkBtn.Visible = true;
unTrkBtn.Visible = true;
dp_admindoc.Visible = true;
Button3.Visible = true;
}
if (Request.QueryString["filetype"].ToString() == ".xls" || Request.QueryString["filetype"].ToString() == ".XLS")
{
prnBtn.Visible = false;
clrTrkBtn.Visible = false;
TrkBtn.Visible = false;
unTrkBtn.Visible = false;
dp_admindoc.Visible = false;
Button3.Visible = false;
}
if (Request.QueryString["filetype"].ToString() == ".ppt" || Request.QueryString["filetype"].ToString() == ".PPT")
{
prnBtn.Visible = true;
clrTrkBtn.Visible = false;
TrkBtn.Visible = false;
unTrkBtn.Visible = false;
dp_admindoc.Visible = false;
Button3.Visible = false;
}
string sql_admindoc = "SELECT * FROM hk_AdminDoc WHERE adType='" + hkdb.GetStr(Request.QueryString["filetype"].ToString()) + "' AND (CHARINDEX('," + this.Session["userid"].ToString() + ",',','+adUserIDs+',') > 0)";
bd.Bind_DropDownList(dp_admindoc, sql_admindoc, "adNewName", "adName", "请选择", "请选择");
}
string fileName = System.IO.Path.GetFileName(Request.QueryString["file"].ToString());
extfilename = System.IO.Path.GetExtension(fileName);
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
//短信
dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());
BindAttr();
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.* FROM hk_Work A WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (datar1.Read())
{
lbltitle.Text = datar1["wTitle"].ToString();
strfnName = datar1["NextNodeName"].ToString();
Name = datar1["wName"].ToString();
UserID.Text = datar1["AttentUserIDs"].ToString();
UserName.Text = datar1["AttentUserNames"].ToString();
}
datar1.Close();
//我的常用语
string sql_appcomm = "SELECT nr FROM hk_Cyy WHERE fl='02' and zt='正常' and cjr='" + this.Session["UserID"] + "'";
bd.Bind_DropDownList(dp_appcomm, sql_appcomm, "nr", "nr", "请选择", "请选择");
}
}
public void DropDownListBind()
{
string Str = " WHERE (Z.KQSPRY1='是' OR Z.KQSPRY2='是')";
SqlDataReader dr_sp = SqlHelper.ExecuteReader("SELECT qzcyid FROM hk_QZDA WHERE CJR='" + this.Session["UserID"] + "' AND QZLX='OA考勤说明审批专用群组'");
if (dr_sp.Read())
{
Str += " AND CHARINDEX(UI_ID,'" + dr_sp["qzcyid"].ToString() + "')>0";
}
dr_sp.Close();
//下一步审批人
string sql_jsr = "SELECT UI_ID,UI_DESC+'('+B.BM_MC+'-'+C.ZWMC+')' AS UI_DESC FROM OA_KQ_QX Z LEFT OUTER JOIN YH A ON(Z.YHID=A.UI_ID) LEFT OUTER JOIN BM B ON (A.UI_SSBM=B.BM_ID) LEFT OUTER JOIN ZW C ON(A.UI_ZW=C.ZWID) " + Str + " ORDER BY UI_DESC";
bd.Bind_DropDownList(jsr, sql_jsr, "ui_id", "ui_desc", "", "选择下一步审批人员");
ListItem theItem1 = new ListItem();
theItem1.Text = "----------------";
theItem1.Value = "";
jsr.Items.Add(theItem1);
ListItem theItem2 = new ListItem();
theItem2.Text = "转给考勤管理员";
theItem2.Value = "jdqr";
jsr.Items.Add(theItem2);
}
//dp绑定
public void DropDownListBind()
{
bd.Bind_DropDownList_bm(ssbm, "", "", "");
string sql_zw = "select zwid,zwmc FROM ZW order by zwid";
bd.Bind_DropDownList(zw, sql_zw, "zwid", "zwmc", "", "");
}
public void DropDownListBind()
{
//贺卡模板
string sql = "SELECT A.MBID,A.MBMC FROM VI_MBDA A LEFT OUTER JOIN VI_MBFL B ON (A.MBFL=B.FLID) WHERE B.BJ='sr'";
bd.Bind_DropDownList(hkmb, sql, "MBID", "MBMC", "", "选择信纸模板");
}
//dp绑定
public void DropDownListBind_sjbm()
{
string sql_glry = "select ui_id,ui_desc from yh where ui_lx='企业' and ui_status='正常' order by ui_id";
bd.Bind_DropDownList(glry, sql_glry, "ui_id", "ui_desc", "", "");
bd.Bind_DropDownList_bm(ssbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_bmlx = "SELECT ID,MC FROM hk_ZDYLX WHERE fl='p01' AND ZT='正常'";
bd.Bind_DropDownList(bm_lx, sql_bmlx, "id", "mc", "", "");
bd.Bind_DropDownList_bm(bm_sjbm, "0", "顶层部门", " AND JGLB<>'2'");
}
//dp绑定
public void DropDownListBind()
{
string sql_zyfl = "select flmc,flid from OA_ZYFL order by flid";
bd.Bind_DropDownList(zyfl, sql_zyfl, "flid", "flmc", "", "");
//绑定部门
bd.Bind_DropDownList_bm(szbm, "", "", "");
}
//审批人
public void DropDownListBind_lx()
{
string sql_jhlx = "select id,mc FROM hk_ZDYLX where fl='o02' and zt='正常'";
bd.Bind_DropDownList(jhlx, sql_jhlx, "id", "mc", "", "");
//绑定部门
bd.Bind_DropDownList_bm(bm, "", "", "");
}
public void BindDplist()
{
string sql_fname = "SELECT fID,fName FROM hk_Form ORDER BY fID DESC";
bd.Bind_DropDownList(txt_fName, sql_fname, "fID", "fName", "0", "所有表单类型");
//绑定部门
bd.Bind_DropDownList_bm(fqbm, "", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
string sql_wfno = "SELECT wfNo,wfName FROM hk_WorkFlow WHERE wfNo!='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "' ORDER BY wfID DESC";
bd.Bind_DropDownList(dp_wfno, sql_wfno, "wfNo", "wfName", "请选择", "请选择");
}
}
//部门切换
protected void bm_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(bm.SelectedValue))
{
ry.Items.Clear();
string sql = "SELECT UI_ID,UI_ID+'-'+UI_DESC AS UI_DESC FROM YH WHERE UI_LX='企业' AND UI_SSBM='" + bm.SelectedValue + "' ORDER BY UI_ID";
bd.Bind_DropDownList(ry, sql, "UI_ID", "UI_DESC", "", "");
}
}
//dp绑定
public void DropDownListBind()
{
//所属公司
string sql_ssgs = "SELECT QY_ID,QY_QC FROM QY ORDER BY QY_ID";
bd.Bind_DropDownList(ssgs, sql_ssgs, "qy_id", "qy_qc", "", "");
//角色
string sql_js = "SELECT ROLE_ID,ROLE_NAME FROM JS WHERE ROLE_LX='企业' AND ROLE_ID<>'1' ORDER BY ROLE_ID";
bd.Bind_DropDownList(gwjs, sql_js, "role_id", "role_name", "", "");
//职位
string sql_zw = "SELECT ZWID,ZWMC FROM ZW ORDER BY ZWID";
bd.Bind_DropDownList(zwmc, sql_zw, "zwid", "zwmc", "", "");
//部门
bd.Bind_DropDownList_bm(bm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
//部门
bd.Bind_DropDownList_bm(UnitName, "", "", "");
//案卷密级
string sql_dengji = "SELECT ID,MC FROM hk_zdylx where fl='o04' AND zt='正常'";
bd.Bind_DropDownList(DengJi, sql_dengji, "ID", "MC", "", "");
//凭证类别
string sql_pinzheng = "SELECT ID,MC FROM hk_zdylx where fl='o05' AND zt='正常'";
bd.Bind_DropDownList(PinZheng, sql_pinzheng, "ID", "MC", "", "");
//所属卷库
string sql_roomname = "select * from oa_FilesRoom where (CHARINDEX('," + this.Session["deptid"] + ",',','+QxUnitId+',')>0) order by id desc";
bd.Bind_DropDownList(RoomName, sql_roomname, "ID", "name", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
string sql_dpSeal = "SELECT sPicNewName,sName+'('+sType+')' AS sName FROM hk_Seal WHERE sUser='******' AND sStatus='正常'";
bd.Bind_DropDownList(dpSeal, sql_dpSeal, "sPicNewName", "sName", "请选择", "请选择");
}
Button1.Attributes["onclick"] = "javascript:return chknull();";
}
//任务性质
public void DropDownListBind()
{
string sql_rwxz = "select id,mc FROM hk_ZDYLX where fl='o10' and zt='正常'";
bd.Bind_DropDownList(rwxz, sql_rwxz, "id", "mc", "", "");
bd1.Bind_DropDownList_bm(bm, "", "领导&科级干部，部门中心负责人", "");
bdqt.Bind_DropDownList_bm(bm1, "", "领导&科级干部，部门中心负责人", "");
bdrzld.Bind_DropDownList_bm(bm2, "", "领导&科级干部，部门中心负责人", "");
bdrzrr.Bind_DropDownList_bm(bm3, "", "领导&科级干部，部门中心负责人", "");
bdqt.Bind_DropDownList_bm(bm4, "", "领导&科级干部，部门中心负责人", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
string sql_down_bh = "select bm_id,dLine+bm_mc as aaa from BM order by dQxStr asc";
bd.Bind_DropDownList(Unit, sql_down_bh, "bm_id", "aaa", "", "");
}
GridViewBind();
}
