/// <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);
}
