protected void bindData() { string str_sql = "select * from t_Expert where LoginName = '" + Session["admin_id"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } tb_Username.Text = dr["UserName"].ToString(); tb_LoginName.Text = dr["LoginName"].ToString(); //try { rbl_Sex.SelectedValue = dr["xingbie"].ToString(); } //catch{rbl_Sex.SelectedIndex = 0; } //tb_sfzh.Text = dr["sfzh"].ToString(); //txt_csrq.Value = dr["csrq"].ToString(); //try { ddl_xl.SelectedValue = dr["xueli"].ToString(); } //catch { ddl_xl.SelectedIndex = 0; } //tb_dw.Text = dr["gzdw"].ToString(); //tb_byxx.Text = dr["byxx"].ToString(); //tb_zy.Text = dr["sxzy"].ToString(); //tb_zyjs.Text = dr["zc"].ToString(); //txt_qdsj.Value = dr["qdzgsj"].ToString(); //tb_csly.Text = dr["xcszyly"].ToString(); //tb_sxly.Text = dr["sxzyly"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Write("<script>alert('页面失效,请您重新登录!');location.href = './admin_login.aspx';</script>"); return; } if (!IsPostBack) { lbl_id.Text = Request.QueryString["type"]; string str_sql = "select name,content from t_dict where flm = 8 and bm = " + lbl_id.Text; DataRow dr = DBFun.GetDataRow(str_sql); if (dr != null) { tbx_title.Text = dr["name"].ToString(); ftb_content.Text = dr["content"].ToString(); } else { str_sql = "insert into t_dict (flm,bm) values (8," + lbl_id.Text + ")"; if (!DBFun.ExecuteUpdate(str_sql)) { Response.Write("<script>alert('插入数据失败!');</script>"); } } } }
protected void bindData1() { str_sql = ViewState["sql1"].ToString(); dv = DBFun.GetDataView(str_sql); //DataRow dr = dv.Table.NewRow(); //dv.Table.Rows.Add(dr); PagedDataSource pds = new PagedDataSource(); pds.AllowPaging = true; pds.PageSize = AspNetPager2.PageSize; pds.CurrentPageIndex = AspNetPager2.CurrentPageIndex - 1; pds.DataSource = dv; GridView2.DataSource = pds; GridView2.DataKeyNames = new string[] { "ID" }; GridView2.DataBind(); AspNetPager2.RecordCount = dv.Table.Rows.Count; decimal i_xmjf, i_ysy, i_ye; str_sql = "select iif(isnull(xmjf),0,xmjf) as jf,sqr,xmbh from t_teacher_list where xmbh = '" + ViewState["xmbh"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_sql); i_xmjf = Convert.ToDecimal(dr["jf"]); //项目经费 lbl_xmxx.Text = "项目编号:[" + dr["xmbh"].ToString() + "]申请人:" + dr["sqr"].ToString(); i_ysy = 0; for (int i = 0; i < dv.Table.Rows.Count; i++) { i_ysy += Convert.ToDecimal(dv.Table.Rows[i]["je"]); } i_ye = i_xmjf - i_ysy; lbl_xmjf.Text = "经费总额为:" + i_xmjf.ToString() + "元,已使用经费额:" + i_ysy.ToString() + "元,余额:" + i_ye.ToString() + "元。"; }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Write("<script>alert('页面失效,请您重新登录!');location.href = './admin_login.aspx';</script>"); return; } if (!IsPostBack) { string str_sql = "select flag from master where admin_name = '" + Session["admin_name"].ToString() + "'"; if ((int)DBFun.ExecuteScalar(str_sql) != 2) { Response.Write("<script>alert('您没有权限访问此页面!');location.href = './main.aspx';</script>"); return; } string str_Groupid = Request.QueryString["Groupid"]; if (str_Groupid == "") { return; } str_sql = "select bm,name,url from t_dict where flm = 4"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { Response.Write("<script>alert('没有检索到数据!');</script>"); return; } bindData_zj(dr["name"].ToString()); bindData_cpry(dr["url"].ToString()); } }
protected void GetInfo() { string str_sql = "select name,content from t_dict where flm = " + Session["type"].ToString() + " and bm = " + DwPath.SelectedValue; DataRow dr = DBFun.GetDataRow(str_sql); ftb_content.Text = dr["content"].ToString(); }
protected void bindData() { string str_sql = "select * from zjry where flag = 1 and zj_sfzh='" + Session["admin_id"].ToString() + "' and cpry_sfzh='" + lbl_cpry_sfzh.Text + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } str_sql = "select yourname from cpry where sfzh='" + lbl_cpry_sfzh.Text + "'"; lbl_xm.Text = DBFun.ExecuteScalar(str_sql).ToString(); rbtnlist_1.SelectedValue = dr["fs_pjys1"].ToString(); rbtnlist_2.SelectedValue = dr["fs_pjys2"].ToString(); rbtnlist_3.SelectedValue = dr["fs_pjys3"].ToString(); rbtnlist_4.SelectedValue = dr["fs_pjys4"].ToString(); rbtnlist_5.SelectedValue = dr["fs_pjys5"].ToString(); rbtnlist_6.SelectedValue = dr["fs_pjys6"].ToString(); lbl_sum.Text = dr["fs_pjys_sum"].ToString(); str_sql = "select tj_flag from pszj where flag = 1 and sfzh='" + Session["admin_id"].ToString() + "'"; bool tj_flag = Convert.ToBoolean(DBFun.ExecuteScalar(str_sql)); btn_commit.Visible = !tj_flag; btn_printpreview.Visible = tj_flag; if (tj_flag) { Response.Write("<script>location.href = '../PrintPreview_zhuanjia_psyjb.aspx?sfzh=" + lbl_cpry_sfzh.Text + "',target='_blank';</script>"); } try { rbtnlist_tuijian.SelectedValue = dr["fs_sftj"].ToString(); } catch {} ftb_content.Text = dr["jypj"].ToString(); }
private void bindData() { string str_qry = ""; str_qry = "SELECT zjry.* ,yourname from zjry ,cpry where cpry.sfzh = zjry.sfzh and " + " zjid = " + Session["zjid"].ToString() + " and zjry.sfzh = '" + Session["sfzh"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_qry); if (dr == null) { return; } lbl_xm.Text = dr["yourname"].ToString(); try{ ddlist_1.SelectedValue = dr["fs_pjys1"].ToString(); } catch { ddlist_1.SelectedIndex = 0; } try { ddlist_2.SelectedValue = dr["fs_pjys2"].ToString(); } catch { ddlist_2.SelectedIndex = 0; } try { ddlist_3.SelectedValue = dr["fs_pjys3"].ToString(); } catch { ddlist_3.SelectedIndex = 0; } try { ddlist_4.SelectedValue = dr["fs_pjys4"].ToString(); } catch { ddlist_4.SelectedIndex = 0; } try { ddlist_5.SelectedValue = dr["fs_pjys5"].ToString(); } catch { ddlist_5.SelectedIndex = 0; } try { ddlist_6.SelectedValue = dr["fs_pjys6"].ToString(); } catch { ddlist_6.SelectedIndex = 0; } try { rbtnList_1.SelectedValue = dr["fs_sftj"].ToString(); } catch { } lbl_sum.Text = dr["fs_pjys_sum"].ToString(); lbl_date.Text = dr["psrq"].ToString(); ftb_jypj.Text = dr["jypj"].ToString(); }
protected void btn_upload_Click(object sender, EventArgs e) { string str_qry; string str_pra = UploadFile(FileUpload_photo, "photo", Session["sfzh"].ToString()); if (str_pra == "") { return; } if (str_pra == ",") { str_pra = img_photo.ImageUrl.Substring(img_photo.ImageUrl.LastIndexOf("/") + 1); } else { str_pra = str_pra.Substring(str_pra.LastIndexOf(",") + 1); } str_qry = string.Format("update cpry set photo = '{0}' where sfzh = '{1}'", str_pra, Session["sfzh"].ToString()); DBFun.ExecuteUpdate(str_qry); str_qry = "SELECT * from cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); img_photo.ImageUrl = "./photo/" + dr["photo"].ToString(); }
protected void binddata() { str_sfzh = Request.QueryString["sfzh"]; if (str_sfzh == "" || str_sfzh == null) { return; } string str_sql = "SELECT zjry.* ,yourname,lw_ctitle " + " FROM yxxwlw_cpry,zjry " + " WHERE sfzh=cpry_sfzh and flag = 4 and zj_sfzh = '" + Session["admin_id"].ToString() + "' and yxxwlw_cpry.sfzh = '" + str_sfzh + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } lbl_name.Text = dr["yourname"].ToString(); lbl_ctitle.Text = dr["lw_ctitle"].ToString(); lbl_fenshu_1.Text = dr["fs_pjys1"].ToString(); lbl_fenshu_2.Text = dr["fs_pjys2"].ToString(); lbl_fenshu_3.Text = dr["fs_pjys3"].ToString(); lbl_fenshu_4.Text = dr["fs_pjys4"].ToString(); lbl_fenshu_5.Text = dr["fs_pjys5"].ToString(); lbl_fenshu_6.Text = dr["fs_pjys6"].ToString(); lbl_fenshu_7.Text = dr["fs_pjys7"].ToString(); //lbl_fenshu_sum.Text = dr["fs_pjys_sum"].ToString(); lbl_pingjia.Text = dr["jypj"].ToString(); }
public static void ViewVar() { if (System.Web.HttpContext.Current.Application["AppSet"] == null) { DataRow drw = DBFun.GetDataRow("Select * From T_Setup"); //以下设置全局变量 Hashtable AppSet = new Hashtable(); AppSet.Add("WebSiteName", drw["sitename"].ToString()); AppSet.Add("PointCheat", drw["PointCheat"].ToString()); // System.Web.HttpContext.Current.Session.Timeout = Convert.ToInt32(syssetting[7]); System.Web.HttpContext.Current.Application["AppSet"] = AppSet; } if (System.Web.HttpContext.Current.Application["arUclass"] == null) { // 用户类型 DataView dvclass = DBFun.GetDataView("select * From T_Uclass"); string[,] arUclass = new string[dvclass.Table.Rows.Count, 3]; for (int j = 0; j < dvclass.Table.Rows.Count; j++) { arUclass[j, 0] = dvclass.Table.Rows[j]["Uidx"].ToString(); arUclass[j, 1] = dvclass.Table.Rows[j]["Utype"].ToString(); arUclass[j, 2] = dvclass.Table.Rows[j]["UcantBoard"].ToString(); } System.Web.HttpContext.Current.Application["arUclass"] = arUclass; } }
protected void btn_Reset_Click(object sender, EventArgs e) { //全局数据库变量 DataRow drw = DBFun.GetDataRow("Select * From T_Setup"); //以下设置全局变量 Hashtable AppSet = new Hashtable(); AppSet.Add("WebSiteName", drw["SiteName"].ToString()); AppSet.Add("PointCheat", drw["PointCheat"].ToString()); Application["AppSet"] = AppSet; // 用户类型 DataView dvclass = DBFun.GetDataView("select * From T_Uclass"); string[,] arUclass = new string[dvclass.Table.Rows.Count, 3]; for (int j = 0; j < dvclass.Table.Rows.Count; j++) { arUclass[j, 0] = dvclass.Table.Rows[j]["Uidx"].ToString(); arUclass[j, 1] = dvclass.Table.Rows[j]["Utype"].ToString(); arUclass[j, 2] = dvclass.Table.Rows[j]["UcantBoard"].ToString(); } Application["arUclass"] = arUclass; Response.Write("<Script>alert('操作成功 !');</script>"); }
public static DataRow Counter(Boolean BUpdate) { //string UserIP = Request.UserHostAddress.ToString(); string strsql = ""; if (!BUpdate) { strsql = "Select TotalBrowser,TodayBrowser From T_counter"; DataRow dr = DBFun.GetDataRow(strsql); return(dr); } string strqry = "select * From T_counter"; DataRow drw = DBFun.GetDataRow(strqry); if (drw["TodayDate"].ToString() != DateTime.Today.ToString()) { //新的一天 if ((int)drw["topip"] < (int)drw["todayip"]) { //刷新最高访问量 strsql = string.Format("Update [T_counter] Set topip={0},topdate=#{1}#", drw["todayip"].ToString(), drw["TodayDate"].ToString()); DBFun.ExecuteSql(strsql); } strsql = string.Format("Update [T_Counter] Set todayip=0,todaybrowser=0,daynum=daynum+1,todaydate=#{0}#," + "yesterdayip={1},yesterdaybrowser={2}", DateTime.Today.ToString(), drw["todayip"].ToString(), drw["todaybrowser"].ToString()); DBFun.ExecuteSql(strsql); strsql = string.Format("Insert Into [T_counterMore] (vtime,vip,browser) values(#{0}#,{1},{2})", DateTime.Today.AddDays(-1).ToString(), drw["todayip"].ToString(), drw["todaybrowser"].ToString()); DBFun.ExecuteSql(strsql); strsql = string.Format("Delete From T_counterMore where vtime<=#{0}#", DateTime.Today.AddDays(-15).ToString()); DBFun.ExecuteSql(strsql); strsql = "Delete From T_Online"; DBFun.ExecuteSql(strsql); } else { //统计开始 strsql = "Update T_Counter Set todaybrowser=todaybrowser+1,totalbrowser=totalbrowser+1"; DBFun.ExecuteSql(strsql); //strqry = string.Format("Select IP From [T_Online] where ip='{0}'", UserIP); if (!DBFun.SearchTable(strqry)) { //新用户访问 //strsql = string.Format("Insert Into [T_Online] (sessionid,userid,ip) values('{0}','{1}','{2}')", // Session.SessionID.ToString(), Session["Userid"].ToString(), UserIP); //DBFun.ExecuteSql(strsql); strsql = "Update T_counter Set todayip=todayip+1,totalip=totalip+1"; DBFun.ExecuteSql(strsql); } } string str_sql; str_sql = "Select TotalBrowser,TodayBrowser From T_counter"; drw = DBFun.GetDataRow(str_sql); return(drw); }
protected void btn_search_Click(object sender, EventArgs e) { string str_sql = "select name,content from t_dict where flm = " + tbx_flm.Text + " and bm = " + tbx_bm.Text; DataRow dr = DBFun.GetDataRow(str_sql); if (dr != null) { ftb_content.Text = dr["content"].ToString(); } }
protected void bindData() { str_sql = "SELECT Status,sqr,xmbh,zqbg_dName,zqbg from t_teacher_list where appNo = '" + Session["appNo"].ToString() + "';"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } string str_status = dr["Status"].ToString(); cbx_1.Checked = (str_status == "6"); string str_sqr = dr["sqr"].ToString(); string str_xmbh = dr["xmbh"].ToString(); string str_DocFilename = dr["zqbg"].ToString(); string str_HtmlFilename, str_mulu; str_mulu = "./中期检查申请表/"; if (str_DocFilename == "") { Response.Write("<script>alert('尚未上传期中检查申请表!');</script>"); hl_1.ForeColor = System.Drawing.Color.Red; hl_1.Text = "尚未上传期中检查申请表"; hl_1.NavigateUrl = ""; return; } str_HtmlFilename = str_DocFilename.Substring(0, str_DocFilename.LastIndexOf(".")) + ".pdf"; string str_MapPath = Server.MapPath(str_mulu); //if (!File.Exists(str_MapPath + str_filename)) //{ // Response.Write("<script>alert('尚未上传期中检查申请表!');</script>"); // return; //} //File.Copy(str_MapPath + str_filename, str_MapPath + str_newfilename, true); hl_1.ForeColor = System.Drawing.Color.FromArgb(000066); hl_1.Text = "查看中级检查申请表"; //string str_oldfilename = Server.MapPath(str_filename + ".doc"); try { word.WdSaveFormat wdf = word.WdSaveFormat.wdFormatPDF; WordToal.Word2Format(str_MapPath + str_DocFilename, str_MapPath + str_HtmlFilename, wdf); } catch { } hl_1.NavigateUrl = str_mulu + str_HtmlFilename; }
protected void tbx6_xm_TextChanged(object sender, EventArgs e) { string str_sql = "select dept,zc,yjzc from t_teacher where jsm= '" + tbx6_xm.Text + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { tbx6_zc.Text = ""; ddlist6_szbm.SelectedIndex = 0; } else { tbx6_zc.Text = dr["zc"].ToString(); ddlist6_szbm.SelectedValue = dr["dept"].ToString(); } }
protected void btn_Changejsh_Click(object sender, EventArgs e) { //判断用户名 string str_jsh = tbx_jsh.Text.Trim(); string strqry = string.Format("select jsh,xsh,jsm From T_teacher where jsh='{0}'", str_jsh); DataRow UserDr = DBFun.GetDataRow(strqry); if (UserDr == null) { Response.Write(@"<script>alert('教师号不存在!');</script>"); tbx_jsh.Focus(); return; } Session["type"] = "user"; Session["jsh"] = UserDr["jsh"].ToString(); Session["jsm"] = UserDr["jsm"].ToString(); Response.Redirect("../user_tb.aspx"); }
protected void btn_confirm_Click(object sender, EventArgs e) { //判断用户名 string str_dept = tbx_dept.Text.Trim(); string strqry = "select * From T_dict where flm=1 and url = '" + str_dept + "'"; DataRow UserDr = DBFun.GetDataRow(strqry); if (UserDr == null) { Response.Write(@"<script>alert('部门编码不存在!');</script>"); tbx_dept.Focus(); return; } Session["dept_type"] = "jyrs"; Session["dept_name"] = UserDr["name"].ToString(); Session["dept_id"] = UserDr["url"].ToString(); Response.Redirect("renshi_index.aspx"); }
protected void tbx5_jsh_TextChanged(object sender, EventArgs e) { str_sql = "select jsm,szbm,zc,yjzc from t_teacher where jsh= '" + tbx5_jsh.Text + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { tbx5_xm.Text = ""; tbx5_zc.Text = ""; tbx5_zy.Text = ""; ddlist5_xw.SelectedIndex = 0; } else { tbx5_xm.Text = dr["jsm"].ToString(); tbx5_zc.Text = dr["zc"].ToString(); tbx5_zy.Text = dr["yjzc"].ToString(); } }
protected void btn_upload_Click(object sender, EventArgs e) { str_sql = "SELECT sqr,xmbh,zqbg_dName,zqbg from t_teacher_list where appNo = '" + Session["appNo"].ToString() + "';"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } string str_sqr = dr["sqr"].ToString(); string str_xmbh = dr["xmbh"].ToString(); string str_FileName = "教研课题(任务书)_" + str_sqr + "_" + str_xmbh; string str_pra = CommFun.UploadFile(fu_1, "任务书", str_FileName); if (str_pra == "" || str_pra == ",") { return; } else if (str_pra.Substring(0, 5) == "不允许上传") { Response.Write("<script>alert('" + str_pra + "!');</script>"); return; } str_sql = string.Format("update t_teacher_list set rws = '{0}',rws_dName = '{1}' where appNo = '{2}'", str_pra.Substring(str_pra.IndexOf(",") + 1), str_pra.Substring(0, str_pra.IndexOf(",")), Session["appNo"].ToString()); try { if (DBFun.ExecuteUpdate(str_sql)) { Response.Write("<script>alert('保存成功!');</script>"); bindData(); } else { Response.Write("<script>alert('保存失败!');</script>"); } } catch (Exception ee) { Response.Write("<script>alert('" + ee.Message.Replace("'", "|") + "');</script>"); } }
//计算论著报告得分 protected decimal GetScore_lzbg(string str_slqk, string str_pm, decimal dec_zs) { decimal dec_Score = 0; if (str_pm == "1") { str_pm = "第一作者"; } else if (str_pm != "1") { str_pm = "非第一作者"; } string str_sql = "select pwd from t_dict where name = '" + str_slqk + "' and content = '" + str_pm + "'"; dec_Score = Convert.ToDecimal(DBFun.ExecuteScalar(str_sql)); //if (str_slqk == "SCI收录期刊" || str_slqk == "EI收录期刊" || str_slqk == "核心期刊" || str_slqk == "一般期刊") // return dec_Score; if (str_slqk == "国际学术会议论文集" && str_pm == "第一作者") { str_sql = "select xdbg,istp from lzbgkq where sfzh = '" + Session["sfzh"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return(dec_Score); } if (Convert.ToBoolean(dr["xdbg"])) { return(Convert.ToDecimal(0.7)); } if (Convert.ToBoolean(dr["istp"])) { dec_Score += Convert.ToDecimal(0.3); } } else if (str_slqk == "专著" && dec_zs > 20) { str_sql = "select pwd from t_dict where name = '" + str_slqk + "' and content = '" + str_pm + "'"; dec_Score = Convert.ToDecimal(DBFun.ExecuteScalar(str_sql)); } return(dec_Score); }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("./SessionTimeOut.aspx?type=top"); } if (!IsPostBack) { lbl_title.Text = Request.QueryString["flag"]; string str_id = Request.QueryString["id"]; table20.Visible = (lbl_title.Text == "公告" || lbl_title.Text == "新闻"); table20.Visible = false; if (str_id == "" || str_id == null) { lbl_id.Text = "0"; } else { string str_sql = "select id,title,shijian,content ,admin,hits,leibie,leixing,hot from news where id = " + str_id; DataRow dr = DBFun.GetDataRow(str_sql); if (dr != null) { lbl_title.Text = dr["leibie"].ToString(); tbx_title.Text = dr["title"].ToString(); if (dr["hot"].ToString() == "true") { cbx_hot.Checked = true; } else { cbx_hot.Checked = false; } ftb_content.Text = dr["content"].ToString(); DwPath.SelectedIndex = Convert.ToInt16(dr["leixing"]); lbl_time.Text = "上次编辑时间:" + dr["shijian"].ToString(); lbl_admin.Text = "上次修改人为:" + dr["admin"].ToString(); lbl_id.Text = dr["id"].ToString(); } } } }
protected void bindData() { str_sql = "SELECT sqr,xmbh,rws_dName,rws from t_teacher_list where xmbh = '" + Session["xmbh"].ToString() + "';"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } string str_sqr = dr["sqr"].ToString(); string str_xmbh = dr["xmbh"].ToString(); string str_DocFilename = dr["rws"].ToString(); string str_HtmlFilename, str_mulu; str_mulu = "./任务书/"; if (str_DocFilename == "") { Response.Write("<script>alert('尚未上传期任务书!');</script>"); hl_1.ForeColor = System.Drawing.Color.Tomato; hl_1.Text = "尚未上传期任务书"; hl_1.NavigateUrl = ""; return; } str_HtmlFilename = str_DocFilename.Substring(0, str_DocFilename.LastIndexOf(".")) + ".pdf"; string str_MapPath = Server.MapPath(str_mulu); hl_1.ForeColor = System.Drawing.Color.FromArgb(000066); hl_1.Text = "查看任务书"; try { word.WdSaveFormat wdf = word.WdSaveFormat.wdFormatPDF; WordToal.Word2Format(str_MapPath + str_DocFilename, str_MapPath + str_HtmlFilename, wdf); } catch (Exception e) { CommFun.error_record(Session["jsh"].ToString(), Session["jsm"].ToString(), e.Message); return; } hl_1.NavigateUrl = str_mulu + str_HtmlFilename; }
private void bindData() { string str_qry = "SELECT url,name from t_dict where flm=2 ;"; DBFun.FillDwList(ddlist_gzdw, str_qry); str_qry = "SELECT gzdw,yourname,xrzw,csgz,sbzw,tbrq from cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); tbx_xm.Text = dr["yourname"].ToString(); try { ddlist_gzdw.SelectedValue = dr["gzdw"].ToString(); } catch { ddlist_gzdw.SelectedIndex = 0; } try { ddlist_xrzw.SelectedValue = dr["xrzw"].ToString(); } catch { ddlist_xrzw.SelectedIndex = 0; } try { ddlist_sbzw.SelectedValue = dr["sbzw"].ToString(); } catch { ddlist_sbzw.SelectedIndex = 1; } lbl_tbrq.Value = dr["tbrq"].ToString(); if (dr["tbrq"].ToString() == "") { lbl_tbrq.Value = DateTime.Now.ToString("yyyy-MM-dd"); } if (ddlist_sbzw.SelectedValue == "研究员") { ddlist_csgz_yjy.Visible = true; ddlist_csgz_zyjgg.Visible = false; try { ddlist_csgz_yjy.SelectedValue = dr["csgz"].ToString(); } catch { ddlist_csgz_yjy.SelectedIndex = 0; } } else { ddlist_csgz_yjy.Visible = false; ddlist_csgz_zyjgg.Visible = true; try { ddlist_csgz_zyjgg.SelectedValue = dr["csgz"].ToString(); } catch { ddlist_csgz_zyjgg.SelectedIndex = 0; } } }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { try { DataView dv = (DataView)Session["dv_detail"]; lbl_id.Text = dv.Table.Rows[e.NewEditIndex + GridView1.PageIndex * GridView1.PageSize]["sfzh"].ToString(); tbx_sfzh.Text = dv.Table.Rows[e.NewEditIndex + GridView1.PageIndex * GridView1.PageSize]["sfzh"].ToString(); tbx_sfzh.Enabled = false; //lbl_pwd.Text = dv.Table.Rows[e.NewEditIndex]["UserName"].ToString() + "的密码重设为:"; TD_AddUser.Visible = true; lbl_editflag.Text = "update"; string str_sql = "select loginname,Username,xingbie,gzdw,zc,phone from pszj where flag = 2 and sfzh = '" + lbl_id.Text + "'"; DataRow dr = DBFun.GetDataRow(str_sql); tbx_admin_name.Text = dr["loginname"].ToString(); tbx_user_name.Text = dr["Username"].ToString(); rbtnlist_xb.SelectedValue = dr["xingbie"].ToString(); tbx_gzdw.Text = dr["gzdw"].ToString(); tbx_zc.Text = dr["zc"].ToString(); tbx_pwd_new.Text = ""; } catch { } }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { try { DataView dv = (DataView)Session["dv_detail"]; lbl_id.Text = dv.Table.Rows[e.NewEditIndex + GridView1.PageIndex * GridView1.PageSize]["loginname"].ToString(); tbx_LoginName.Text = dv.Table.Rows[e.NewEditIndex + GridView1.PageIndex * GridView1.PageSize]["loginname"].ToString(); tbx_LoginName.Enabled = false; //lbl_pwd.Text = dv.Table.Rows[e.NewEditIndex]["UserName"].ToString() + "的密码重设为:"; TD_AddUser.Visible = true; lbl_editflag.Text = "update"; string str_sql = "select loginname,Username,zy,szbm,zc,jb from t_Expert where loginname = '" + lbl_id.Text + "'"; DataRow dr = DBFun.GetDataRow(str_sql); tbx_LoginName.Text = dr["loginname"].ToString(); tbx_UserName.Text = dr["Username"].ToString(); tbx_szbm.Text = dr["szbm"].ToString(); tbx_zc.Text = dr["zc"].ToString(); tbx_jb.Text = dr["jb"].ToString(); tbx_zy.Text = dr["zy"].ToString(); tbx_pwd.Text = ""; } catch { } }
private void bindData() { str_sql = " select ktmc,sqr,fs_pjys_sum,sftj,jypj,tj_flag " + " from t_teacher_list a ,t_zjry0 b,t_ExpertList0 c " + " where a.appNo = b.appNo and b.zjNo = c.LoginName and c.appYear = year(date())" + " and a.appNo= '" + lbl_appNo.Text + "'" + " and zjNo = '" + Session["admin_id"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { Response.Write("<script>alert('该申请号无效,请联系管理员!');</script>"); return; } lbl_ktmc.Text = dr["ktmc"].ToString(); lbl_sqr.Text = dr["sqr"].ToString(); rbl_tj.SelectedValue = dr["sftj"].ToString(); ftb_content.Text = dr["jypj"].ToString(); bool b_tj = Convert.ToBoolean(dr["tj_flag"]); btn_Ok.Visible = !b_tj; btn_OkReturn.Visible = !b_tj; }
protected void bingData() { str_sql = "SELECT sqr,jtsq_dName,jtsq from t_teacher_list where appNo = '" + Session["appNo"].ToString() + "';"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } string str_sqr = dr["sqr"].ToString(); string str_filename = dr["jtsq"].ToString(); string str_extName = str_filename.Substring(str_filename.LastIndexOf(".")).ToUpper(); string str_newfilename = "教研课题(结题申请)_" + str_sqr + str_extName; string str_MapPath = Server.MapPath("./结题申请/"); if (!File.Exists(str_MapPath + str_filename)) { Response.Write("<script>alert('文件不存在!');</script>"); return; } File.Copy(str_MapPath + str_filename, str_MapPath + str_newfilename, true); hl_1.NavigateUrl = "./结题申请/" + str_newfilename; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string str_sql = "select name,content from t_dict where flm = 8 and bm = 2"; DataRow dr = DBFun.GetDataRow(str_sql); if (dr == null) { return; } lbl_content.Text = dr["content"].ToString(); str_sql = string.Format("select edit_flag From cpry where sfzh='{0}'", Session["sfzh"].ToString()); if (DBFun.ExecuteScalar(str_sql).ToString().ToLower() == "false") { str_sql = string.Format("select sh_flag From cpry where sfzh='{0}'", Session["sfzh"].ToString()); dr = DBFun.GetDataRow(str_sql); lbl_content.Text = dr["sh_flag"].ToString(); } else { str_sql = string.Format("select ydsm From cpry where sfzh='{0}'", Session["sfzh"].ToString()); if (DBFun.ExecuteScalar(str_sql).ToString().ToLower() == "false") { cbx_agree.Visible = true; imgbtn_Next.Enabled = false; imgbtn_Next.ImageUrl = "./img/next_notenabled.gif"; } else { cbx_agree.Visible = false; imgbtn_Next.Enabled = true; imgbtn_Next.ImageUrl = "./img/next.gif"; } } } }
private void ReadFromDb(string ID) { //读取数据并显示 string strqry = string.Format("select * From T_class where id={0}", ID); DataRow dr = DBFun.GetDataRow(strqry); if (dr == null) { Response.Write("<Script>alert('读取失败!');history.go(-1);</script>"); Response.End(); } else { tb_Caption.Text = dr["caption"].ToString(); tb_ListImg.Text = dr["ListImg"].ToString(); tb_ListPageSize.Text = dr["ListPageSize"].ToString(); tb_ListSamePageSize.Text = dr["listSamepageSize"].ToString(); tb_Cidx.Text = dr["cidx"].ToString(); rbl_CIsOpen.Text = dr["CIsOpen"].ToString(); rbl_ListSortType.Text = dr["ListSortType"].ToString(); rbl_NotLogin.Text = dr["NotLoginIn"].ToString(); tb_CSort.Text = dr["CSort"].ToString(); } }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { try { str_sql = ViewState["sql"].ToString(); dv = DBFun.GetDataView(str_sql); lbl_id.Text = dv.Table.Rows[e.NewEditIndex + (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize]["sfzh"].ToString(); tbx_sfzh.Text = dv.Table.Rows[e.NewEditIndex + (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize]["sfzh"].ToString(); tbx_sfzh.Enabled = false; //lbl_pwd.Text = dv.Table.Rows[e.NewEditIndex]["UserName"].ToString() + "的密码重设为:"; TD_AddUser.Visible = true; lbl_editflag.Text = "update"; str_sql = "select loginname,Username,xingbie,gzdw,zc,phone from t_ExpertList3 where appyear=year(date()) and sfzh = '" + lbl_id.Text + "'"; DataRow dr = DBFun.GetDataRow(str_sql); tbx_admin_name.Text = dr["loginname"].ToString(); tbx_user_name.Text = dr["Username"].ToString(); rbtnlist_xb.SelectedValue = dr["xingbie"].ToString(); tbx_gzdw.Text = dr["gzdw"].ToString(); tbx_zc.Text = dr["zc"].ToString(); tbx_pwd_new.Text = ""; tbx_admin_name.Focus(); } catch { } }