/// <summary> /// 导入数据 /// </summary> /// <param name="pLeixing"></param> /// <returns></returns> public xt_result ImportFile(string pLeixing) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@leixing", SqlDbType.VarChar), new SqlParameter("@ReturnValue", SqlDbType.Int) }; param[0].Value = pLeixing; param[1].Direction = ParameterDirection.ReturnValue; xt_result sult = new xt_result(); sult.Message = "数据导入完毕!"; try { sult.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.StoredProcedure, "pro_import", param); } catch (Exception e) { sult.Message = e.Message; sult.Message = sult.Message.Replace("\r\n", ""); sult.Message = sult.Message.Replace("'", ""); return(sult); } if (param[1].Value == null) { sult.ReturnValue = -1; } else { sult.ReturnValue = (int)param[1].Value; } return(sult); }
/// <summary> /// 删除菜单 /// </summary> /// <param name="?"></param> /// <returns></returns> public xt_result getShanchucaidan(caidan mCaidan) { string sql = " delete caidan where xuhao=@xuhao and yingyong=@yingyong;"; sql = sql + "delete gongneng where xuhao=@xuhao and yingyong=@yingyong;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar), new SqlParameter("@xuhao", SqlDbType.NVarChar) }; param[0].Value = mCaidan.Yingyong; param[1].Value = mCaidan.Xuhao; xt_result result = new xt_result(); result.Message = "删除 成功"; try { result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param); if (result.ReturnInt < 1) { result.Message = "删除 失败"; } } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", "\\n"); result.Message = result.Message.Replace("'", ""); } return(result); }
/// <summary> /// 取父节点下子节点的数据,进行删除! /// </summary> /// <param name="tn"></param> /// <param name="mGongneng"></param> protected void getChildNodevalue(TreeNode tn, gongneng mGongneng) { for (int i = 0; i < tn.ChildNodes.Count; i++) { if (tn.ChildNodes[i].Checked) { mGongneng.Xuhao = tn.ChildNodes[i].Value.ToString(); mGongneng.Bianhao = tn.ChildNodes[i].Value.ToString(); mGongneng.Mingcheng = tn.ChildNodes[i].Text.ToString(); if (checkgongnengcanshu(mGongneng) == 1) { //如果没有功能则直接删除数据库当中的对应列 result = bGongneng.DelGongneng(mGongneng); if (result.ReturnInt < 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('用户功能权限分配失败,请联系管理员!')</script>", false); break; } } else { //如果有功能权限,则先删在增加 result = bGongneng.DelGongneng(mGongneng); result = bGongneng.InsertGongneng(mGongneng); if (result.ReturnInt < 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('用户功能权限分配失败,请联系管理员!')</script>", false); break; } } } } }
protected void Button5_Click(object sender, EventArgs e) { string path = "C:/Users/hexing/Desktop/何兴测试/动态导航/hexing/WebApplication1/"; xt_result result = bProcedure.ImportMingce(Session["daihao"].ToString(), "1", "pro_daoru_kaodian_01", path); ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('系统信息:" + result.Message + "')</script>", false); }
protected void Button1_Click(object sender, EventArgs e) { string pDaihao = ""; mCaidan.Yingyong = RadioButtonList1.SelectedValue; mCaidan.Bianhao = TextBox1.Text.Trim().ToString(); mCaidan.Xuhao = TextBox2.Text.Trim().ToString(); mCaidan.Fuxuhao = TextBox3.Text.Trim().ToString(); mCaidan.Mingcheng = TextBox4.Text.Trim().ToString(); mCaidan.Jiancheng = ""; mCaidan.Url = TextBox5.Text.Trim().ToString(); mCaidan.Image = ""; switch (mCaidan.Yingyong) { case "Admin": pDaihao = "99"; break; case "Kaosheng": pDaihao = "01"; break; default: pDaihao = "99"; break; } xt_result result = bCaidan.getCharucaidan(mCaidan, pDaihao); if (result.ReturnInt < 1) { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert(' 保存菜单失败!" + result.Message + " !')</script>", false); } ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('保存菜单成功! " + result.Message + " !')</script>", false); }
protected void Button3_Click(object sender, EventArgs e) { mCaidan.Yingyong = RadioButtonList1.SelectedValue; mCaidan.Bianhao = TextBox1.Text.Trim().ToString(); mCaidan.Xuhao = TextBox2.Text.Trim().ToString(); mCaidan.Fuxuhao = TextBox3.Text.Trim().ToString(); mCaidan.Mingcheng = TextBox4.Text.Trim().ToString(); mCaidan.Jiancheng = ""; mCaidan.Url = TextBox5.Text.Trim().ToString(); mCaidan.Image = ""; xt_result result = bCaidan.getGengaicaidan(mCaidan); ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert(' " + result.Message + " !')</script>", false); }
/// <summary> /// 删除功能 /// </summary> /// <param name="mGongneng"></param> /// <returns></returns> public xt_result DelGongneng(gongneng mGongneng) { string sql = "delete from gongneng where daihao=@daihao and yingyong=@yingyong and bianhao=@bianhao "; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@daihao", SqlDbType.VarChar, 20), new SqlParameter("@yingyong", SqlDbType.VarChar, 20), new SqlParameter("@bianhao", SqlDbType.VarChar, 6) }; param[0].Value = mGongneng.Daihao; param[1].Value = mGongneng.Yingyong; param[2].Value = mGongneng.Bianhao; xt_result result = new xt_result(); result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Admin, sql, param); return(result); }
//protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) //{ // setGridViewRowDataBound("Chaxun", e, " 人"); //} /// <summary> /// 行更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string pDaihao = GridView1.Rows[e.RowIndex].Cells[0].Text; string pCanshu = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].FindControl("TextBox_mingcheng")).Text; xt_result result = new xt_result(); result = bYonghu.Update_Canshu(pDaihao, pCanshu); if (result.ReturnInt < 1) { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('保存参数失败!')</script>", false); return; } ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('保存参数成功!')</script>", false); GridView1.EditIndex = -1; getData("", ""); }
/// <summary> /// 插入菜单 /// </summary> /// <param name="?"></param> /// <returns></returns> public xt_result getCharucaidan(caidan mCaidan, string pDaihao) { string sql = "insert into caidan(yingyong,bianhao,xuhao,fuxuhao,mingcheng,jiancheng,url,image) values(@yingyong,@bianhao,@xuhao,@fuxuhao,@mingcheng,@jiancheng,@url,@image);"; sql = sql + "insert into gongneng(daihao,yingyong,bianhao,xuhao,mingcheng,canshu0,canshu1,canshu2,canshu3,canshu4,canshu5,canshu6,canshu7,canshu8,canshu9)values( @pDaihao,@yingyong,@bianhao,@xuhao,@mingcheng,'0','0','0','0','0','0','0','0','0','0')"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar), new SqlParameter("@bianhao", SqlDbType.NVarChar), new SqlParameter("@xuhao", SqlDbType.NVarChar), new SqlParameter("@fuxuhao", SqlDbType.VarChar), new SqlParameter("@mingcheng", SqlDbType.VarChar), new SqlParameter("@jiancheng", SqlDbType.VarChar), new SqlParameter("@url", SqlDbType.VarChar), new SqlParameter("@image", SqlDbType.VarChar), new SqlParameter("@pDaihao", SqlDbType.VarChar), }; param[0].Value = mCaidan.Yingyong; param[1].Value = mCaidan.Bianhao; param[2].Value = mCaidan.Xuhao; param[3].Value = mCaidan.Fuxuhao; param[4].Value = mCaidan.Mingcheng; param[5].Value = mCaidan.Jiancheng; param[6].Value = mCaidan.Url; param[7].Value = mCaidan.Image; param[8].Value = pDaihao; xt_result result = new xt_result(); result.Message = "插入 成功"; try { result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param); if (result.ReturnInt < 1) { result.Message = "插入 失败"; } } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", "\\n"); result.Message = result.Message.Replace("'", ""); } return(result); }
/// <summary> /// 记录应用系统错误消息 /// </summary> /// <param name="mError">错误实体</param> /// <returns>xt_result</returns> public xt_result SaveError(IList <xt_error> lError) { //错误消息 string sql = ""; int i = lError.Count; for (int j = 0; j < i; j++) { if (lError[j].Message.Length > 500) { lError[j].Message = lError[j].Message.Substring(0, 498); } sql = sql + "insert into xt_error (application,message) values ('" + lError[j].Application + "','" + lError[j].Message + "') ;"; } //开始事务 xt_result result = new xt_result(); SqlTransaction Trans; SqlConnection conn = SQLHelper.CreateConnection(base.User_Admin); conn.Open(); Trans = conn.BeginTransaction("trans1"); try { result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Admin, CommandType.Text, sql, null); if (result.ReturnInt > 0) { Trans.Commit(); } } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", "\\n"); result.Message = result.Message.Replace("'", ""); Trans.Rollback(); } finally { conn.Close(); } return(result); }
/// <summary> /// 更新菜单 /// </summary> /// <param name="mCaidan"></param> /// <returns></returns> public xt_result getGengaicaidan(caidan mCaidan) { string sql = "update caidan set yingyong=@yingyong,xuhao=@xuhao,fuxuhao=@fuxuhao,mingcheng=@mingcheng,jiancheng=@jiancheng,url=@url,image=@image where bianhao=@bianhao "; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar), new SqlParameter("@bianhao", SqlDbType.NVarChar), new SqlParameter("@xuhao", SqlDbType.NVarChar), new SqlParameter("@fuxuhao", SqlDbType.VarChar), new SqlParameter("@mingcheng", SqlDbType.VarChar), new SqlParameter("@jiancheng", SqlDbType.VarChar), new SqlParameter("@url", SqlDbType.VarChar), new SqlParameter("@image", SqlDbType.VarChar), }; param[0].Value = mCaidan.Yingyong; param[1].Value = mCaidan.Bianhao; param[2].Value = mCaidan.Xuhao; param[3].Value = mCaidan.Fuxuhao; param[4].Value = mCaidan.Mingcheng; param[5].Value = mCaidan.Jiancheng; param[6].Value = mCaidan.Url; param[7].Value = mCaidan.Image; //开始事务 xt_result result = new xt_result(); result.Message = "更新 成功"; try { result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param); if (result.ReturnInt < 1) { result.Message = "更新 失败"; } } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", "\\n"); result.Message = result.Message.Replace("'", ""); } return(result); }
/// <summary> /// 更新xt_tongji中的人数 /// </summary> /// <param name="renshu"></param> /// <returns></returns> public xt_result UpData(int renshu) { string sql = "update xt_tongji set renshu=@renshu;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@renshu", SqlDbType.VarChar), }; param[0].Value = renshu; //开始事务 xt_result result = new xt_result(); result.Message = "更新数据 成功"; SqlTransaction Trans; SqlConnection conn = SQLHelper.CreateConnection(base.User_Admin); conn.Open(); Trans = conn.BeginTransaction("trans1"); try { result.ReturnInt = SQLHelper.ExecuteNonQuery(Trans, CommandType.Text, sql, param); if (result.ReturnInt > 0) { Trans.Commit(); } else { result.Message = "更新数据 失败"; } } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", ""); result.Message = result.Message.Replace("'", ""); Trans.Rollback(); } finally { conn.Close(); } return(result); }
/// <summary> /// 更新参数值 /// </summary> /// <param name="pDaihao">参数名</param> /// <param name="pCanshu">参数值</param> /// <returns>返回影响行数</returns> public xt_result Update_Canshu(string pDaihao, string pCanshu) { string sql = "update yonghu set mingcheng=@mingcheng where daihao=@daihao"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@daihao", SqlDbType.VarChar, 50), new SqlParameter("@mingcheng", SqlDbType.VarChar, 50) }; param[0].Value = pDaihao; param[1].Value = pCanshu; xt_result sult = new xt_result(); sult.Message = "更新成功!"; try { sult.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param); } catch (Exception e) { sult.Message = e.Message; sult.Message = sult.Message.Replace("\r\n", ""); sult.Message = sult.Message.Replace("'", ""); } return(sult); }
/// <summary> /// 插入功能 /// </summary> /// <param name="mXt_gongneng"></param> /// <returns></returns> public xt_result InsertGongneng(gongneng mGongneng) { string sql = "insert into gongneng values (@daihao,@yingyong,@bianhao,@xuhao,@mingcheng,@canshu0,@canshu1,@canshu2,@canshu3,@canshu4,@canshu5,@canshu6,@canshu7,@canshu8,@canshu9 )"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@daihao", SqlDbType.NVarChar, 20), new SqlParameter("@yingyong", SqlDbType.NVarChar, 20), new SqlParameter("@bianhao", SqlDbType.NVarChar, 6), new SqlParameter("@xuhao", SqlDbType.NVarChar, 6), new SqlParameter("@mingcheng", SqlDbType.NVarChar, 10), new SqlParameter("@canshu0", SqlDbType.NVarChar, 1), new SqlParameter("@canshu1", SqlDbType.NVarChar, 1), new SqlParameter("@canshu2", SqlDbType.NVarChar, 1), new SqlParameter("@canshu3", SqlDbType.NVarChar, 1), new SqlParameter("@canshu4", SqlDbType.NVarChar, 1), new SqlParameter("@canshu5", SqlDbType.NVarChar, 1), new SqlParameter("@canshu6", SqlDbType.NVarChar, 1), new SqlParameter("@canshu7", SqlDbType.NVarChar, 1), new SqlParameter("@canshu8", SqlDbType.NVarChar, 1), new SqlParameter("@canshu9", SqlDbType.NVarChar, 1) }; param[0].Value = mGongneng.Daihao; param[1].Value = mGongneng.Yingyong; param[2].Value = mGongneng.Bianhao; param[3].Value = mGongneng.Xuhao; param[4].Value = mGongneng.Mingcheng; param[5].Value = mGongneng.Canshu0; param[6].Value = mGongneng.Canshu1; param[7].Value = mGongneng.Canshu2; param[8].Value = mGongneng.Canshu3; param[9].Value = mGongneng.Canshu4; param[10].Value = mGongneng.Canshu5; param[11].Value = mGongneng.Canshu6; param[12].Value = mGongneng.Canshu7; param[13].Value = mGongneng.Canshu8; param[14].Value = mGongneng.Canshu9; //开始事务 xt_result result = new xt_result(); SqlTransaction Trans; SqlConnection conn = SQLHelper.CreateConnection(base.User_Admin); conn.Open(); Trans = conn.BeginTransaction("trans1"); try { result.ReturnInt = SQLHelper.ExecuteNonQuery(Trans, CommandType.Text, sql, param); if (result.ReturnInt > 0) { Trans.Commit(); } } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", "\\n"); result.Message = result.Message.Replace("'", ""); Trans.Rollback(); } finally { conn.Close(); } return(result); }
/// <summary> /// 导入名册 /// </summary> /// <param name="pYonghu"></param> /// <param name="pBiaozhi"></param> /// <returns></returns> public xt_result ImportMingce(string pYonghu, string pBiaozhi, string pProcedure, string path) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yonghu", SqlDbType.VarChar, 20), new SqlParameter("@biaozhi", SqlDbType.VarChar, 2), new SqlParameter("@path", SqlDbType.VarChar, 100), new SqlParameter("@ReturnValue", SqlDbType.Int) }; param[0].Value = pYonghu; param[1].Value = pBiaozhi; param[2].Value = path; param[3].Direction = ParameterDirection.ReturnValue; xt_result result = new xt_result(); switch (pProcedure) { case "pro_daoru_kaochangmingce_01": result.Message = "导入考场临时表成功"; break; case "pro_daoru_kaochangmingce_02": result.Message = "导入考场信息成功"; break; case "pro_daoru_chengji_01": result.Message = "导入新生成绩临时表成功"; break; case "pro_daoru_chengji_02": result.Message = "生成新生成绩库成功"; break; case "pro_daoru_mingce_01": result.Message = "导入新生名册临时表成功"; break; case "pro_daoru_mingce_02": result.Message = "生成新生名册库成功"; break; case "pro_daoru_jiaofei_01": result.Message = "导入缴费清单临时表成功"; break; case "pro_daoru_jiaofei_02": result.Message = "生成缴费清单库成功"; break; case "pro_daoru_kaoshizhuanye_01": result.Message = "导入考试专业临时表成功"; break; case "pro_daoru_kaoshizhuanye_02": result.Message = "生成考试专业库成功"; break; case "pro_daoru_kaodian_01": result.Message = "导入考点临时表成功"; break; case "pro_daoru_kaodian_02": result.Message = "生成考点库成功"; break; case "pro_daoru_kaikaozhuanye_01": result.Message = "导入开考专业成功"; break; case "pro_daoru_kaikaozhuanye_02": result.Message = "生成开考专业成功"; break; case "pro_daoru_bmxxShenhe_01": result.Message = "导入统考审核临时表成功"; break; case "pro_daoru_bmxxShenhe_02": result.Message = "生成统考审核结果成功"; break; } try { result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.StoredProcedure, pProcedure, param); } catch (Exception e) { result.Message = e.Message; result.Message = result.Message.Replace("\r\n", "\\n"); result.Message = result.Message.Replace("'", ""); } if (param[3].Value == null) { result.ReturnValue = -99; } else { result.ReturnValue = (int)param[3].Value; } switch (result.ReturnValue) { case -1: switch (pProcedure) { case "pro_daoru_jiaofei_02": result.Message = "更新缴费金额失败"; break; } break; } return(result); }
protected void Button_save_Click(object sender, EventArgs e) { gongneng mGongneng = new gongneng(); mGongneng.Yingyong = RadioButtonList_Yingyong.SelectedValue; string pCanshu; // 取参数 for (int j = 0; j < CheckBoxList_canshu.Items.Count; j++) { if (CheckBoxList_canshu.Items[j].Selected) { pCanshu = "1"; } else { pCanshu = "0"; } switch (j) { case 0: mGongneng.Canshu0 = pCanshu; break; case 1: mGongneng.Canshu1 = pCanshu; break; case 2: mGongneng.Canshu2 = pCanshu; break; case 3: mGongneng.Canshu3 = pCanshu; break; case 4: mGongneng.Canshu4 = pCanshu; break; case 5: mGongneng.Canshu5 = pCanshu; break; case 6: mGongneng.Canshu6 = pCanshu; break; case 7: mGongneng.Canshu7 = pCanshu; break; case 8: mGongneng.Canshu8 = pCanshu; break; case 9: mGongneng.Canshu9 = pCanshu; break; } } // 循环取treeview3 父节点的数据 for (int j = 0; j < TreeView3.Nodes.Count; j++) { if (TreeView3.Nodes[j].Checked) { mGongneng.Daihao = TreeView3.Nodes[j].Value.ToString(); for (int i = 0; i < TreeView1.Nodes.Count; i++) { if (TreeView1.Nodes[i].Checked) { mGongneng.Xuhao = TreeView1.Nodes[i].Value.ToString(); mGongneng.Bianhao = TreeView1.Nodes[i].Value.ToString(); mGongneng.Mingcheng = TreeView1.Nodes[i].Text.ToString(); if (checkgongnengcanshu(mGongneng) == 1) { result = bGongneng.DelGongneng(mGongneng); if (result.ReturnInt < 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('用户功能权限分配失败,请联系管理员!')</script>", false); break; } } else { result = bGongneng.DelGongneng(mGongneng); result = bGongneng.InsertGongneng(mGongneng); } // 循环取父节点 下子节点的数据 getChildNodevalue(TreeView1.Nodes[i], mGongneng); } else { // 在不经过父节点的情况下 取子节点数据 getChildNodevalue(TreeView1.Nodes[i], mGongneng); } } } } ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "<script>alert('用户功能权限分配成功!')</script>", false); }