/// <summary>
/// 增加一条数据
/// 2012-06-07修改，增加返回值
/// </summary>
public int Add(Entity.BASE_DEPT entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_DEPT(");
strSql.Append("DEPTID,DPTNAME,DPTINFO,PARENTID,STATUS");
strSql.Append(") values (");
strSql.Append(":DEPTID,:DPTNAME,:DPTINFO,:PARENTID,:STATUS");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":DPTNAME", OracleType.VarChar, 50),
new OracleParameter(":DPTINFO", OracleType.VarChar, 50),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":STATUS", OracleType.Number, 4)
};
parameters[0].Value = entity.DEPTID;
parameters[1].Value = entity.DPTNAME;
parameters[2].Value = entity.DPTINFO;
parameters[3].Value = entity.PARENTID;
parameters[4].Value = entity.STATUS;
return(OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_DEPT entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_DEPT set ");
strSql.Append(" DEPTID = :DEPTID , ");
strSql.Append(" DPTNAME = :DPTNAME , ");
strSql.Append(" DPTINFO = :DPTINFO , ");
strSql.Append(" STATUS = :STATUS ");
strSql.Append(" where DEPTID=:DEPTID ");
OracleParameter[] parameters =
{
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":DPTNAME", OracleType.VarChar, 50),
new OracleParameter(":DPTINFO", OracleType.VarChar, 50),
new OracleParameter(":STATUS", OracleType.Number, 4)
};
parameters[0].Value = entity.DEPTID;
parameters[1].Value = entity.DPTNAME;
parameters[2].Value = entity.DPTINFO;
parameters[3].Value = entity.STATUS;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 设置部门数据
/// </summary>
/// <param name="model">部门实体</param>
private void SetEntity(Entity.BASE_DEPT model)
{
this.hidPrimary.Value = model.DEPTID.ToString(); //id,主键
this.depname.Text = model.DPTNAME; //部门名称
this.txtDptinfo.Text = model.DPTINFO; //部门描述
//DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment");//找到用户控件中的子控件
//ddr.SelectedValue = model.PARENTID.ToString(); //上级部门
// model.STATES; //状态
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ViewState["strAction"].ToString() == "add")//添加部门信息
{
//获取实体
Entity.BASE_DEPT model = GetEntity(Convert.ToDecimal(ViewState["parentId"].ToString()));
//添加数据
int flag = bll.Add(model);
//日志..............添加
Entity.BASE_LOG logmodel = new Entity.BASE_LOG();
logmodel.LOGID = -1; //id,主键
logmodel.LOGTYPE = "部门管理"; //日志类型
logmodel.CREATEDATE = DateTime.Now; //日志创建时间
logmodel.DESCRIPTION = "新建部门"; //日志信息内容
logmodel.OPERATORID = 17; //操作人编号
logmodel.IPADDRESS = Smart.Utility.IpAddress.GetLocationIpAddress(); //ip地址
logbll.Add(logmodel);
if (flag > 0)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('操作成功');window.close();", true);
}
else
{
AjaxAlert(UpdatePanel1, "操作失败，请检查数据录入是否规范！");
}
}
else //修改部门信息
{
//获取实体
Entity.BASE_DEPT model = GetEntity(0);//编辑时对上级编号不做修改
bool flag = bll.update(model);
//日志..............修改
Entity.BASE_LOG logmodel = new Entity.BASE_LOG();
logmodel.LOGID = -1; //id,主键
logmodel.LOGTYPE = "部门管理"; //日志类型
logmodel.CREATEDATE = DateTime.Now; //日志创建时间
logmodel.DESCRIPTION = "编辑部门"; //日志信息内容
logmodel.OPERATORID = 17; //操作人编号
logmodel.IPADDRESS = Smart.Utility.IpAddress.GetLocationIpAddress(); //ip地址
logbll.Add(logmodel);
if (flag)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('操作成功');window.close();", true);
}
else
{
AjaxAlert(UpdatePanel1, "操作失败，请检查数据录入是否规范！");
}
}
}
/// <summary>
/// 获得部门数据实体
/// </summary>
/// <returns></returns>
private Entity.BASE_DEPT GetEntity(decimal parentId)
{
Entity.BASE_DEPT model = new Entity.BASE_DEPT();
model.DEPTID = Convert.ToInt32(this.hidPrimary.Value); //id,主键
model.DPTNAME = this.depname.Text.Trim(); //部门名称
model.DPTINFO = this.txtDptinfo.Text.Trim(); //部门描述
model.PARENTID = parentId; //上级部门
model.STATUS = 0; //状态0:正常；1：关闭
return(model);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_DEPT model)
{
if (dal.Update(model))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_DEPT GetEntity(decimal DEPTID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DEPTID, DPTNAME, DPTINFO, PARENTID, STATUS ");
strSql.Append(" from BASE_DEPT ");
strSql.Append(" where DEPTID=:DEPTID ");
OracleParameter[] parameters =
{
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[0].Value = DEPTID;
Entity.BASE_DEPT entity = new Entity.BASE_DEPT();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
entity.DPTNAME = dt.Rows[0]["DPTNAME"].ToString();
entity.DPTINFO = dt.Rows[0]["DPTINFO"].ToString();
if (dt.Rows[0]["PARENTID"].ToString() != "")
{
entity.PARENTID = decimal.Parse(dt.Rows[0]["PARENTID"].ToString());
}
if (dt.Rows[0]["STATUS"].ToString() != "")
{
entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
protected void BtnDeptAdd_Click(object sender, EventArgs e)
{
decimal deptid = 0;
if (null == Request.QueryString["deptid"] || "" == Request.QueryString["deptid"])
{
deptid = 4;
}
else
{
deptid = Convert.ToDecimal(Request.QueryString["deptid"]);
}
//获取实体
Entity.BASE_DEPT model = GetEntity(deptid);
//添加数据
bll.Add(model);
//重新加载当前页
Response.Redirect(Request.Url.AbsoluteUri, true);
}
public int _OPTFLAG = 0;//表新增单位信息
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strAction = Request.QueryString["action"].ToString();
ViewState["strAction"] = strAction;
if (strAction == "update")
{
string strUnitId = Request.QueryString["unitid"].ToString();
ViewState["strUnitId"] = strUnitId;
hidPrimary.Value = strUnitId;
decimal DEPTID = Convert.ToDecimal(Request.QueryString["unitid"]);
Entity.BASE_DEPT model = bll.GetEntity(DEPTID);
SetEntity(model);
}
else if (strAction == "add")
{
string parentId = Request.QueryString["parentId"].ToString();
ViewState["parentId"] = parentId;
}
}
}
/// <summary>
/// 设置部门数据
/// </summary>
/// <param name="model">部门实体</param>
private void SetEntity(Entity.BASE_DEPT model)
{
this.TxtDeptName.Text = model.DPTNAME; //部门名称
this.txtDptinfo.Text = model.DPTINFO; //部门描述
}
/// <summary>
/// 绑定用户信息
/// </summary>
/// <param name="userId">用户ID</param>
private void BindingUserInfo(int userId)
{
BLL.BASE_USER_ROLE userRoleBLL = new BLL.BASE_USER_ROLE();
var dt = userRoleBLL.GetList(userId); //获取用户权限集合
#region 绑定用户基本信息
BLL.BASE_USER userBLL = new BLL.BASE_USER();
Entity.BASE_USER userModel = new Entity.BASE_USER();
userModel = userBLL.GetUser(userId);
this.BIRTHDAY = userModel.BIRTHDAY;
this.DEGREE = userModel.DEGREE;
this.DEPTID = userModel.DEPTID;
this.FACE = userModel.FACE;
this.IDNUMBER = userModel.IDNUMBER;
this.JOBNUMBER = userModel.JOBNUMBER;
this.PARENTID = userModel.PARENTID;
this.PHONE = userModel.PHONE;
this.PHOTO = userModel.PHONE;
this.PROF = userModel.PROF;
this.REMARK = userModel.REMARK;
this.SEX = userModel.SEX;
this.STSTUS = userModel.STSTUS;
this.USERID = userModel.USERID;
this.USERNAME = userModel.USERNAME;
this.USERPWD = userModel.USERPWD;
#endregion
//绑定部门
BLL.BASE_DEPT deptBLL = new BLL.BASE_DEPT();
_Department = deptBLL.GetEntity(userModel.DEPTID);
/*
#region 绑定角色信息
* var roles = userRoleBLL.Query(
* string.Format("SELECT distinct ROLEID FROM base_user_role WHERE userid = {0}",
* userId.ToString()));
* BLL.BASE_ROLE roleBll = new BLL.BASE_ROLE();
* foreach (DataRow dr in roles.Rows) {
* Entity.BASE_ROLE roleModel = new Entity.BASE_ROLE();
* roleModel = roleBll.GetEntity(Convert.ToInt32(dr["ROLEID"]));
*
* Utility.UserRole role = new UserRole();
* role.ROLEID = roleModel.ROLEID;
* role.ROLEINFO = roleModel.ROLEINFO;
* role.ROLENAME = roleModel.ROLENAME;
*
#region 绑定菜单
* var menus = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1}",
* userId.ToString(),
* roleModel.ROLEID.ToString()));
* BLL.BASE_MENU bllMenu = new BLL.BASE_MENU();
* foreach (DataRow menuDr in menus.Rows) {
* Entity.BASE_MENU menuModel = new Entity.BASE_MENU();
* menuModel = bllMenu.GetEntity(Convert.ToInt32(menuDr["MENUID"]));
*
* Utility.UserMenu menu = new UserMenu();
* menu.ICON = menuModel.ICON;
* menu.MENUID = menuModel.MENUID;
* menu.MENUINFO = menuModel.MENUINFO;
* menu.MENUNAME = menuModel.MENUNAME;
* menu.MENUURL = menuModel.MENUURL;
* menu.PARENTID = menuModel.PARENTID;
* menu.STATUS = menuModel.STATUS;
*
#region 绑定菜单的Action
* var actions = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1} AND MENUID={2}",
* userId.ToString(),
* roleModel.ROLEID.ToString(),
* menu.MENUID.ToString()));
* BLL.BASE_ACTION actionBLL = new BLL.BASE_ACTION();
* foreach (DataRow actionDr in actions.Rows) {
* Entity.BASE_ACTION actionModel = new Entity.BASE_ACTION();
* actionModel = actionBLL.GetEntity(Convert.ToInt32(actionDr["ACTIONID"].ToString()));
*
* menu.UserAction.Add(actionModel); //动作信息加载菜单中
* }
#endregion
*
* role.UserMenu.Add(menu); //菜单加入角色组中
* }
#endregion
*
* UserRole.Add(role); //角色组加入集合中
* }
#endregion
*/
}
/// <summary>
/// 新建部门
/// </summary>
/// <param name="model">部门实体</param>
public int Add(Entity.BASE_DEPT model)
{
return(dal.Add(model));
}
