/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Dianda.Model.USER_Groups model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_Groups(");
strSql.Append("ID,NAME,CONTENTS,ROLE,DELFLAG,ISMOREN,TAGS)");
strSql.Append(" values (");
strSql.Append("@ID,@NAME,@CONTENTS,@ROLE,@DELFLAG,@ISMOREN,@TAGS)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 50),
new SqlParameter("@NAME", SqlDbType.VarChar, 50),
new SqlParameter("@CONTENTS", SqlDbType.Text),
new SqlParameter("@ROLE", SqlDbType.Text),
new SqlParameter("@DELFLAG", SqlDbType.Int, 4),
new SqlParameter("@ISMOREN", SqlDbType.Int, 4),
new SqlParameter("@TAGS", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.NAME;
parameters[2].Value = model.CONTENTS;
parameters[3].Value = model.ROLE;
parameters[4].Value = model.DELFLAG;
parameters[5].Value = model.ISMOREN;
parameters[6].Value = model.TAGS;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Dianda.Model.USER_Groups model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_Groups set ");
strSql.Append("NAME=@NAME,");
strSql.Append("CONTENTS=@CONTENTS,");
strSql.Append("ROLE=@ROLE,");
strSql.Append("DELFLAG=@DELFLAG,");
strSql.Append("ISMOREN=@ISMOREN,");
strSql.Append("TAGS=@TAGS");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 50),
new SqlParameter("@NAME", SqlDbType.VarChar, 50),
new SqlParameter("@CONTENTS", SqlDbType.Text),
new SqlParameter("@ROLE", SqlDbType.Text),
new SqlParameter("@DELFLAG", SqlDbType.Int, 4),
new SqlParameter("@ISMOREN", SqlDbType.Int, 4),
new SqlParameter("@TAGS", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.NAME;
parameters[2].Value = model.CONTENTS;
parameters[3].Value = model.ROLE;
parameters[4].Value = model.DELFLAG;
parameters[5].Value = model.ISMOREN;
parameters[6].Value = model.TAGS;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 点击删除按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_delete_onclick(object sender, EventArgs e)
{
int num = 0;
int rows = GridView1.Rows.Count;
if (rows > 0)
{
for (int i = 0; i < rows; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_choose");
if (cb.Checked)
{
num = num + 1;
}
}
if (num == 0)
{
tag.Text = "删除时最少选择一条数据！";
}
else
{
tag.Text = "";
for (int j = 0; j < rows; j++)
{
CheckBox cb1 = (CheckBox)GridView1.Rows[j].Cells[0].FindControl("CheckBox_choose");
HiddenField hid = (HiddenField)GridView1.Rows[j].Cells[0].FindControl("Hid_ID");
if (cb1.Checked)
{
//获取到当前部门或岗位的基本信息
userGroupModel = GroupsBll.GetModel(hid.Value.ToString());
//将删除标记设为1
userGroupModel.DELFLAG = 1;
GroupsBll.Update(userGroupModel);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "删除" + Request["tags"].ToString(), "删除" + userGroupModel.NAME + "成功");
//添加操作日志
}
}
//tag.Text = "操作成功！";
//string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "&tags=" +Request["tags"]+ "\";</script>";
//Response.Write(coutws);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的列表页面');javascript:location='manage.aspx?pageindex=" + Request["pageindex"] + "&tags=" + Request["tags"] + "';</script>", false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//部门或岗位标识
string tag = Request["tags"].ToString();
//部门或岗位ID
string ID = Request["ID"].ToString();
LB_NAME1.Text = tag;
LB_NAME2.Text = tag;
//获取到当前部门或岗位的基本信息
userGroupModel = userGroups.GetModel(ID);
NAME.Text = userGroupModel.NAME;
CONTENT.Text = userGroupModel.CONTENTS;
//设置模板页中的管理值
(Master.FindControl("Label_navigation") as Label).Text = "管理 > 人事管理 ";
//设置模板页中的管理值
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.USER_Groups GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,NAME,CONTENTS,ROLE,DELFLAG,ISMOREN,TAGS from USER_Groups ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 50)
};
parameters[0].Value = ID;
Dianda.Model.USER_Groups model = new Dianda.Model.USER_Groups();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = ds.Tables[0].Rows[0]["ID"].ToString();
model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString();
model.CONTENTS = ds.Tables[0].Rows[0]["CONTENTS"].ToString();
model.ROLE = ds.Tables[0].Rows[0]["ROLE"].ToString();
if (ds.Tables[0].Rows[0]["DELFLAG"].ToString() != "")
{
model.DELFLAG = int.Parse(ds.Tables[0].Rows[0]["DELFLAG"].ToString());
}
if (ds.Tables[0].Rows[0]["ISMOREN"].ToString() != "")
{
model.ISMOREN = int.Parse(ds.Tables[0].Rows[0]["ISMOREN"].ToString());
}
model.TAGS = ds.Tables[0].Rows[0]["TAGS"].ToString();
return(model);
}
else
{
return(null);
}
}
