public ActionResult DeptOperation(HR_Department dict)
{
var flag = false;
//如果Dict_ID 为0，则表示为添加
if (dict.Dept_ID == 0)
{
//Bse_Dict PNode = dictInstance.GetModel(" AND Dict_Code='" + dict.Dict_PCode + "' AND Dict_Key='" + dict.Dict_Key + "'");
//dict.Dict_Code = dictInstance.CreateDictNode(PNode, false, ref order);
flag = deptInstance.AddDept(dict);
// TempDictList = new List<Bse_Dict>();
//添加日志
this.OpLog(dict.Dept_Code, "添加:编码:" + dict.Dept_Name + "数据", flag.ToString());
}
else
{
flag = deptInstance.UpdateDept(dict);
//添加日志
this.OpLog(dict.Dept_Code, "修改:编码:" + dict.Dept_Name + "数据", flag.ToString());
}
if (flag)
{
return(Json(new { result = "success", target = dict }));
}
else
{
return(Json(new { result = "fail" }));
}
//return View();
}
public ActionResult Edit([Bind(Include = "DeptID,DepartmentName,DivsionID,Status")] HR_Department hr_department)
{
if (hr_department.DepartmentName == null || hr_department.DepartmentName == "")
{
ViewBag.error = "Empty Feild";
}
else
{
try
{
if (ModelState.IsValid)
{
db.Entry(hr_department).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Department), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)hr_department.DeptID);
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
throw;
}
}
//ViewBag.DivsionID = new SelectList(db.HR_Division, "DivID", "DivisionName", hr_department.DivsionID);
return(View(hr_department));
}
public static HR_Department GetHR_DepartmentByDepartmentID(int DepartmentID)
{
HR_Department hR_Department = new HR_Department();
SqlHR_DepartmentProvider sqlHR_DepartmentProvider = new SqlHR_DepartmentProvider();
hR_Department = sqlHR_DepartmentProvider.GetHR_DepartmentByDepartmentID(DepartmentID);
return hR_Department;
}
public static void BindingDept2Combo(ComboBox cbo)
{
try
{
HR_DepartmentController _controller = new HR_DepartmentController();
List <HR_Department> _parent = _controller.GetDepartments(-1, -1, 0, string.Empty);
List <HR_Department> _listOrder = new List <HR_Department>();
foreach (HR_Department d in _parent)
{
_listOrder.Add(d);
List <HR_Department> _child = _controller.GetDepartments(-1, d.Id, 1, string.Empty);
foreach (HR_Department dc in _child)
{
dc.Name = "---- " + dc.Name;
_listOrder.Add(dc);
}
}
HR_Department _item = new HR_Department();
_item.Id = -1;
_item.Name = "-- Chọn phòng ban --";
_listOrder.Insert(0, _item);
cbo.DataSource = _listOrder;
cbo.DisplayMember = "Name";
cbo.ValueMember = "Id";
}
catch (Exception ex)
{
SingletonLogger.Instance.Error("BindingCntrol.BindingDept2Combo", ex);
}
}
private void showHR_DepartmentData()
{
HR_Department hR_Department = new HR_Department();
hR_Department = HR_DepartmentManager.GetHR_DepartmentByDepartmentID(Int32.Parse(Request.QueryString["ID"]));
txtDepartmentName.Text = hR_Department.DepartmentName.ToString();
txtJobLocation.Text = hR_Department.JobLocation.ToString();
txtDescription.Text = hR_Department.Description.ToString();
}
public bool AddDept(HR_Department model)
{
if (instance.Add(model) > 0)
{
return(true);
}
return(false);
}
public ActionResult EditNode(HR_Department dep)
{
bool s = deptInstance.UpdateDept(dep);
//日志记录
this.OpLog(this.GetControllerName(), "修改:部门信息,编码:" + dep.Dept_Code, s.ToString());
return(s ? Content(dep.Dept_Code) : Content("false"));
}
public bool UpdateDept(HR_Department model)
{
if (instance.Update(model) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 生成包含层级关系的子节点列表
/// </summary>
/// <returns></returns>
/// <summary>
/// 新增或更新对象
/// </summary>
/// <param name="Mn"></param>
/// <returns></returns>
public bool AddUpdatePlanObject(HR_Department dep)
{
if (dep.Dept_ID.Equals(0))
{
return(instance.Add(dep).Equals(1));
}
else
{
return(instance.Update(dep).Equals(1));
}
}
/// <summary>
/// 获取部门名称
/// </summary>
/// <param name="deptID">部门ID</param>
/// <returns></returns>
public string GetDeptName(int deptID)
{
this.CheckSession();
string ret = "";
HR_Department depRst = new HR_Department();
depRst = this.Select <HR_Department>(HR_Department._.DeptID == deptID && HR_Department._.IsDeleted == false);
if (depRst != null)
{
ret = depRst.DeptName.ToStringHasNull();
}
return(ret);
}
public ActionResult AddNode(HR_Department model)
{
Model.HR_Department hrd = new Model.HR_Department();
//hrd.Dept_PCode = code;
hrd.Dept_Name = "请输入部门名称";
hrd.Dept_Code = deptInstance.GenerateDeptCode();
bool s = deptInstance.AddDept(hrd);
//日志记录
this.OpLog(this.GetControllerName(), "添加:部门信息,编码:" + "", s.ToString());
return(s ? Content(hrd.Dept_Code) : Content("false"));
}
public ActionResult DeleteConfirmed(short id)
{
try
{
HR_Department hr_department = db.HR_Department.Find(id);
db.HR_Department.Remove(hr_department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception)
{
throw;
}
}
private void BindingDept2Combobox()
{
HR_DepartmentController _controller = new HR_DepartmentController();
List <HR_Department> _parent = _controller.GetDepartments(-1, -1, 0, string.Empty);
HR_Department _item = new HR_Department();
_item.Id = -1;
_item.Name = "-- Chọn phòng ban --";
_parent.Insert(0, _item);
cboParentDept.DataSource = _parent;
cboParentDept.DisplayMember = "Name";
cboParentDept.ValueMember = "Id";
}
private void GenerateChild(HR_Department dept, List <HR_Department> allDept)
{
dept.ChildrenDept = allDept.Where(o => o.Dept_PCode == dept.Dept_Code);
if (dept.ChildrenDept.Count() == 0)
{
return;
}
foreach (var d in dept.ChildrenDept)
{
GenerateChild(d, allDept);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
HR_Department hR_Department = new HR_Department();
hR_Department.DepartmentName = txtDepartmentName.Text;
hR_Department.JobLocation = txtJobLocation.Text;
hR_Department.Description = txtDescription.Text;
string userID = Profile.card_id;
hR_Department.AddedBy = userID;
hR_Department.AddedDate = DateTime.Now;
hR_Department.ModifiedBy = userID;
hR_Department.ModifiedDate = DateTime.Now;
int resutl = HR_DepartmentManager.InsertHR_Department(hR_Department);
Response.Redirect("AdminDisplayHR_Department.aspx");
}
/// <summary>
/// 生成节点
/// </summary>
/// <param name="parentCode"></param>
/// <returns></returns>
public ActionResult CreateNode(string parentCode, string itype)
{
if (parentCode.Contains("temp"))
{
parentCode = parentCode.Split('_')[1];
}
HR_Department model = new HR_Department();
model.Dept_PCode = parentCode;
model.Dept_Code = deptInstance.GenerateDeptCode();
return(new JsonResult()
{
Data = new { result = "success", data = model }
});
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_Department hR_Department = new HR_Department();
hR_Department.DepartmentID = int.Parse(Request.QueryString["ID"].ToString());
hR_Department.DepartmentName = txtDepartmentName.Text;
hR_Department.JobLocation = txtJobLocation.Text;
hR_Department.Description = txtDescription.Text;
string userID = Profile.card_id;
hR_Department.AddedBy = userID;
hR_Department.AddedDate = DateTime.Now;
hR_Department.ModifiedBy = userID;
hR_Department.ModifiedDate = DateTime.Now;
bool resutl = HR_DepartmentManager.UpdateHR_Department(hR_Department);
Response.Redirect("AdminDisplayHR_Department.aspx");
}
private void GenerateTree(HR_Department node, List <HR_Department> allData)
{
var list = allData.Where(o => o.Dept_PCode == node.Dept_Code);
// node.children = (from d in list select new TheTreeNode { data = d.Dept_Name, attr = new Attr { id = d.Dept_Code } }).ToList();
if (list.Count() == 0)
{
return;
}
foreach (var d in list)
{
GenerateTree(d, allData);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
HR_DepartmentController _controller = new HR_DepartmentController();
if (!ValidateData())
{
return;
}
if (txtDeptId.Text.Equals(string.Empty))
{
HR_Department _item = new HR_Department();
_item.Name = txtDeptName.Text;
_item.ParentId = Convert.ToInt32(cboParentDept.SelectedValue);
if (cboParentDept.SelectedIndex > 0)
{
_item.Level = 1;
}
//if (cboManager.SelectedIndex > 0)
_item.ManagerId = Convert.ToInt32(cboManager.SelectedValue);
_item.Created = DateTime.Now;
_controller.Add(_item);
}
else
{
HR_Department _item = _controller.GetByID(Convert.ToInt32(txtDeptId.Text));
_item.Name = txtDeptName.Text;
_item.ParentId = Convert.ToInt32(cboParentDept.SelectedValue);
if (cboParentDept.SelectedIndex > 0)
{
_item.Level = 1;
}
else
{
_item.Level = 0;
}
//if (cboManager.SelectedIndex > 0)
_item.ManagerId = Convert.ToInt32(cboManager.SelectedValue);
_controller.Edit(_item);
}
BindingDept();
}
// GET: /HumanResource/Department/Details/5
public ActionResult Details(short?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HR_Department hr_department = db.HR_Department.Find(id);
if (hr_department == null)
{
return(HttpNotFound());
}
return(View(hr_department));
}
catch (Exception)
{
throw;
}
}
//获取节点信息
public ActionResult GetNode(string nodeCode)
{
HR_Department dict = new HR_Department();
if (nodeCode.Contains("temp_"))
{
var newNodeCode = nodeCode.Split('_')[1];
dict = deptInstance.GetModel(string.Format("AND Dept_Code='{0}'", newNodeCode));
}
else
{
dict = deptInstance.GetModel(string.Format("AND Dept_Code='{0}'", nodeCode));
}
var result = new JsonResult()
{
Data = new { result = "success", data = dict }
};
return(result);
}
public ActionResult Create([Bind(Include = "DeptID,DepartmentName,DivsionID")] HR_Department hr_department)
{
try
{
if (ModelState.IsValid)
{
hr_department.Status = true;
db.HR_Department.Add(hr_department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
throw;
}
// ViewBag.DivsionID = new SelectList(db.HR_Division, "DivID", "DivisionName", hr_department.DivsionID);
return(View(hr_department));
}
// GET: /HumanResource/Department/Edit/5
public ActionResult Edit(short?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HR_Department hr_department = db.HR_Department.Find(id);
if (hr_department == null)
{
return(HttpNotFound());
}
// ViewBag.DivsionID = new SelectList(db.HR_Division, "DivID", "DivisionName", hr_department.DivsionID);
return(View(hr_department));
}
catch (Exception)
{
return(View());
}
}
public string GetCompanyName(string deptCode)
{
string deptName = "";
List <HR_Department> list = instance.GetAll();
for (var i = 0; i < list.Count; i++)
{
var _dept = list.Where(o => o.Dept_Code == deptCode)
.FirstOrDefault();
HR_Department dept = new HR_Department();
if (_dept != null && !string.IsNullOrEmpty(_dept.Dept_PCode))
{
deptName = _dept.Dept_Name;
break;
}
else
{
GetCompanyName(list[i].Dept_PCode);
}
}
return(deptName);
}
private void treeViewDepartment_DoubleClick(object sender, EventArgs e)
{
if (treeViewDepartment.Nodes.Count <= 0)
{
return;
}
TreeNode _node = treeViewDepartment.SelectedNode;
if (_node != null)
{
HR_DepartmentController _controller = new HR_DepartmentController();
HR_Department _item = _controller.GetByID(Convert.ToInt32(_node.Name));
if (_item != null)
{
txtDeptId.Text = _node.Name;
txtDeptName.Text = _item.Name;
txtCreated.Text = _item.Created.ToString("dd/MM/yyyy");
if (_item.ParentId > 0)
{
cboParentDept.SelectedValue = _item.ParentId;
}
else
{
cboParentDept.SelectedIndex = 0;
}
if (_item.ManagerId > 0)
{
cboManager.SelectedValue = _item.ManagerId;
}
else
{
cboManager.SelectedIndex = 0;
}
}
}
}
/// <summary>
/// 更新部门信息 HR_Department对象(即:一条记录
/// </summary>
public int Update(HR_Department hR_Department)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE HR_Department SET ");
if (hR_Department.Dept_Code_IsChanged)
{
sbParameter.Append("Dept_Code=@Dept_Code, ");
}
if (hR_Department.Dept_Name_IsChanged)
{
sbParameter.Append("Dept_Name=@Dept_Name, ");
}
if (hR_Department.Dept_Addr_IsChanged)
{
sbParameter.Append("Dept_Addr=@Dept_Addr, ");
}
if (hR_Department.Dept_Tel_IsChanged)
{
sbParameter.Append("Dept_Tel=@Dept_Tel, ");
}
if (hR_Department.Dept_Manager_IsChanged)
{
sbParameter.Append("Dept_Manager=@Dept_Manager, ");
}
if (hR_Department.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (hR_Department.CreateTime_IsChanged)
{
sbParameter.Append("CreateTime=@CreateTime, ");
}
if (hR_Department.Creator_IsChanged)
{
sbParameter.Append("Creator=@Creator, ");
}
if (hR_Department.Dept_PCode_IsChanged)
{
sbParameter.Append("Dept_PCode=@Dept_PCode, ");
}
if (hR_Department.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (hR_Department.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (hR_Department.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate, ");
}
if (hR_Department.Dept_Udef1_IsChanged)
{
sbParameter.Append("Dept_Udef1=@Dept_Udef1, ");
}
if (hR_Department.Dept_Udef2_IsChanged)
{
sbParameter.Append("Dept_Udef2=@Dept_Udef2, ");
}
if (hR_Department.Dept_Udef3_IsChanged)
{
sbParameter.Append("Dept_Udef3=@Dept_Udef3, ");
}
if (hR_Department.Dept_Udef5_IsChanged)
{
sbParameter.Append("Dept_Udef5=@Dept_Udef5, ");
}
if (hR_Department.Dept_Udef6_IsChanged)
{
sbParameter.Append("Dept_Udef6=@Dept_Udef6, ");
}
if (hR_Department.Dept_Udef7_IsChanged)
{
sbParameter.Append("Dept_Udef7=@Dept_Udef7, ");
}
if (hR_Department.Dept_Udef8_IsChanged)
{
sbParameter.Append("Dept_Udef8=@Dept_Udef8, ");
}
if (hR_Department.Dept_Udef9_IsChanged)
{
sbParameter.Append("Dept_Udef9=@Dept_Udef9, ");
}
if (hR_Department.Dept_Udef10_IsChanged)
{
sbParameter.Append("Dept_Udef10=@Dept_Udef10 ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Dept_ID=@Dept_ID; ");
string sql = sb.ToString();
if (hR_Department.Dept_Code_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Code))
{
idb.AddParameter("@Dept_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Code", hR_Department.Dept_Code);
}
}
if (hR_Department.Dept_Name_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Name))
{
idb.AddParameter("@Dept_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Name", hR_Department.Dept_Name);
}
}
if (hR_Department.Dept_Addr_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Addr))
{
idb.AddParameter("@Dept_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Addr", hR_Department.Dept_Addr);
}
}
if (hR_Department.Dept_Tel_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Tel))
{
idb.AddParameter("@Dept_Tel", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Tel", hR_Department.Dept_Tel);
}
}
if (hR_Department.Dept_Manager_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Manager))
{
idb.AddParameter("@Dept_Manager", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Manager", hR_Department.Dept_Manager);
}
}
if (hR_Department.Stat_IsChanged)
{
if (hR_Department.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", hR_Department.Stat);
}
}
if (hR_Department.CreateTime_IsChanged)
{
if (hR_Department.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", hR_Department.CreateTime);
}
}
if (hR_Department.Creator_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Creator))
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", hR_Department.Creator);
}
}
if (hR_Department.Dept_PCode_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_PCode))
{
idb.AddParameter("@Dept_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_PCode", hR_Department.Dept_PCode);
}
}
if (hR_Department.CreateDate_IsChanged)
{
if (hR_Department.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", hR_Department.CreateDate);
}
}
if (hR_Department.UpdateDate_IsChanged)
{
if (hR_Department.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", hR_Department.UpdateDate);
}
}
if (hR_Department.DeleteDate_IsChanged)
{
if (hR_Department.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", hR_Department.DeleteDate);
}
}
if (hR_Department.Dept_Udef1_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef1))
{
idb.AddParameter("@Dept_Udef1", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef1", hR_Department.Dept_Udef1);
}
}
if (hR_Department.Dept_Udef2_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef2))
{
idb.AddParameter("@Dept_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef2", hR_Department.Dept_Udef2);
}
}
if (hR_Department.Dept_Udef3_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef3))
{
idb.AddParameter("@Dept_Udef3", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef3", hR_Department.Dept_Udef3);
}
}
if (hR_Department.Dept_Udef5_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef5))
{
idb.AddParameter("@Dept_Udef5", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef5", hR_Department.Dept_Udef5);
}
}
if (hR_Department.Dept_Udef6_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef6))
{
idb.AddParameter("@Dept_Udef6", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef6", hR_Department.Dept_Udef6);
}
}
if (hR_Department.Dept_Udef7_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef7))
{
idb.AddParameter("@Dept_Udef7", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef7", hR_Department.Dept_Udef7);
}
}
if (hR_Department.Dept_Udef8_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef8))
{
idb.AddParameter("@Dept_Udef8", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef8", hR_Department.Dept_Udef8);
}
}
if (hR_Department.Dept_Udef9_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef9))
{
idb.AddParameter("@Dept_Udef9", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef9", hR_Department.Dept_Udef9);
}
}
if (hR_Department.Dept_Udef10_IsChanged)
{
if (string.IsNullOrEmpty(hR_Department.Dept_Udef10))
{
idb.AddParameter("@Dept_Udef10", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef10", hR_Department.Dept_Udef10);
}
}
idb.AddParameter("@Dept_ID", hR_Department.Dept_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
/// <summary>
/// 添加部门信息 HR_Department对象(即:一条记录)
/// </summary>
public object AddWithReturn(HR_Department hR_Department)
{
string sql = "INSERT INTO HR_Department (Dept_Code,Dept_Name,Dept_Addr,Dept_Tel,Dept_Manager,Stat,CreateTime,Creator,Dept_PCode,CreateDate,UpdateDate,DeleteDate,Dept_Udef1,Dept_Udef2,Dept_Udef3,Dept_Udef5,Dept_Udef6,Dept_Udef7,Dept_Udef8,Dept_Udef9,Dept_Udef10) VALUES (@Dept_Code,@Dept_Name,@Dept_Addr,@Dept_Tel,@Dept_Manager,@Stat,@CreateTime,@Creator,@Dept_PCode,@CreateDate,@UpdateDate,@DeleteDate,@Dept_Udef1,@Dept_Udef2,@Dept_Udef3,@Dept_Udef5,@Dept_Udef6,@Dept_Udef7,@Dept_Udef8,@Dept_Udef9,@Dept_Udef10);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(hR_Department.Dept_Code))
{
idb.AddParameter("@Dept_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Code", hR_Department.Dept_Code);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Name))
{
idb.AddParameter("@Dept_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Name", hR_Department.Dept_Name);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Addr))
{
idb.AddParameter("@Dept_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Addr", hR_Department.Dept_Addr);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Tel))
{
idb.AddParameter("@Dept_Tel", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Tel", hR_Department.Dept_Tel);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Manager))
{
idb.AddParameter("@Dept_Manager", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Manager", hR_Department.Dept_Manager);
}
if (hR_Department.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", hR_Department.Stat);
}
if (hR_Department.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", hR_Department.CreateTime);
}
if (string.IsNullOrEmpty(hR_Department.Creator))
{
idb.AddParameter("@Creator", DBNull.Value);
}
else
{
idb.AddParameter("@Creator", hR_Department.Creator);
}
if (string.IsNullOrEmpty(hR_Department.Dept_PCode))
{
idb.AddParameter("@Dept_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_PCode", hR_Department.Dept_PCode);
}
if (hR_Department.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", hR_Department.CreateDate);
}
if (hR_Department.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", hR_Department.UpdateDate);
}
if (hR_Department.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", hR_Department.DeleteDate);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef1))
{
idb.AddParameter("@Dept_Udef1", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef1", hR_Department.Dept_Udef1);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef2))
{
idb.AddParameter("@Dept_Udef2", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef2", hR_Department.Dept_Udef2);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef3))
{
idb.AddParameter("@Dept_Udef3", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef3", hR_Department.Dept_Udef3);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef5))
{
idb.AddParameter("@Dept_Udef5", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef5", hR_Department.Dept_Udef5);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef6))
{
idb.AddParameter("@Dept_Udef6", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef6", hR_Department.Dept_Udef6);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef7))
{
idb.AddParameter("@Dept_Udef7", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef7", hR_Department.Dept_Udef7);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef8))
{
idb.AddParameter("@Dept_Udef8", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef8", hR_Department.Dept_Udef8);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef9))
{
idb.AddParameter("@Dept_Udef9", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef9", hR_Department.Dept_Udef9);
}
if (string.IsNullOrEmpty(hR_Department.Dept_Udef10))
{
idb.AddParameter("@Dept_Udef10", DBNull.Value);
}
else
{
idb.AddParameter("@Dept_Udef10", hR_Department.Dept_Udef10);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name, Ex);
return(Re);
}
public static bool UpdateHR_Department(HR_Department hR_Department)
{
SqlHR_DepartmentProvider sqlHR_DepartmentProvider = new SqlHR_DepartmentProvider();
return sqlHR_DepartmentProvider.UpdateHR_Department(hR_Department);
}
/// <summary>
/// 添加和新增修改
/// </summary>
/// <param name="param">新增或修改的实体</param>
/// <returns></returns>
public WCFAddUpdateResult AddOrUpdate(HR_DepartmentResult param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
try
{
int affect = 0;
#region 判断
if (param.DeptID == 0)
{
param.OrgGuID = param.DeptOrgGuID; param.OrgID = param.DeptOrgID;
}
if (param.OrgGuID == Guid.Empty)
{
throw new WarnException("没有所属部门GUID！");
}
if (param.OrgID == 0)
{
throw new WarnException("没有所属机构的ID！");
}
if (param.DeptName.Trim() == "")
{
throw new WarnException("请输入部门名称！");
}
#endregion
if (param.DeptID != 0)
{
WhereClip where = HR_Department._.DeptID == param.DeptID;
affect = this.Update <HR_DepartmentResult>(param, where);
}
else
{
#region 获取最大编号数字
int maxDeptNum = 0;
maxDeptNum = this.Count <HR_DepartmentResult>(HR_Department._.ParentID == param.ParentID && HR_Department._.OrgGuID == param.OrgGuID) + 1;
#endregion
#region 获取父级部门的编号
string parentDeptNo = string.Empty;
HR_Department parentDepartment = this.Select <HR_Department>(HR_Department._.DeptID == param.ParentID && HR_Department._.OrgGuID == param.OrgGuID);
if (parentDepartment != null)
{
parentDeptNo = parentDepartment.DeptNo;
}
#endregion
#region 系统默认值
param.DeptNo = parentDeptNo + maxDeptNum.ToString().PadLeft(3, '0');
param.GCompanyID = this.SessionInfo.CompanyID;
param.IsActive = 2;
affect = this.Insert <HR_DepartmentResult>(param);
param = this.Select <HR_DepartmentResult>(new List <Field> {
HR_Department._.DeptID
}, HR_Department._.DeptNo == param.DeptNo);
}
#region 设置返回值
ret.Key = param.DeptID;
ret.KeyGuid = param.OrgGuID;
#endregion
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public static int InsertHR_Department(HR_Department hR_Department)
{
SqlHR_DepartmentProvider sqlHR_DepartmentProvider = new SqlHR_DepartmentProvider();
return sqlHR_DepartmentProvider.InsertHR_Department(hR_Department);
}
public bool UpdateHR_Department(HR_Department hR_Department)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_Department", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = hR_Department.DepartmentID;
cmd.Parameters.Add("@DepartmentName", SqlDbType.NVarChar).Value = hR_Department.DepartmentName;
cmd.Parameters.Add("@JobLocation", SqlDbType.NVarChar).Value = hR_Department.JobLocation;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = hR_Department.Description;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_Department.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_Department.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_Department GetHR_DepartmentFromReader(IDataReader reader)
{
try
{
HR_Department hR_Department = new HR_Department
(
DataAccessObject.IsNULL<int>(reader["DepartmentID"]),
DataAccessObject.IsNULL<string>(reader["DepartmentName"]),
DataAccessObject.IsNULL<string>(reader["JobLocation"]),
DataAccessObject.IsNULL<string>(reader["Description"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_Department;
}
catch(Exception ex)
{
return null;
}
}
/// <summary>
/// 获取指定的部门信息 HR_Department对象集合
/// </summary>
public List <HR_Department> GetListByWhere(string strCondition)
{
List <HR_Department> ret = new List <HR_Department>();
string sql = "SELECT Dept_ID,Dept_Code,Dept_Name,Dept_Addr,Dept_Tel,Dept_Manager,Stat,CreateTime,Creator,Dept_PCode,CreateDate,UpdateDate,DeleteDate,Dept_Udef1,Dept_Udef2,Dept_Udef3,Dept_Udef5,Dept_Udef6,Dept_Udef7,Dept_Udef8,Dept_Udef9,Dept_Udef10 FROM HR_Department WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
HR_Department hR_Department = new HR_Department();
if (dr["Dept_ID"] != DBNull.Value)
{
hR_Department.Dept_ID = Convert.ToDecimal(dr["Dept_ID"]);
}
if (dr["Dept_Code"] != DBNull.Value)
{
hR_Department.Dept_Code = Convert.ToString(dr["Dept_Code"]);
}
if (dr["Dept_Name"] != DBNull.Value)
{
hR_Department.Dept_Name = Convert.ToString(dr["Dept_Name"]);
}
if (dr["Dept_Addr"] != DBNull.Value)
{
hR_Department.Dept_Addr = Convert.ToString(dr["Dept_Addr"]);
}
if (dr["Dept_Tel"] != DBNull.Value)
{
hR_Department.Dept_Tel = Convert.ToString(dr["Dept_Tel"]);
}
if (dr["Dept_Manager"] != DBNull.Value)
{
hR_Department.Dept_Manager = Convert.ToString(dr["Dept_Manager"]);
}
if (dr["Stat"] != DBNull.Value)
{
hR_Department.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
hR_Department.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["Creator"] != DBNull.Value)
{
hR_Department.Creator = Convert.ToString(dr["Creator"]);
}
if (dr["Dept_PCode"] != DBNull.Value)
{
hR_Department.Dept_PCode = Convert.ToString(dr["Dept_PCode"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
hR_Department.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["UpdateDate"] != DBNull.Value)
{
hR_Department.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
}
if (dr["DeleteDate"] != DBNull.Value)
{
hR_Department.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
}
if (dr["Dept_Udef1"] != DBNull.Value)
{
hR_Department.Dept_Udef1 = Convert.ToString(dr["Dept_Udef1"]);
}
if (dr["Dept_Udef2"] != DBNull.Value)
{
hR_Department.Dept_Udef2 = Convert.ToString(dr["Dept_Udef2"]);
}
if (dr["Dept_Udef3"] != DBNull.Value)
{
hR_Department.Dept_Udef3 = Convert.ToString(dr["Dept_Udef3"]);
}
if (dr["Dept_Udef5"] != DBNull.Value)
{
hR_Department.Dept_Udef5 = Convert.ToString(dr["Dept_Udef5"]);
}
if (dr["Dept_Udef6"] != DBNull.Value)
{
hR_Department.Dept_Udef6 = Convert.ToString(dr["Dept_Udef6"]);
}
if (dr["Dept_Udef7"] != DBNull.Value)
{
hR_Department.Dept_Udef7 = Convert.ToString(dr["Dept_Udef7"]);
}
if (dr["Dept_Udef8"] != DBNull.Value)
{
hR_Department.Dept_Udef8 = Convert.ToString(dr["Dept_Udef8"]);
}
if (dr["Dept_Udef9"] != DBNull.Value)
{
hR_Department.Dept_Udef9 = Convert.ToString(dr["Dept_Udef9"]);
}
if (dr["Dept_Udef10"] != DBNull.Value)
{
hR_Department.Dept_Udef10 = Convert.ToString(dr["Dept_Udef10"]);
}
ret.Add(hR_Department);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
//登陆
public ActionResult LoginBtn()
{
//TODO:corporation
string result = "fail";
string msg = string.Empty;
string company = Request["company"];
string userName = Request["userName"];
string userPwd = Request["pwd"];
//string userRole = Request["role"];
//string result = "";
if (!Net.CheckConn())
{
return(Json(new { result = result, msg = "无法连接到服务器！请检查网络情况。" }));
}
try
{
if (userName == null || userPwd == null)
{
result = "fail";
msg = "用户名或密码不能为空";
//return Content("Null");
}
else
{
//TODO:1.4
//得到公司
string pwd = Md5.MD5(userPwd);
//角色Stuff_LoginType and Stuff_LoginType='" + userRole + "'
//HR_Stuff = instanceHR_Stuff.GetModel(string.Format(" and Stuff_UserName='******' and Stuff_Password='******'",userName,pwd));
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("Stuff_UserName", userName);
dic.Add("Stuff_Password", pwd);
HR_Stuff = instanceHR_Stuff.GetModel(string.Format("AND Stuff_UserName=@Stuff_UserName AND Stuff_Password=@Stuff_Password"), dic);
if (HR_Stuff == null)
{
result = "fail";
msg = "用户名或密码不正确 ";
}
else
{
//用户名
this.SetSession <string>("UserName", HR_Stuff.Stuff_Name);
//员工编码
this.SetSession <string>("UserId", HR_Stuff.Stuff_Code);
//员工登录名
this.SetSession <string>("LoginName", HR_Stuff.Stuff_UserName);
//登录IP
this.SetSession <string>("IP", HttpContext.Request.UserHostAddress);
//部门信息
HR_Department = instanceHR_Department.GetModel(" and Dept_Code='" + HR_Stuff.Stuff_DepCode + "'");
if (HR_Department != null)
{
//部门id
this.SetSession <string>("DeptId", HR_Department.Dept_Code.ToString());
//部门名称
this.SetSession <string>("DeptName", HR_Department.Dept_Name);
//用户角色
this.SetSession <string>("UserRole", HR_Stuff.Stuff_LoginType);
//DODO：hao
HR_Department fagTemp = instanceHR_Department.GetModel(" and Dept_Code='" + HR_Department.Dept_PCode.ToString() + "'");
while (!string.IsNullOrEmpty(fagTemp.Dept_PCode))
{
fagTemp = instanceHR_Department.GetModel(" and Dept_Code='" + fagTemp.Dept_PCode + "'");
}
string companyUser = fagTemp.Dept_Name.ToString();
//公司编码
string companyCode = fagTemp.Dept_Code.ToString();
//this.SetSession<string>("Company", company);
this.SetSession <string>("CompanyCode", companyCode);
//部门编码
this.SetSession <string>("DeptCode", HR_Department.Dept_Code);
//TODO:得到公司问题
//companyCode=new BLL.Bll_HR_Department().GetCompanyName("" + HR_Department.Dept_Code + "");
this.SetSession <string>("Company", companyUser);
result = "success";
msg = "";
}
else
{
result = "fail";
msg = "用户信息配置错误";
}
}
}
}
catch (System.Exception ex)
{
result = "fail";
msg = "网络连接不通，请重试";
//CommLog.Error(ex.Message);
//PlateLog.Write("连接异常:", PlateLog.LogMessageType.Error,ex);
}
//写入登录日志
//Bll_Comm.LoginLog(userName,msg);
return(Json(new { result = result, msg = msg }));
}
/// <summary>
/// 获取指定的部门信息 HR_Department对象(即:一条记录
/// </summary>
public HR_Department GetByKey(decimal dept_ID)
{
HR_Department hR_Department = new HR_Department();
string sql = "SELECT Dept_ID,Dept_Code,Dept_Name,Dept_Addr,Dept_Tel,Dept_Manager,Stat,CreateTime,Creator,Dept_PCode,CreateDate,UpdateDate,DeleteDate,Dept_Udef1,Dept_Udef2,Dept_Udef3,Dept_Udef5,Dept_Udef6,Dept_Udef7,Dept_Udef8,Dept_Udef9,Dept_Udef10 FROM HR_Department WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Dept_ID=@Dept_ID ";
idb.AddParameter("@Dept_ID", dept_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["Dept_ID"] != DBNull.Value)
{
hR_Department.Dept_ID = Convert.ToDecimal(dr["Dept_ID"]);
}
if (dr["Dept_Code"] != DBNull.Value)
{
hR_Department.Dept_Code = Convert.ToString(dr["Dept_Code"]);
}
if (dr["Dept_Name"] != DBNull.Value)
{
hR_Department.Dept_Name = Convert.ToString(dr["Dept_Name"]);
}
if (dr["Dept_Addr"] != DBNull.Value)
{
hR_Department.Dept_Addr = Convert.ToString(dr["Dept_Addr"]);
}
if (dr["Dept_Tel"] != DBNull.Value)
{
hR_Department.Dept_Tel = Convert.ToString(dr["Dept_Tel"]);
}
if (dr["Dept_Manager"] != DBNull.Value)
{
hR_Department.Dept_Manager = Convert.ToString(dr["Dept_Manager"]);
}
if (dr["Stat"] != DBNull.Value)
{
hR_Department.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
hR_Department.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["Creator"] != DBNull.Value)
{
hR_Department.Creator = Convert.ToString(dr["Creator"]);
}
if (dr["Dept_PCode"] != DBNull.Value)
{
hR_Department.Dept_PCode = Convert.ToString(dr["Dept_PCode"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
hR_Department.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["UpdateDate"] != DBNull.Value)
{
hR_Department.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
}
if (dr["DeleteDate"] != DBNull.Value)
{
hR_Department.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
}
if (dr["Dept_Udef1"] != DBNull.Value)
{
hR_Department.Dept_Udef1 = Convert.ToString(dr["Dept_Udef1"]);
}
if (dr["Dept_Udef2"] != DBNull.Value)
{
hR_Department.Dept_Udef2 = Convert.ToString(dr["Dept_Udef2"]);
}
if (dr["Dept_Udef3"] != DBNull.Value)
{
hR_Department.Dept_Udef3 = Convert.ToString(dr["Dept_Udef3"]);
}
if (dr["Dept_Udef5"] != DBNull.Value)
{
hR_Department.Dept_Udef5 = Convert.ToString(dr["Dept_Udef5"]);
}
if (dr["Dept_Udef6"] != DBNull.Value)
{
hR_Department.Dept_Udef6 = Convert.ToString(dr["Dept_Udef6"]);
}
if (dr["Dept_Udef7"] != DBNull.Value)
{
hR_Department.Dept_Udef7 = Convert.ToString(dr["Dept_Udef7"]);
}
if (dr["Dept_Udef8"] != DBNull.Value)
{
hR_Department.Dept_Udef8 = Convert.ToString(dr["Dept_Udef8"]);
}
if (dr["Dept_Udef9"] != DBNull.Value)
{
hR_Department.Dept_Udef9 = Convert.ToString(dr["Dept_Udef9"]);
}
if (dr["Dept_Udef10"] != DBNull.Value)
{
hR_Department.Dept_Udef10 = Convert.ToString(dr["Dept_Udef10"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(hR_Department);
}
