public string Delete(HttpContext context)
{
string pcode = context.Request.QueryString["pcode"];
//List<Sys_DataDict> list = bll.FindWhere(" DataDict_ParentCode ='" + pcode + "'");
List <Sys_DataDict> list = bll.GetList(p => p.DataDict_ParentCode == pcode).ToList();
if (list.Count > 0)
{
return("0");
}
else
{
bool rtn = false;
//List<Sys_DataDict> list2 = bll.FindWhere(" DataDict_Code ='" + pcode + "'");
List <Sys_DataDict> list2 = bll.GetList(p => p.DataDict_Code == pcode).ToList();
if (list2.Count == 1)
{
Sys_DataDict da = list2[0];
da.DataDict_IsDel = true; //1为删除 0为未删除
rtn = bll.Update(da);
}
if (rtn)
{
return("1");
}
else
{
return("0");
}
}
}
/// <summary>
/// 新增
/// </summary>
public string Add(HttpContext context)
{
string name = context.Request.QueryString["name"];
string pcode = context.Request.QueryString["pcode"];
string sort = context.Request.QueryString["sort"];
string content = context.Request.QueryString["content"];
Sys_DataDict menumodel = new Sys_DataDict();
menumodel.DataDictID = Guid.NewGuid().ToString();
menumodel.DataDict_ParentCode = pcode;
menumodel.DataDict_Name = name;
menumodel.DataDict_Level = 1;
menumodel.DataDict_Remark = content;
menumodel.DataDict_Sequence = int.Parse(sort);
menumodel.DataDict_Code = bll.GetCode(pcode, "son");
menumodel.DataDict_AddTime = DateTime.Now;
menumodel.DataDict_IsDel = false;
string msg = string.Empty;
bool abl = bll.Add(menumodel);
if (abl)
{
return("1");
}
else
{
return("0");
}
}
public string ShowInfo(HttpContext context)
{
string code = context.Request.QueryString["code"];
Sys_DataDict model = bll.Get(p => p.DataDict_Code == code);
string json = model.ToJson <Sys_DataDict>();
return(json);
}
/// <summary>
/// 获得排序号
/// </summary>
/// <param name="menucode"></param>
/// <returns></returns>
public string GetSortNum(HttpContext context)
{
string pcode = context.Request.QueryString["pcode"];
List <Sys_DataDict> list = bll.GetList(p => p.DataDict_ParentCode == pcode).ToList();
if (list.Count > 0)
{
Sys_DataDict model = list.OrderByDescending(p => p.DataDict_Sequence).First();
return((model.DataDict_Sequence + 1).ToString());
}
else
{
return("1");
}
}
public string Modify(HttpContext context)
{
string name = context.Request.QueryString["name"];
string id = context.Request.QueryString["id"];
string sort = context.Request.QueryString["sort"];
string content = context.Request.QueryString["content"];
Sys_DataDict menumodel = bll.Get(p => p.DataDictID == id);
menumodel.DataDictID = id;
menumodel.DataDict_Name = name;
menumodel.DataDict_Remark = content;
menumodel.DataDict_Sequence = int.Parse(sort);
if (bll.Update(menumodel))
{
return("1");
}
else
{
return("0");
}
}
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 { }
}
