public ActionResult PostEdit(int id = 0, int parentId = 0)
{
string childs = "";
Sys_Post model = AllPosts.Find(p => p.PostId == id);
if (model == null)
{
model = new Sys_Post {
PostId = id, ParentId = parentId, PostCode = "", PostName = "", Remark = ""
}
}
;
else
{
var list = new List <int>();
GetChildPostIds(model.PostId, list);
childs = list.Aggregate("", (current, postId) => current + (postId + ","));
}
if (model.ParentId == 0)
{
model.parentPostName = CommonLanguage.ParentPost;
}
else
{
model.parentPostName = AllPosts.Find(p => p.PostId == model.ParentId).PostNameShow;
}
ViewBag.model = model;
ViewBag.childs = childs;
return(View());
}
/// <summary>
/// 更改上级
/// </summary>
/// <param name="postId"></param>
/// <param name="parentId"></param>
/// <returns></returns>
public bool ChangeParent(int postId, int parentId)
{
Sys_Post post = _postDB.Get(postId);
post.ParentId = parentId;
return(_postDB.Update(post));
}
public JsonResult SavePost(int postId, string postCode, string postName, string postDesc, int postLevel,
int parentId)
{
try
{
if (postBL.Exists(postCode, postName, postId))
{
return(Json(new { result = 0, content = "岗位代码或岗位名称重复！" }, JsonRequestBehavior.AllowGet));
}
Sys_Post model = AllPosts.Find(p => p.PostId == postId);
if (model == null)
{
model = new Sys_Post();
}
model.PostId = postId;
model.PostCode = postCode;
model.PostName = postName;
model.Remark = postDesc;
if (postLevel == -1)
{
model.PostLevel = null;
}
else
{
model.PostLevel = postLevel;
}
model.ParentId = parentId;
if (model.PostId == 0)
{
postBL.Add(model);
AllPosts.Add(model);
}
else
{
postBL.Update(model);
}
lock (lockobj)
{
RefreshPostCache();
}
return(Json(new { result = 1, content = "保存成功" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { result = 0, content = "保存失败" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
public void Add(Sys_Post model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere =
@"insert into Sys_Post(PostCode,PostName,ParentId,Remark,PostLevel) values(@PostCode,@PostName,@ParentId,@Remark,@PostLevel)
SELECT @@Identity AS ID
";
var param = new
{
model.PostCode,
model.PostName,
model.ParentId,
model.Remark,
model.PostLevel
};
decimal id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault();
model.PostId = decimal.ToInt32(id);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Request.ContentEncoding = Encoding.GetEncoding("UTF-8");
StringBuilder sb = new StringBuilder();
string parentId = string.Empty;
if (!string.IsNullOrEmpty(context.Request.QueryString["id"]))
{
parentId = context.Request.QueryString["id"];
}
if (!string.IsNullOrEmpty(parentId))
{
Sys_UserInfo entity = bll.Get(p => p.UserInfoID == parentId);
if (entity != null)
{
string post = "";
string postN = "";
string name = entity.UserInfo_FullName;
string ment = entity.UserInfo_DepCode;
Sys_DepartmentBLL mentsbll = new Sys_DepartmentBLL();
Sys_Department ments = mentsbll.Get(p => p.Department_Code == ment);
post = entity.UserInfo_Post;
Sys_Post po = pobll.Get(p => p.PostID == post);
if (po != null)
{
postN = po.Post_Name;
}
string mentss = ments.Department_Name;
var Data = new { name = name, mentss = mentss, post = post, postN = postN };
string jsonPerson = JsonConvert.SerializeObject(Data);
context.Response.Write(jsonPerson);
}
}
else
{
context.Response.Write("{\"data\":\"error\"}");
}
}
/// <summary>
/// /
/// </summary>
public void show()
{
Sys_DepartmentBLL depbll = new Sys_DepartmentBLL();
if (!string.IsNullOrEmpty(id))
{
Sys_PostBLL bllPost = new Sys_PostBLL();
modelGwxx = bllPost.Get(p => p.PostID == id);
if (modelGwxx != null)
{
this.txtGwName.Text = modelGwxx.Post_Name;
this.txtpx.Text = modelGwxx.Post_Sort.ToString();
depmodel = depbll.Get(p => p.Department_Code == modelGwxx.Post_DepCode);
if (depmodel != null)
{
this.txt_depName.Text = depmodel.Department_Name;
}
}
}
else
{
if (!string.IsNullOrEmpty(hid_DepCode))
{
depmodel = depbll.Get(p => p.Department_Code == hid_DepCode);
if (depmodel != null)
{
this.txt_depName.Text = depmodel.Department_Name;
}
}
else
{
depmodel = depbll.Get(p => p.Department_Code == "001");
if (depmodel != null)
{
this.txt_depName.Text = depmodel.Department_Name;
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">要更新的实体对象</param>
/// <returns>成功返回True，失败返回False</returns>
public bool Update(Sys_Post model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere =
@"update Sys_Post set PostCode=@PostCode,PostName=@PostName,ParentId=@ParentId,Remark=@Remark,PostLevel=@PostLevel where PostId=@PostId
UPDATE Sys_User SET PostId=@PostId,PostCode=@PostCode,PostName=@PostName,PostLevel=@PostLevel WHERE PostId=@PostId
";
var param = new
{
model.PostCode,
model.PostName,
model.ParentId,
model.Remark,
model.PostLevel,
model.PostId
};
int result = conn.Execute(sqlwhere, param);
return(result > 0);
}
}
private void InsertUserList(List <Sys_User> listUser, ref string userTempID, ref string chongfu)
{
List <Sys_User> listUserSql = userBL.GetList(" Sys_User.IsDelete = 0 ");
foreach (Sys_User item in listUser)
{
try
{
Sys_User model = listUserSql.Find(p => p.JobNum == item.JobNum);
if (model != null)
{
#region 系统已存在用户，做修改操作 但是被无知的人说，这个不需要；那这个就被邪恶的我干掉了。。。不要怪我哦
//model.Realname = item.Realname;
//model.Sex = item.Sex;
//model.Birthday = item.Birthday;
//model.Email = item.Email;
//model.Telephone = item.Telephone;
//model.Fax = item.Fax;
//model.JobTitle = item.JobTitle;
//model.Ename = item.Ename;
//Sys_Department dep = AllDepartments.Find(p => p.DeptCode == item.DeptCode);
//if (dep != null)
//{
// item.DeptCode = dep.DeptCode;
// item.DeptName = dep.DeptName;
// item.DeptId = dep.DepartmentId;
//}
//else
//{
// item.DeptCode = "";
// item.DeptName = "";
// item.DeptId = -1;
//}
//Sys_Post post = AllPosts.Find(p => p.PostCode == item.PostCode);
//if (post != null)
//{
// item.PostCode = post.PostCode;
// item.PostName = post.PostName;
// item.PostLevel = post.PostLevel;
// item.PostId = post.PostId;
//}
//else
//{
// item.PostLevel = null;
// item.PostName = "";
// item.PostCode = "";
// item.PostId = -1;
//}
//model.Status = item.Status;
//model.FreezeTime = null;
//userBL.Update(model);
#endregion
if (chongfu != "")
{
chongfu = chongfu + "," + item.Username;
}
else
{
chongfu = item.Username;
}
}
else
{
if (item.Status < 2)
{
Sys_Department dep = AllDepartments.Find(p => p.DeptCode == item.DeptCode);
if (dep != null)
{
item.DeptCode = dep.DeptCode;
item.DeptName = dep.DeptName;
item.DeptId = dep.DepartmentId;
}
else
{
item.DeptCode = "";
item.DeptName = "";
item.DeptId = -1;
}
Sys_Post post = AllPosts.Find(p => p.PostCode == item.PostCode);
if (post != null)
{
item.PostCode = post.PostCode;
item.PostName = post.PostName;
//item.PostLevel = post.PostLevel;
item.PostId = post.PostId;
}
else
{
item.PostLevel = null;
item.PostName = "";
item.PostCode = "";
item.PostId = -1;
}
userBL.Add(item);
}
}
}
catch
{
if (userTempID != "")
{
userTempID = userTempID + "," + item.Username;
}
else
{
userTempID = item.Username;
}
}
}
}
/// 保存
/// </summary>
/// <param name="obj"></param>
/// <param name="e"></param>
protected void btnSave_Click(object obj, EventArgs e)
{
Sys_PostBLL bllPost = new Sys_PostBLL();
if (string.IsNullOrEmpty(id))
{
modelGwxx.PostID = Guid.NewGuid().ToString();
modelGwxx.Post_AddUserId = "1";// base.CurrUserInfo().UserID;
modelGwxx.Post_AddTime = DateTime.Now;
modelGwxx.Post_Name = txtGwName.Text.Trim();
modelGwxx.Post_Sort = int.Parse(txtpx.Text.Trim());
modelGwxx.Post_DepCode = hid_DepCode;
modelGwxx.Post_IsDelete = false;
modelGwxx.Post_EditTime = DateTime.Now;
modelGwxx.Post_EditUserId = "1";//base.CurrUserInfo().UserID;
modelGwxx.Post_Sort = 0;
bool IsPost = bllPost.Add(modelGwxx);
if (IsPost)
{
//Risk_PostRiskLib modelGwfxk = new Risk_PostRiskLib();
//modelGwfxk.PostRiskLibID = Guid.NewGuid().ToString();
//modelGwfxk.PostRiskLib_EvaluateLevel = "";
//modelGwfxk.PostRiskLib_Score = 0;
//modelGwfxk.PostRiskLib_AddUserId = base.CurrUserInfo().UserID;
//modelGwfxk.PostRiskLib_AddTime = DateTime.Now;
//modelGwfxk.PostRiskLib_PostID = modelGwxx.PostID;
//bllGwfxk.Add(modelGwfxk, out msg);
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('添加成功！');coed('1')", true);
// MessageBox.Show(this, "添加成功");
}
else
{
MessageBox.Show(this, "保存出错");
}
}
else
{
//string ids = " PostID ='" + hid_GwValue.Value + "'";
//modelGwxx = bllPost.FindWhere(ids)[0];
modelGwxx = bllPost.Get(p => p.PostID == id);
//modelGwxx.Post_DepCode = this.hid_DepCode.Value;
modelGwxx.Post_Name = txtGwName.Text.Trim();
modelGwxx.Post_Sort = int.Parse(txtpx.Text.Trim());
if (bllPost.Update(modelGwxx))
{
////var lis = bllGwfxk.FindWhere(" PostRiskLib_PostID='" + modelGwxx.PostID + "'");
//var lis = bllGwfxk.FindWhere(p => p.PostRiskLib_PostID == modelGwxx.PostID);
//if (lis.Count == 0)
//{
// Risk_PostRiskLib modelGwfxk = new Risk_PostRiskLib();
// modelGwfxk.PostRiskLibID = Guid.NewGuid().ToString();
// modelGwfxk.PostRiskLib_EvaluateLevel = "";
// modelGwfxk.PostRiskLib_Score = 0;
// modelGwfxk.PostRiskLib_AddUserId = base.CurrUserInfo().UserID;
// modelGwfxk.PostRiskLib_AddTime = DateTime.Now;
// modelGwfxk.PostRiskLib_PostID = modelGwxx.PostID;
// bllGwfxk.Add(modelGwfxk, out msg);
//}
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('修改成功！');coed('2')", true);
//MessageBox.Show(this, "添加成功");
}
else
{
MessageBox.Show(this, "保存出错");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpPostedFile postedFile = Request.Files["File1"];
string depCode = Request["depCode"];
if (string.IsNullOrEmpty(depCode))
{
depCode = "001";
}
try
{
if (postedFile.FileName != "")
{
string tempPath = UploadFileCommon.CreateDir("Uplod"); //获取保存文件夹路径。
string savepath = Server.MapPath(tempPath); //获取保存路径
string fileExtension = System.IO.Path.GetExtension(postedFile.FileName).ToLower();
if (!Directory.Exists(savepath)) //查看当前文件夹是否存在
{
Directory.CreateDirectory(savepath);
}
string sNewFileName = DateTime.Now.ToString("yyyyMMddhhmmsfff");//上传后的文件名字
string fname = tempPath + sNewFileName + fileExtension;
string allowedExtensions = ".xlsx|.xls";
if (!allowedExtensions.Contains(fileExtension))
{
//this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请选择Excel文件！');col()", true);
MessageBox.Show(this, "请选择Excel文件");
return;
}
postedFile.SaveAs(Server.MapPath(fname));
string filename = Server.MapPath(fname);
ImportExcl excl = new ImportExcl();
DataTable dt = excl.ExcelToDataSet(filename);
if (dt != null)
{
int a = dt.Rows.Count;
List <Sys_UserInfo> listUsermodel = new List <Sys_UserInfo>();
List <Sys_Post> listpostmodel = new List <Sys_Post>();
for (int i = 0; i < a; i++)
{
Sys_UserInfo sysmodel = new Sys_UserInfo();
sysmodel.UserInfoID = Guid.NewGuid().ToString();
sysmodel.UserInfo_FullName = dt.Rows[i][1].ToString();
string Post_Name = dt.Rows[i][2].ToString();
Sys_Post postmodel = postbll.Find(p => p.Post_Name == Post_Name && p.Post_DepCode == depCode);
Sys_Post post = new Sys_Post();
if (postmodel == null)
{
post.PostID = Guid.NewGuid().ToString();
post.Post_Name = dt.Rows[i][2].ToString();
post.Post_DepCode = depCode;
post.Post_AddUserID = CurrUserInfo().UserID;
post.Post_AddTime = DateTime.Now;
sysmodel.UserInfo_Post = post.PostID;
listpostmodel.Add(post);
}
else
{
sysmodel.UserInfo_Post = postmodel.PostID;
}
sysmodel.UserInfo_Position = dt.Rows[i][3].ToString();
sysmodel.UserInfo_PhoneNumber = dt.Rows[i][4].ToString();
sysmodel.UserInfo_PositionLevel = dt.Rows[i][5].ToString();
string DataDict_Name = dt.Rows[i][6].ToString();
Sys_DataDict DataDictmodel = DataDictbll.Find(p => p.DataDict_Name == DataDict_Name);
if (DataDictmodel != null)
{
sysmodel.UserInfo_Type = DataDictmodel.DataDict_Code;
}
else
{
sysmodel.UserInfo_Type = "0403";
}
sysmodel.UserInfo_LoginUserName = dt.Rows[i][1].ToString();
sysmodel.UserInfo_LoginUserPwd = DESEncrypt.Encrypt("111111");
sysmodel.UserInfo_DepCode = depCode;
sysmodel.UserInfo_RoleID = "02f13817-9f74-4169-b279-4b00cc741a91";
sysmodel.UserInfo_Status = "0301";
sysmodel.UserInfo_Sequence = int.Parse(dt.Rows[i][0].ToString());
listUsermodel.Add(sysmodel);
}
bool u = userbll.AddLists(listpostmodel, listUsermodel);
if (u)
{
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('导入成功！');col()", true);
}
else
{
MessageBox.Show(this, "导入失败！");
}
}
}
else
{
MessageBox.Show(this, "导入失败！");
}
}
catch { }
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_Post model)
{
return(_postDB.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Sys_Post model)
{
_postDB.Add(model);
}
