protected void btn_bk_Click(object sender, EventArgs e)
{
string str_sql = "";
string str_condition_yes = "";
string str_condition_no = "";
for (int i = 0; i < cbxlist_bk.Items.Count; i++)
{
if (cbxlist_bk.Items[i].Selected)
{
str_condition_yes = str_condition_yes + "," + cbxlist_bk.Items[i].Text;
}
else
{
str_condition_no = str_condition_no + "," + cbxlist_bk.Items[i].Text;
}
}
str_sql = "update lqsf set 录取完毕 = '是' where 本专科='本科' and instr( '" + str_condition_yes + "',地区)>0 ";
string str_sql1 = "update lqsf set 录取完毕 = '否' where 本专科='本科' and instr('" + str_condition_no + "',地区)>0";
if (str_condition_yes == "")
{
if (DBFun.ExecuteUpdate(str_sql1))
{
Response.Write(@"<script>alert('保存成功！');</script>");
}
else
{
Response.Write(@"<script>alert('保存失败！');</script>");
}
}
else if (str_condition_no == "")
{
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write(@"<script>alert('保存成功！');</script>");
}
else
{
Response.Write(@"<script>alert('保存失败！');</script>");
}
}
else
{
if (DBFun.ExecuteUpdate(str_sql) && DBFun.ExecuteUpdate(str_sql1))
{
Response.Write(@"<script>alert('保存成功！');</script>");
}
else
{
Response.Write(@"<script>alert('保存失败！');</script>");
}
}
}
private void DeleteFromDb(string ID)
{
//删除一个记录
string strsql = string.Format("Delete From T_class where id={0}", ID);
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('删除成功！');");
Response.Redirect(Request.UrlReferrer.ToString());
}
}
protected void gv_detail_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataView dv = (DataView)Session["dv_detail"];
string str_sql = "delete from download where id = " + dv.Table.Rows[e.RowIndex + gv_detail.PageIndex * gv_detail.PageSize]["id"].ToString();
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('删除成功！');</script>");
bindData();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataView dv = (DataView)Session["dv_detail"];
string str_sql = "delete from t_pszj where appyear = year(date()) and sfzh = '" + dv.Table.Rows[e.RowIndex + GridView1.PageIndex * GridView1.PageSize]["sfzh"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('删除成功！');</script>");
bindData();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//添加
//保存图片
string strsql;
string NewID = "";
string img_url = UploadPicFile(FileUpload1);
if (img_url == "")
{
img_url = "nopic.jpg"; //不上传图片，默认为无图片
}
strsql = string.Format("insert Into T_films (PathID,Film_name,Other_name,Film_director,Film_Player,"
+ "Film_class,Film_classID,Film_from,film_Level,film_clear,film_money,film_Pic,film_gut,"
+ "playtype,filmisseq,Filmisgood1,"
+ "filmisGood2,FilePhyPath,FileFolder,AllowDown,ShowType,SearchKey) values ({0},'{1}','{2}','{3}','{4}',"
+ "'{5}',{6},{7},{8},{9},{10},'{11}','{12}',"
+ "{13},{14},{15},"
+ "{16},'{17}','{18}',{19},{20},'{21}')",
DwPath.SelectedValue, TbFilmname.Text, TbOthername.Text, TbDirector.Text, TbPlayer.Text,
DwClass.SelectedItem.Text, DwClass.SelectedItem.Value, DwFrom.SelectedItem.Value,
DwLevel.Text, DwClear.Text, (TbMoney.Text == "" ? "0" : TbMoney.Text), img_url, TbGut.Text.Replace("'", "''"),
Rbfilmtype.Text, RbIsReq.Text, (CkbBest.Items[0].Selected ? 1 : 0), (CkbBest.Items[1].Selected ? 1 : 0),
TbFilmPhyPath.Text, uppath.Value, Rb_AllowDown.Text, Rb_Showtype.Text,
(Tb_SearchKey.Text == "" ? TbFilmname.Text : Tb_SearchKey.Text));
try
{
if (DBFun.ExecuteUpdate(strsql))
{
NewID = DBFun.SearchValue("select Max(ID) from T_films");
int ijs = 0;
for (int i = 1; i <= Convert.ToInt32(upjs.Value); i++)
{
strsql = string.Format("Insert Into [T_film_detail] (filename,filmid) values ('{0}',{1})",
Request["urla" + i], NewID);
if (DBFun.ExecuteUpdate(strsql))
{
ijs++;
}
}
strsql = string.Format("update T_films Set film_num = {0} where id={1}", ijs, NewID);
DBFun.ExecuteSql(strsql);
Response.Write("<script>alert('影片添加成功！');window.location.href='film_edit.aspx?Action=Edit&ID=" + NewID + "';</script>");
}
}
catch
{
Response.Write("<script>alert('影片添加失败！请确认填写正确！');</script>");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
str_sql = ViewState["sql"].ToString();
dv = DBFun.GetDataView(str_sql);
str_sql = "delete from t_ExpertList3 where appyear=year(date()) and LoginName = '" + dv.Table.Rows[e.RowIndex + (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize]["LoginName"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('移除成功！');</script>");
bindData();
}
}
protected void btn_confirm_Click(object sender, EventArgs e)
{
string str_pwd = tbx_pwd_new.Text.Trim();
//tbx_sfzh.Text = tbx_admin_name.Text;
if (lbl_editflag.Text == "insert")
{
//if (tbx_sfzh.Text.Length == 18)
//{
// str_pwd = tbx_sfzh.Text.Substring(8, 6);
//}
//else
//{
// str_pwd = tbx_sfzh.Text.Substring(6, 6);
//}
str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str_pwd, "MD5");
str_sql = "select count(*) from t_yszj where appyear=year(date()) and sfzh = '" + tbx_sfzh.Text.Trim() + "'";
if (DBFun.ExecuteScalar(str_sql).ToString() == "1")
{
Response.Write("<script>alert('该登录名已存在，请重新输入登录名！');</script>");
return;
}
str_sql = string.Format("Insert Into t_yszj (zjdm,Username,sfzh,pwd,xingbie,gzdw,zc,phone,appyear) select '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',url from t_dict where flm=8 and bm=6",
tbx_admin_name.Text.Trim(), tbx_user_name.Text.Trim(), tbx_sfzh.Text, str_pwd, rbtnlist_xb.SelectedValue, tbx_gzdw.Text, tbx_zc.Text, "");
}
else
{
if (str_pwd == null || str_pwd == "")
{
str_sql = string.Format("update t_yszj set loginname = '{0}',Username = '******',xingbie = '{2}',gzdw = '{3}',zc = '{4}',phone = '{5}'",
tbx_admin_name.Text.Trim(), tbx_user_name.Text.Trim(), rbtnlist_xb.SelectedValue, tbx_gzdw.Text, tbx_zc.Text, "");
}
else
{
str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(tbx_pwd_new.Text, "MD5");
str_sql = string.Format("update t_yszj set loginname = '{0}',Username = '******',pwd = '{2}',xingbie = '{3}',gzdw = '{4}',zc = '{5}',phone = '{6}'",
tbx_admin_name.Text.Trim(), tbx_user_name.Text.Trim(), str_pwd, rbtnlist_xb.SelectedValue, tbx_gzdw.Text, tbx_zc.Text, "");
}
str_sql = str_sql + " where appyear = year(date()) and sfzh = '" + lbl_id.Text + "'";
}
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('用户信息保存成功！');</script>");
bindData();
TD_AddUser.Visible = false;
}
else
{
Response.Write("<script>alert('用户信息保存失败！');</script>");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataView dv = (DataView)Session["dv_detail"];
string str_sql = "delete from master where id = " + dv.Table.Rows[e.RowIndex]["id"].ToString();
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('删除成功！');</script>");
GridView1.DataSource = DBFun.GetDataView("select * from master;");
GridView1.DataBind();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataView dv = (DataView)Session["dv_detail"];
string str_sql = string.Format("delete from t_dict where flm = {0} and bm = {1}",
3, Convert.ToInt16(dv.Table.Rows[e.RowIndex]["bm"]));
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('删除成功！');</script>");
bindData();
}
}
protected void Save()
{
DropDownList ddlist_pjys;
for (int i = 1; i <= 6; i++)
{
ddlist_pjys = (DropDownList)this.FindControl("ddlist_" + i.ToString());
if (Convert.ToInt16(ddlist_pjys.SelectedValue) == 0)
{
Response.Write("<script>alert('第 " + i.ToString() + " 项数据没有选择！');</script>");
return;
}
ddlist_pjys.Focus();
}
if (rbtnList_1.SelectedValue == null || rbtnList_1.SelectedValue == "")
{
Response.Write("<script>alert('请选择是否推荐申请人！');</script>");
return;
}
string str_sql = "SELECT count(*) from zjry where sfzh = '" + Session["sfzh"].ToString() +
"' and zjid = " + Session["zjid"].ToString();
string ls_jypj = ftb_jypj.Text.Replace("'", "’");
if (DBFun.ExecuteScalar(str_sql).ToString() == "1")
{
str_sql = string.Format("update zjry set fs_pjys1 = '{0}',fs_pjys2 = '{1}',fs_pjys3 = '{2}'," +
"fs_pjys4 = '{3}',fs_pjys5 = '{4}',fs_pjys6 = '{5}',fs_pjys_sum = '{6}',fs_sftj = '{7}',jypj = '{8}'," +
"psrq = '{9}' where zjid = {10} and sfzh = '{11}'",
ddlist_1.SelectedValue, ddlist_2.SelectedValue, ddlist_3.SelectedValue,
ddlist_4.SelectedValue, ddlist_5.SelectedValue, ddlist_6.SelectedValue, lbl_sum.Text, rbtnList_1.SelectedValue, ls_jypj,
DateTime.Now.ToString("yyyy年MM月dd日"), Convert.ToInt16(Session["zjid"]), Session["sfzh"].ToString());
}
else
{
str_sql = string.Format("insert into zjry (zjid,sfzh,fs_pjys1,fs_pjys2,fs_pjys3,fs_pjys4,fs_pjys5,fs_pjys6," +
"fs_pjys_sum,fs_sftj,jypj,psrq) values ({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')",
Convert.ToInt16(Session["zjid"]), Session["sfzh"].ToString(), ddlist_1.SelectedValue, ddlist_2.SelectedValue, ddlist_3.SelectedValue,
ddlist_4.SelectedValue, ddlist_5.SelectedValue, ddlist_6.SelectedValue, lbl_sum.Text, rbtnList_1.SelectedValue, ls_jypj,
DateTime.Now.ToString("yyyy年MM月dd日"));
}
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存成功！');</script>");
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
return;
}
bindData();
}
protected void Save(bool b_ShowMsg)
{
string str_sfzh, str_tjjg, str_sql, str_editflag;
DataView dv = (DataView)Session["dv_detail"];
RadioButtonList rbtnList_1;
TextBox tbx_fnd;
for (int i = 0; i < dv.Table.Rows.Count; i++) //循环GridView每一行
{
str_sfzh = dv.Table.Rows[i]["sfzh"].ToString();
if (i < GridView1.Rows.Count)
{
rbtnList_1 = (RadioButtonList)this.GridView1.Rows[i + GridView1.PageIndex * GridView1.PageSize].FindControl("rbtnList_tjjg");
tbx_fnd = (TextBox)this.GridView1.Rows[i + GridView1.PageIndex * GridView1.PageSize].FindControl("tbx_ID");
}
else
{
tbx_fnd = new TextBox();
int i_count = i + 1;
tbx_fnd.Text = i_count.ToString();
rbtnList_1 = new RadioButtonList();
try { rbtnList_1.SelectedValue = dv.Table.Rows[i]["tj_flag"].ToString(); }
catch { }
}
str_tjjg = rbtnList_1.SelectedValue.ToString();
if (str_tjjg == "推荐")
{
str_editflag = "false";
}
else
{
str_editflag = "true";
}
try { int j = Convert.ToInt16(tbx_fnd.Text); }
catch
{
Response.Write("<script>alert('排序ID只能是数字！');</script>");
return;
}
str_sql = "update cpry set tj_flag = '" + str_tjjg + "' , edit_flag = " + str_editflag + ",id =" + Convert.ToInt16(tbx_fnd.Text) + " where sfzh = '" + str_sfzh + "'";
if (!DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存失败！');</script>");
return;
}
}
if (b_ShowMsg)
{
Response.Write("<script>alert('保存成功！');</script>");
}
bindData();
}
protected void btn_confirm_Click(object sender, EventArgs e)
{
string str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(tbx_pwd_new.Text, "MD5");
string str_sql = "";
string str_sftj = Convert.ToString((rbtnlist_sftj.SelectedValue == "已提交"));
string str_flm = "";
string str_flag = "";
str_flm = "13";
str_flag = "tj_flag";
if (lbl_editflag.Text == "insert")
{
str_sql = "SELECT count(*) FROM t_dict WHERE flm = " + str_flm + " and url = '" + tbx_bm.Text + "'";
if (Convert.ToInt16(DBFun.ExecuteScalar(str_sql)) > 0)
{
Response.Write("<script>alert('单位编码已存在！');</script>");
tbx_bm.Focus();
return;
}
str_sql = " SELECT iif(isnull(max(bm)),1,max(bm)+1) AS maxbm" +
" FROM t_dict" +
" WHERE flm = " + str_flm + ";";
int i_maxbm = Convert.ToInt16(DBFun.ExecuteScalar(str_sql));
str_sql = string.Format("Insert Into t_dict (flm,bm,name,url,pwd," + str_flag + ") Values ({0},{1},'{2}','{3}','{4}',{5})",
str_flm, i_maxbm, tbx_dwmc.Text, tbx_bm.Text, str_pwd, str_sftj);
}
else
{
if (tbx_pwd_new.Text == null || tbx_pwd_new.Text == "")
{
str_sql = string.Format("update t_dict set name = '{0}',url = '{1}'," + str_flag + " = {2}",
tbx_dwmc.Text.Trim(), tbx_bm.Text.Trim(), str_sftj);
}
else
{
str_sql = string.Format("update t_dict set name = '{0}',url = '{1}'," + str_flag + " = {2},pwd = '{3}'",
tbx_dwmc.Text.Trim(), tbx_bm.Text.Trim(), str_sftj, str_pwd);
}
str_sql = str_sql + " where flm = " + str_flm + " and bm = " + lbl_id.Text;
}
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('部门信息保存成功！');</script>");
bindData();
TD_AddUser.Visible = false;
}
else
{
Response.Write("<script>alert('部门信息保存失败！');</script>");
}
}
protected void btn_Add_Click(object sender, EventArgs e)
{
//添加
string strsql = string.Format("Insert into [T_indexpage](film_classid,ImgUrl,templateid) values ({0},'{1}',{2})",
dw_class.Text, tb_ImgUrl.Text, dw_TemplateID.Text);
if (DBFun.ExecuteUpdate(strsql))
{
lbl_msg.Text = "添加成功！";
binddata();
}
}
protected void gv_Dept_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataView dv = (DataView)Session["dv_detail"];
string str_sql = "13";
str_sql = "delete from t_dict where flm = " + str_sql + " and bm = " + dv.Table.Rows[e.RowIndex + gv_Dept.PageIndex * gv_Dept.PageSize]["bm"].ToString();
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('删除成功！');</script>");
bindData();
}
}
protected void btn_InitPwd_Click(object sender, EventArgs e)
{
string str_sql = "Update t_dict Set url = '" + tbx_InitPwd.Text + "' Where flm = 8 and bm = 15 ";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存成功！');</script>");
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
string str_sql = "update cpry set reason = '" + tbx_Reason.Text + "' where sfzh = '" + Session["sfzh"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存成功！');</script>");
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
}
protected void btn_InitPwd_Click(object sender, EventArgs e)
{
string str_sql = "Update t_dict Set InitPwd = '" + tbx_InitPwd.Text + "' Where flm = 2 and url = '" + Session["admin_id"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存成功！');</script>");
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
}
protected int Save(bool b_ShowMsg)
{
string strOpid = "";
string strsql;
TextBox tbx_fnd; //排列顺序号
TextBox tbx_fnd1; //排列顺序号 用来比较是否有重复
int i_Number = 0; //特殊津贴人员 专家推荐人数
strsql = "Select count(*) From t_zjry Where appyear=year(date()) And zj_sfzh = '" + Session["admin_id"].ToString() + "' and sftj ";
DataView dv = (DataView)Session["dv_detail"];
for (int i = 0; i < gv.Rows.Count; i++)
{
CheckBox ckb = (CheckBox)gv.Rows[i].FindControl("cbx_1");
string str_sfzh = dv.Table.Rows[i + gv.PageIndex * gv.PageSize]["jsh"].ToString();
if (ckb.Checked)
{
i_Number++;
if (strOpid == "")
{
strOpid += ("('" + str_sfzh);
}
else
{
strOpid += ("','" + str_sfzh);
}
}
}
strOpid += "')";
if (strOpid == "')")
{
strOpid = "('')";
}
//投票
strsql = string.Format("update t_zjry set sftj = true where appyear=year(date()) and zj_sfzh='{0}' and cpry_sfzh in {1}", Session["admin_id"].ToString(), strOpid);
DBFun.ExecuteUpdate(strsql);
strsql = string.Format("update t_zjry set sftj = false where appyear=year(date()) and zj_sfzh='{0}' and cpry_sfzh not in {1}", Session["admin_id"].ToString(), strOpid);
DBFun.ExecuteUpdate(strsql);
if (b_ShowMsg)
{
Response.Write("<script>alert('已保存推荐结果！');</script>");
}
bindData();
return(1);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
str_sql = ViewState["sql"].ToString();
dv = DBFun.GetDataView(str_sql);
RadioButtonList rbl_fnd;
rbl_fnd = (RadioButtonList)this.GridView1.Rows[e.RowIndex].FindControl("rbl_tj");
str_sql = "update t_ExpertList0 set tj_flag = " + rbl_fnd.SelectedValue + " where appyear=year(date()) and LoginName = '" + dv.Table.Rows[e.RowIndex + GridView1.PageIndex * GridView1.PageSize]["LoginName"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('修改成功！');</script>");
bindData();
}
}
protected void btn_pingjia_save_Click(object sender, EventArgs e)
{
TD1.Visible = false;
string strsql = string.Format("update cpry set pingjia = '" + TextBox1.Text + "' where sfzh ='" + Session["sfzh"].ToString() + "'");
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('评价成功！');</script>");
}
else
{
Response.Write("<script>alert('评价失败！');</script>");
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataView dv = (DataView)Session["dv_detail"];
RadioButtonList rbl_fnd;
rbl_fnd = (RadioButtonList)this.GridView1.Rows[e.RowIndex].FindControl("rbl_tj");
string str_sql = "update t_pszj set tj_flag = " + rbl_fnd.SelectedValue + " where appyear=year(date()) and sfzh = '" + dv.Table.Rows[e.RowIndex + GridView1.PageIndex * GridView1.PageSize]["sfzh"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('修改成功！');</script>");
bindData();
}
}
protected void save(string str_bm, string str_Value)
{
string str_sql = "update t_dict set url = '" + str_Value + "' where flm = 8 and bm = " + str_bm;
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存成功！');</script>");
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
bindData();
}
protected void btn_confirm_Click(object sender, EventArgs e)
{
TD_AddUser.Visible = false;
str_sql = string.Format("update t_teacher_list set yj21 = '" + tbx_yj2.Text + "' where appNo ='" + lbl_appNo.Text + "'");
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('意见填写成功！');</script>");
bindData();
}
else
{
Response.Write("<script>alert('意见填写失败！');</script>");
}
}
protected void btn_Change_Click(object sender, EventArgs e)
{
string strOldid = "";
string strNewid = "";
int i_count = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("cbx_select");
if (ckb.Checked)
{
if (strOldid == "")
{
strOldid = GridView1.Rows[i].Cells[0].Text;
}
else
{
strNewid = GridView1.Rows[i].Cells[0].Text;
}
i_count++;
}
}
if (i_count != 2)
{
Response.Write("<script>alert('选且只能选择两条记录！');</script>");
}
else
{
//互换
string strsql = " select sfzh from t_yszj where appyear=year(date()) and id in (" + strOldid + "," + strNewid + ") ;";
DataTable dt = DBFun.dataTable(strsql);
strOldid = dt.Rows[0][0].ToString();
strNewid = dt.Rows[1][0].ToString();
strsql = " select count(*) from zjry where zj_sfzh = '" + strOldid + "' ;";
if (Convert.ToInt16(DBFun.ExecuteScalar(strsql)) > 0)
{
strsql = " update zjry set zj_sfzh = '" + strNewid + "' where flag = " + lbl_type.Text + " and zj_sfzh = '" + strOldid + "'";
}
else
{
strsql = " update zjry set zj_sfzh = '" + strOldid + "' where flag = " + lbl_type.Text + " and zj_sfzh = '" + strNewid + "'";
}
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('互换成功！');</script>");
bindData();
}
}
}
protected void btn_Ok_Click(object sender, EventArgs e)
{
//保存
if (btn_Ok.Text == "添加")
{
try
{
string strsql = string.Format("Insert into T_class(Caption,ListImg,Listpagesize,ListSamePageSize,Cidx,"
+ "CIsOpen,ListsortType,NotLoginIn,CSort) "
+ " values('{0}','{1}',{2},{3},{4},{5},{6},{7},{8})",
tb_Caption.Text, tb_ListImg.Text, tb_ListPageSize.Text, tb_ListSamePageSize.Text, tb_Cidx.Text,
rbl_CIsOpen.Text, rbl_ListSortType.Text, rbl_NotLogin.Text, tb_CSort.Text);
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('数据添加成功！');window.location.href='film_classAddEdit.aspx?Action=Edit&id=" + DBFun.SearchValue("select Max(id) from T_class") + "';</script>");
}
else
{
Response.Write("<scritp>alert('添加失败！请检查是否填写正确。');</script>");
}
}
catch (Exception ex)
{
Response.Write(@"<script>alert('添加失败！请检查是否填写正确！" + ex.Message + "');</script>");
}
}
else if (btn_Ok.Text == "确认修改")
{
try
{
string strsql = string.Format("Update T_class Set Caption='{0}',ListImg='{1}',Listpagesize={2},ListSamePageSize={3},Cidx={4},"
+ "CIsOpen={5},ListsortType={6},NotLoginIn={7} ,Csort={8} where id={9}",
tb_Caption.Text, tb_ListImg.Text, tb_ListPageSize.Text, tb_ListSamePageSize.Text, tb_Cidx.Text,
rbl_CIsOpen.Text, rbl_ListSortType.Text, rbl_NotLogin.Text, tb_CSort.Text, Request.QueryString["ID"]);
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('数据修改成功！');document.reload();</script>");
}
else
{
Response.Write("<scritp>alert('保存失败！请检查是否填写正确。');</script>");
}
}
catch
{
Response.Write("<script>alert('保存失败！请检查是否填写正确！');</script>");
}
}
}
protected void btn_confirm_Click(object sender, EventArgs e)
{
str_sql = "update t_teacher_list set szbm='" + ddlist_dept.SelectedValue + "',Status=" + ddlist_Status.SelectedValue + " where appNo='" + tbx_appNo.Text + "' ";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存成功！');</script>");
bindData();
TD_AddUser.Visible = false;
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
}
//删除附件
protected void btn_fj_del_Click(object sender, EventArgs e)
{
string str_sql = string.Format("update yxxwlw_cpry set lw_fj = '',lw_fj_displayname = '' where sfzh = '{0}'",
Session["sfzh"].ToString());
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('附件删除成功！');</script>");
}
else
{
Response.Write("<script>alert('附件删除失败！');</script>");
}
bindData();
}
protected void Commit()
{
string str_sql = string.Format("update yxxwlw_cpry set edit_flag = {0} where sfzh = '{1}'",
false, Session["sfzh"].ToString());
if (DBFun.ExecuteUpdate(str_sql))
{
string str_url = "PrintPreview_lw.aspx";
Response.Write("<script>alert('提交成功！');location.href = '" + str_url + "';</script>");
}
else
{
Response.Write("<script>alert('提交失败！');</script>");
}
}
protected void btn_confirm_Click(object sender, EventArgs e)
{
string str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(tbx_pwd.Text, "MD5");
string str_sql = str_sql = "Update master Set admin_pwd = '" + str_pwd + "' Where id = " + lbl_id.Text;
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('密码修改成功！');</script>");
TD_pwd.Visible = false;
}
else
{
Response.Write("<script>alert('密码修改失败！');</script>");
}
}
protected void btn_CreateRws_Click(object sender, EventArgs e)
{
str_sql = "delete from t_Rws where appYear=year(date())";
DBFun.ExecuteSql(str_sql);
str_sql = "exec C_Rws ";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('生成成功！');</script>");
bindData();
}
else
{
Response.Write("<script>alert('生成失败！');</script>");
}
}
