/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.dept model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gm_dt_dept set ");
strSql.Append("dept_name=@dept_name,");
strSql.Append("add_time=@add_time");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@dept_name", SqlDbType.NVarChar, 50),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.dept_name;
parameters[1].Value = model.add_time;
parameters[2].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.dept model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gm_dt_dept(");
strSql.Append("dept_name,add_time)");
strSql.Append(" values (");
strSql.Append("@dept_name,@add_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@dept_name", SqlDbType.NVarChar, 50),
new SqlParameter("@add_time", SqlDbType.DateTime)
};
parameters[0].Value = model.dept_name;
parameters[1].Value = model.add_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindMenuTree();
}
if (RequsetAjax("edit"))
{
int deptId = int.Parse(Request.Form["deptId"].ToString());
Model.dept model = bll.GetModel(deptId);
Response.Write("{\"status\":1,\"msg\":\"修改成功！\",\"deptId\":\"" + model.deptId + "\",\"deptName\":\"" + model.deptName + "\",\"parentId\":\"" + model.parentId + "\"}");
Response.End();
}
if (RequsetAjax("editsubmit"))
{
//编辑
int deptId = int.Parse(Request.Form["deptId"].ToString());
string deptName = Request.Form["deptName"].ToString();
string parentId = Request.Form["parentId"].ToString();
Model.dept model = bll.GetModel(deptId);
model.parentId = int.Parse(parentId);
model.deptName = deptName;
bll.Update(model);
Response.Write("{\"status\":1,\"msg\":\"修改成功！\"}");
Response.End();
}
if (RequsetAjax("add"))
{
//添加
string deptName = Request.Form["deptName"].ToString();
string parentId = Request.Form["parentId"].ToString();
Model.dept model = new Model.dept();
model.parentId = int.Parse(parentId);
model.deptName = deptName;
model.userId = 0;
model.manager = "";
bll.Add(model);
Response.Write("{\"status\":1,\"msg\":\"添加成功！\"}");
Response.End();
}
if (RequsetAjax("del"))
{
//删除
int deptId = int.Parse(Request.Form["deptId"].ToString());
bll.Delete(deptId);
Response.Write("{\"status\":1,\"msg\":\"添加成功！\"}");
Response.End();
}
}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
TreeNode t = this.TreeView1.SelectedNode;
int deptId = int.Parse(t.Value);
Model.dept model = bll.GetModel(deptId);
bindDeptList();
lblpId.Text = model.deptId.ToString();
ddrParent.SelectedValue = model.parentId.ToString();
txtDeptName.Text = model.deptName;
}
private bool DoEdit(int _id)
{
bool result = true;
BLL.dept bll = new BLL.dept();
Model.dept model = bll.GetModel(_id);
model.dept_name = txtDeptName.Text.Trim();
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private bool DoAdd()
{
bool result = true;
Model.dept model = new Model.dept();
BLL.dept bll = new BLL.dept();
model.dept_name = txtDeptName.Text.Trim();
model.add_time = DateTime.Now;
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.dept model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.dept model)
{
return(dal.Add(model));
}
private void ShowInfo(int _id)
{
BLL.dept bll = new BLL.dept();
Model.dept model = bll.GetModel(_id);
txtDeptName.Text = model.dept_name;
}
