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 { }
}
