`
cw_volcano
  • 浏览: 16935 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
文章分类
社区版块
存档分类
最新评论

txt内容导入数据库

 
阅读更多
public bool ImportPurviewManIds(string fileName, string CurrentUserDomainId, string Pduid, string uploadtype)
        {
            try
            {
                if (File.Exists(fileName))
                {
                    //读取文件 一行一行读取
                    StreamReader objReader = new StreamReader(fileName, Encoding.Default);
                    string sLine = "";
                    List<string> arrText = new List<string>();

                    while (sLine != null)
                    {
                        sLine = objReader.ReadLine();
                        if (!string.IsNullOrEmpty(sLine))
                        {
                            arrText.Add(sLine);
                        }
                    }
                    objReader.Close();


                    List<iPAL.Models.Pub.INFO_USER_CONFIG> objlist = new List<INFO_USER_CONFIG>();
                    IUserVisit uv = new UserVisit();
                    foreach (string strline in arrText.Distinct())
                    {
                        if (string.IsNullOrEmpty(strline.Trim()))
                            continue;
                        UserInfo info = uv.GetHRInfo(strline.ToLower().Trim());
                        if (db.INFO_USER_CONFIG.Where(x => x.UserId == strline.ToLower().Trim()).Count() > 0)
                        {
                            throw new Exception("错误!账户:" + strline.ToLower().Trim() + "已经在此PDU存在!本次导入失败!");
                        }
                        else if (info == null)
                        {
                            throw new Exception("错误!账户:" + strline.ToLower().Trim() + "异常!本次导入失败!");
                        }
                        INFO_USER_CONFIG obj = new INFO_USER_CONFIG();
                        obj.SvrId = int.Parse(Pduid);
                        obj.RoleName = "普通用户";
                        obj.UserId = strline.ToLower().Trim();
                        obj.UserCnName = info.UserName;
                        objlist.Add(obj);

                    }
                    db.INFO_USER_CONFIG.InsertAllOnSubmit(objlist);
                    db.SubmitChanges();
                }
                return true;
            }
            catch (Exception ex)
            {
                throw ex;
                return false;
            }
        }
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics