// 玩家名字是否与搜索框的内容相同 private bool isMatchSearchName(string name) { if (m_SearchText == "") { return(true); } string pyName = PinYinConverter.Get(name).ToLower(); string firstPYName = PinYinConverter.GetFirst(name).ToLower(); name = name.ToLower(); m_SearchText = m_SearchText.ToLower(); if (name.IndexOf(m_SearchText) >= 0) { return(true); } if (pyName.IndexOf(m_SearchText) >= 0) { return(true); } if (firstPYName.IndexOf(m_SearchText) >= 0) { return(true); } return(false); }
private void AddToDgv(List <DataTable> dtList) { this.dgvJob.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; this.dgvJob.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; if (dtList.Count < 1) { return; } foreach (DataColumn dc in dtList[0].Columns) { this.dgvJob.Columns.Add("column" + PinYinConverter.Get(dc.ColumnName), dc.ColumnName); } foreach (DataTable dt in dtList) { foreach (DataRow row in dt.Rows) { int rowIndex = this.dgvJob.Rows.Add(); foreach (DataColumn col in dt.Columns) { this.dgvJob["column" + PinYinConverter.Get(col.ColumnName), rowIndex].Value = row[col].ToString(); } //this.dgvJob["ColumnExcelFile", rowIndex].Value= dt.TableName; //this.dgvJob["ColumnPublished", rowIndex].Value = false; } } this.dgvJob.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; this.dgvJob.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; }
/// <summary> /// 汉字转拼音缩写 /// </summary> /// <param name="str">要转换的汉字字符串</param> /// <returns>拼音缩写</returns> public static String GetPYString(String str) { String TempStr = ""; foreach (char Chr in str) { if ((int)Chr >= 33 && (int)Chr <= 126) { //字母和符号原样保留 TempStr += Chr.ToString(); } else if ((int)Chr == 12288) { //将全角空格转换为半角空格 TempStr += (char)32; } else if ((int)Chr > 65280 && (int)Chr < 65375) { //将全角符号转换为半角符号 TempStr += (char)((int)Chr - 65248); } else { //累加拼音声母 TempStr += PinYinConverter.GetFirst(Chr); //GetPYChar(Chr.ToString()); } } return(TempStr); }
/// <summary> /// ºº×ÖתƴÒôËõд /// </summary> /// <param name="str">Ҫת»»µÄºº×Ö×Ö·û´®</param> /// <returns>Æ´ÒôËõд</returns> public static String GetPYString(String str) { String TempStr = ""; foreach (char Chr in str) { if ((int)Chr >= 33 && (int)Chr <= 126) { //×ÖĸºÍ·ûºÅÔÑù±£Áô TempStr += Chr.ToString(); } else if ((int)Chr == 12288) { //½«È«½Ç¿Õ¸ñת»»Îª°ë½Ç¿Õ¸ñ TempStr += (char)32; } else if ((int)Chr > 65280 && (int)Chr < 65375) { //½«È«½Ç·ûºÅת»»Îª°ë½Ç·ûºÅ TempStr += (char)((int)Chr - 65248); } else { //ÀÛ¼ÓÆ´ÒôÉùĸ //TempStr += GetPYChar(Chr.ToString()); TempStr += PinYinConverter.GetFirst(Chr); // ÎÄÊéºÍÒ»Ìå»ú³ÌÐòWPF²¿·ÖʹÓÃͬһÖÖ·½·¨ } } return(TempStr); }
public static bool SaveOrder(string shop, string user, string content) { bool isOk = false; Dictionary <string, string> dataMap = new Dictionary <string, string>(); dataMap.Add("id", Guid.NewGuid().ToString()); dataMap.Add("UserId", userId); dataMap.Add("OrderDate", DateTime.Now.ToString()); string[] strs = content.Split(';'); foreach (string kv in strs) { string[] strs2 = kv.Split('@'); string name = strs2[0]; if (name.Length < 1) { continue; } string num = strs2[1]; dataMap.Add(PinYinConverter.Get(name), num); } DbHelp db = new DbHelp(); db.InsertData("tb_orderFuding", dataMap); return(isOk); }
public TypeImageDownloadTask(CarType carType) { mFilePath = Path.Combine(BASE_FILE_PATH, TYPE_DIR, PINYIN_DIR); //carType.CarFactory.CarBrand.Name, carType.CarFactory.Name); mFileName = Path.Combine(mFilePath, PinYinConverter.Get(carType.CarFactory.Name + "_" + carType.Name) + IMAGE_POSTFIX); carType.ImagePath = Path.Combine(Environment.CurrentDirectory, mFileName); initFile(); mUrl = carType.ImageUrl; }
public FactoryLogoDownloadTask(CarFactory carFactory) { mFilePath = Path.Combine(BASE_FILE_PATH, FACTORY_DIR, PINYIN_DIR); //carFactory.CarBrand.Name, carFactory.Name); mFileName = Path.Combine(mFilePath, PinYinConverter.Get(carFactory.Name) + IMAGE_POSTFIX); carFactory.LogoPath = Path.Combine(Environment.CurrentDirectory, mFileName); initFile(); mUrl = carFactory.LogoUrl; }
public MenuMgrAppService(IMenuMgrRepository menuRepository, IFieldsMgrRepository fieldRepository, IDBStructOperateRepository structOperateRepository, IRepository <MenuStatus> menuStatusRepository) { _menuRepository = menuRepository; _converter = new PinYinConverter(); _fieldRepository = fieldRepository; _structOperateRepository = structOperateRepository; _menuStatusRepository = menuStatusRepository; }
private static IEnumerable <Run> makeRunsFromContent(string content, Brush hlColor, string hlContent) { List <Run> listRtn = new List <Run>(); if (!string.IsNullOrWhiteSpace(content)) { string hlInfo = hlContent;//HighlightContent.ToHighlight; //hlContent; if (string.IsNullOrWhiteSpace(hlInfo)) { listRtn.Add(new Run(content)); } else { List <string> searchInfos = hlInfo.ToLower().Split(separator, StringSplitOptions.RemoveEmptyEntries).ToList(); if (searchInfos.Count == 0) { listRtn.Add(new Run(content)); } else { bool[] hlKeys = new bool[content.Length]; var szms = PinYinConverter.ToShouZiMuArray(content); foreach (var info in searchInfos) { int index = szms.IndexOf(info); if (index >= 0) { for (int i = 0; i < info.Length; i++) { hlKeys[index + i] = true; } } } for (int i = 0; i < content.Length;) { int length = getHighlightLength(hlKeys, i); if (hlKeys[i]) { listRtn.Add(new Run(content.Substring(i, length)) { Foreground = hlColor }); } else { listRtn.Add(new Run(content.Substring(i, length))); } i += length; } } } } return(listRtn); }
private void TB_Search_TextChanged(object sender, TextChangedEventArgs e) { ListBox list = null; Dictionary <string, User> dataList = null; if (this.LB_SessionList.Visibility == System.Windows.Visibility.Visible) { list = this.LB_SessionList; dataList = CurrentUser.ChatTable; } else { list = this.LB_ContactList; dataList = CurrentUser.ContactTable; } list.Items.Clear(); foreach (var item in dataList) { string name = item.Value.DisplayName; if (name.IndexOf(this.TB_Search.Text, StringComparison.OrdinalIgnoreCase) >= 0) { ContactListItem listItem = new ContactListItem() { DisplayName = item.Value.DisplayName, User = item.Value }; list.Items.Add(listItem); continue; } if (PinYinConverter.Get(name).ToLower().IndexOf(this.TB_Search.Text.ToLower(), StringComparison.OrdinalIgnoreCase) >= 0) { ContactListItem listItem = new ContactListItem() { DisplayName = item.Value.DisplayName, User = item.Value }; list.Items.Add(listItem); continue; } if (PinYinConverter.GetFirst(name).ToLower().IndexOf(this.TB_Search.Text.ToLower(), StringComparison.OrdinalIgnoreCase) >= 0) { ContactListItem listItem = new ContactListItem() { DisplayName = item.Value.DisplayName, User = item.Value }; list.Items.Add(listItem); } } }
public ActionResult UpdAdminUser(SysAdminUserModel UpdateUser) { if (UpdateUser != null) { UpdateUser.GName = UpdateUser.GName.Trim(); string pinyin = PinYinConverter.Get(UpdateUser.UserName.Trim()); UpdateUser.PinYin = pinyin; UpdateUser.FirstPinYin = string.IsNullOrWhiteSpace(pinyin) ? "A" : pinyin.Substring(0, 1); int rowcount = mbll.UpdateSysAdminUser(UpdateUser); } return(RedirectToAction("AdminUser", "SysSettings", new { area = "AdminArea" })); }
public void GetFirstTest() { string input = "把汉字转换成拼音"; string actual = "BHZZHCPY"; Assert.Equal(PinYinConverter.GetFirst(input), actual); input = "把汉字转换成拼音"; actual = "BaHanZiZhuanHuanChengPinYin"; Assert.Equal(PinYinConverter.Get(input), actual); input = "把汉字,转换,成<拼音>"; actual = "BaHanZi,ZhuanHuan,Cheng<PinYin>"; Assert.Equal(PinYinConverter.Get(input), actual); }
public ActionResult AddAdminUser(SysAdminUserModel User) { if (User != null) { User.HeaderImg = "/img/avatars/avatar3.jpg"; string defaultpwd = "123456";//创建默认密码 User.UserPwd = DESEncrypt.Encrypt(defaultpwd, AppContent.SecrectStr); User.GName = User.GName.Trim(); string pinyin = PinYinConverter.Get(User.UserName.Trim()); User.PinYin = pinyin; User.FirstPinYin = string.IsNullOrWhiteSpace(pinyin) ? "A" : pinyin.Substring(0, 1); int rowcount = mbll.AddNewSysAdminUser(User); } return(RedirectToAction("AdminUser", "SysSettings", new { area = "AdminArea" })); }
static int getPinYin(char ch) { try { var gpy = PinYinConverter.Get(ch.ToString()); if (gpy != ch.ToString()) { var py2 = GetPyName(gpy); if (py2 > 0) { return(py2); } } } catch (Exception) { } return(-1); }
private static bool isSearched(string name, List <string> searchInfos) { if (searchInfos.Count == 0) { return(true); } ShouZiMuArray szms = PinYinConverter.ToShouZiMuArray(name); foreach (var info in searchInfos) { int index = szms.IndexOf(info); if (index < 0) { return(false); } } return(true); }
private void button9_Click(object sender, EventArgs e) { string text = textBox2.Text; PinYinConverter pyc = new PinYinConverter(); var pyres = pyc.getPinYinList(text); StringBuilder resstr = new StringBuilder(); foreach (var v in pyres) { foreach (var vv in v) { var ipa = mySpeechSynthesizer.Analysis.IPAManager.Pinyin2IPA(vv.Substring(0, vv.Length - 1)); resstr.Append(vv + " "); } resstr.Append("\r\n"); } textBox3.Text = resstr.ToString(); }
private void button6_Click(object sender, EventArgs e) { string text = textBox2.Text; PinYinConverter pyc = new PinYinConverter(); var res = pyc.getPinYinList(text); StringBuilder resstr = new StringBuilder(); foreach (var v in res) { foreach (var vv in v) { resstr.Append(vv + " "); } resstr.Append("\r\n"); } textBox3.Text = resstr.ToString(); //var res2 = res; }
public static DdUser ConvertFromUser(User user) { return(new DdUser { id = user.id, Name = user.Name, Ddid = user.Ddid, DeptName = user.DeptName, NamePY = PinYinConverter.GetFirst(user.Name) }); }
public DataJsonResult Save(District district, bool isNew) { var result = new DataJsonResult(); try { var nameChanged = true; if (!isNew) { var oldDistrict = _currencyService.GetSingleById <District>(district.Id); if (oldDistrict != null) { //判断名称是否变更,如果变更,则需要递归更新子节点 if (oldDistrict.FullName.Equals(district.FullName, StringComparison.OrdinalIgnoreCase) && oldDistrict.ShortName.Equals(district.ShortName, StringComparison.OrdinalIgnoreCase)) { nameChanged = false; } var parentDistrict = _currencyService.GetSingleById <District>(district.ParentId); if (parentDistrict != null) { district.Position = $"{parentDistrict.Position} tr_{parentDistrict.Id}".Trim(); if (parentDistrict.Id != "0") { district.MergerName = $"{parentDistrict.MergerName},{district.FullName}".Trim(','); district.MergerShortName = $"{parentDistrict.MergerShortName},{district.ShortName}".Trim(','); } else { district.MergerName = district.FullName; district.MergerShortName = district.ShortName; } } else { district.Position = $"tr_{district.Id}"; district.MergerName = district.FullName; district.MergerShortName = district.ShortName; } } else { //转为新增 isNew = true; } } if (district.Level < 3 && nameChanged) { district.PinYin = PinYinConverter.Get(district.FullName); district.JianPin = PinYinConverter.GetFirst(district.ShortName); district.FirstChar = PinYinConverter.GetFirst(district.ShortName.First()); } if (!isNew) { result.Success = _currencyService.Update(district); if (nameChanged) { //更新所有子节点 UpdateChildsInfo(district); } } else { result.Success = _currencyService.Create(district); } } catch (Exception ex) { result.ErrorMessage = "出现异常,保存行政区失败"; Logger.Error(ex, "保存行政区失败"); } return(result); }
/// <summary> /// /// </summary> /// <param name="userNamme"></param> /// <returns></returns> private static IEnumerable <GetMemberResult> SearchByUserName(string userNamme) { return(WeChatCommonService.lstUser.AsParallel().Where(x => !x.name.IsNullOrEmpty() && (x.name.ToUpper().Contains(userNamme.ToUpper()) || x.name.ToUpper().Contains(PinYinConverter.Get(userNamme.ToUpper()))) || PinYinConverter.Get(x.name).ToUpper().Contains(userNamme.ToUpper())).ToList()); }
public void PinYin() { var py = PinYinConverter.Get("john.xie"); Assert.IsTrue(py.Length > 0); }
//保存 private void SaveButton_Click(object sender, EventArgs e) { //判断所有信息是否填写正确 //判断UID是否正确 if (!checkUID()) { MessageBox.Show("“UID”与现有项目重复或不符合要求:\r\n\r\n支持:中文、英文、数字、_", "“UID”填写不正确"); return; } //名称 if (nameBox.Text.Replace(" ", "") == "") { MessageBox.Show("名称不能为空", "名称为空"); return; } //判断是否重名 DataTable dt = OLEREO.Library.SQLite.ExecuteDataTable("SELECT * FROM Item WHERE name = '" + nameBox.Text.Replace("'", "''") + "' COLLATE NOCASE;", ZIKU.DataBase.Config.Instance.Path); if (dt.Rows.Count > 0) //具有同名的项目 { if (dt.Rows.Count == 1) //同名只有一个,判断是不是和当前项目同一个 { if (dt.Rows[0]["id"].ToString() != idORnull) //不是同一个,说明这次修改成了一个现有的 { MessageBox.Show("有一个重名的项目,请改变名称,又或者编辑已有的项目"); return; } } else { //具有一个以上的同名项目,绝对重名了。 MessageBox.Show("有一个重名的项目,请改变名称,又或者编辑已有的项目"); return; } } //判断项目目录是否符合命名 if (!Tools.isMeetDirPath(iPath_BOX.text)) { MessageBox.Show("“项目目录”不符合命名要求,需要以X:\\开头,且路径中不能包含以下字符:\r\n\r\n/:*?\"<>|"); return; } //判断主页填写是否正确 if (homePageBox.Text.Replace(" ", "") != "") { bool https = homePageBox.Text.ToUpper().StartsWith(@"HTTPS://"); bool http = homePageBox.Text.ToUpper().StartsWith(@"HTTP://"); bool www = homePageBox.Text.ToUpper().StartsWith(@"WWW."); if (!(https || http || www)) { MessageBox.Show("主页要以下其中之一开头:\r\n\r\nhttps://\r\nhttp://\r\nwww."); return; } } else { homePageBox.Text = ""; } //dataFolderName 过滤掉 name 中非法字符 string newDataFolderName = Tools.filterFileName(nameBox.Text); if (iPath_BOX.text.Replace(" ", "") == "") { iPath_BOX.text = ""; } //名称改变之后,要尝试修改现有的目录 if (idORnull != null) //项目id不为空,表示这是编辑 { ZIKU.DataBase.Item em = ZIKU.DataBase.Item.getInstance(idORnull); if ((em.dataFolderName != newDataFolderName) && iPath_BOX.text == "") { string oldFullFolder = ZIKU.DataBase.Config.Instance.dataFolderExpand + "\\" + em.dataFolderName; //完整的旧目录名称 //if (iPath_BOX.text != "") // oldFullFolder = myZiku.exPand(myZiku.variableToSave(iPath_BOX.text, ZIKU.DataBase.Config.Instance.Path), ZIKU.DataBase.Config.Instance.Path);// + em.dataFolderName; //else // oldFullFolder = ZIKU.DataBase.Config.Instance.dataFolderExpand + "\\" + em.dataFolderName; if (/*(oldFullFolder.Replace(" ", "") != "") && 没有必要判断是否空格,编辑的项目总会有资料目录名称*/ System.IO.Directory.Exists(oldFullFolder)) { try { Tools.MyComputer.FileSystem.RenameDirectory(oldFullFolder, newDataFolderName); //尝试将旧的目录名称修改成新的 } catch { newDataFolderName = em.dataFolderName; //如果失败了旧继续沿用旧的资料目录名称 } } } } //为新的项目获取一个ID if ((idORnull == null)) { idORnull = SQLite.ExecuteNonQuery("INSERT INTO Item (name) values('新的项目')", ZIKU.DataBase.Config.Instance.Path).ToString(); } if (UIDBox.Text.Replace(" ", "") == "") { UIDBox.Text = idORnull; } //获取所有分类 string allSelectC_ID = ""; TreeNode tnn = Tools.GetNode(categoryBox.Nodes); foreach (TreeNode t in tnn.Nodes) { if (t.Checked) { allSelectC_ID += t.Tag.ToString() + ";"; } } ZIKU.DataBase.Item oleItemInfo = ZIKU.DataBase.Item.getInstance(idORnull); //更新分类选择 string[] newCID = Tools.SearchDifferent(oleItemInfo.C_ID, allSelectC_ID); foreach (string addCid in newCID[0].Split(new char[] { ';' }, System.StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category.addItem(addCid, idORnull); } foreach (string delCID in newCID[1].Split(new char[] { ';' }, System.StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category.removeItem(delCID, idORnull); } //判断新旧的图标值是否一样 if (iconBox.text.Replace(" ", "") == "") { iconBox.text = ""; } if (oleItemInfo.icon != iconBox.text) { System.IO.File.Delete(ZIKU.DataBase.Config.Instance.Path + ".cache\\icon\\" + idORnull + ".png"); } //先把 UID 写入到数据库中,要不后面的将值转换为save时,无法识别当前项目的 UID SQLite.ExecuteNonQuery("UPDATE Item SET UID = '" + UIDBox.Text + "' WHERE id = " + idORnull, ZIKU.DataBase.Config.Instance.Path); SQLite.ExecuteNonQuery("UPDATE Item SET name = '" + nameBox.Text.Replace("'", "''") + "',value = '" + myZiku.variableToSave(valueBox.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "',arguments = '" + myZiku.variableToSave(argumentsBox.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "',version = '" + versionBox.Text.Replace("'", "''") + "',intro = '" + introBox.Text.Replace("'", "''") + "',introduce = '" + introduceBox.Text.Replace("'", "''") + "',C_ID = '" + allSelectC_ID + "',icon = '" + myZiku.variableToSave(iconBox.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "',hideMain = '" + item_Hide_main.Checked.ToString().ToUpper() + "',hideSearch = '" + item_Hide_search.Checked.ToString().ToUpper() + "',iPath = '" + myZiku.variableToSave(iPath_BOX.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "',searchAlias = '" + searchAliasBox.Text.Replace("'", "''") + "',nameF = '" + PinYinConverter.GetFirst(nameBox.Text).Replace("'", "''") + "',workingDirectory = '" + myZiku.variableToSave(workingdirBox.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "',homePage = '" + homePageBox.Text.Replace("'", "''") + "',dataFolderName = '" + newDataFolderName.Replace("'", "''") + "',onAdmin = '" + onAdminBox.Checked.ToString().ToUpper() + "',IV_x86 = '" + myZiku.variableToSave(iv_x86_BOX.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "',IV_x64 = '" + myZiku.variableToSave(iv_x64_BOX.text, ZIKU.DataBase.Config.Instance.Path).Replace("'", "''") + "' WHERE id = " + idORnull, ZIKU.DataBase.Config.Instance.Path); this.Close(); }
/// <summary> /// 点击保存或者添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string Code = this.txtCode.Text.Trim(); string ProductCode = this.txtProductCode.Text.Trim(); string Name = this.txtName.Text.Trim(); string Unit = this.txtUnit.Text.Trim(); string producer = this.txtproducer.Text.Trim(); DbHelp db = new DbHelp(); Dictionary <string, string> dataMap = new Dictionary <string, string>(); dataMap.Add("Code", Code); dataMap.Add("ProductCode", ProductCode); dataMap.Add("Name", Name); dataMap.Add("Unit", Unit); dataMap.Add("producer", producer); bool isok = false; if (strID.Length < 1)//添加 { //重复的不添加 DataSet ds = db.Query("select * from tb_dishesFuding where name ='" + Name + "' and IsAction = 1"); if (null != ds && ds.Tables[0].Rows.Count > 0) { string script = ""; script += "<script language='javascript'>"; script += "alert('菜品已经存在,不能添加!');"; script += "</script>"; Page.RegisterStartupScript("", script); return; } else { //没有激活就激活 DataSet ds2 = db.Query("select * from tb_dishesFuding where name ='" + Name + "' and IsAction = 0"); if (null != ds2 && ds2.Tables[0].Rows.Count > 0) { string id = ds2.Tables[0].Rows[0]["id"].ToString(); dataMap.Add("IsAction", "1"); isok = db.UpdateDataWkt("tb_dishesFuding", dataMap, "where id ='" + id + "'"); } else { string ColName = PinYinConverter.Get(Name); dataMap.Add("id", Guid.NewGuid().ToString()); dataMap.Add("IsAction", "1"); dataMap.Add("ColName", ColName); int num = db.InsertData("tb_dishesFuding", dataMap); if (num > 0) { isok = true; //添加列到数据表中 StringBuilder strbld = new StringBuilder(); strbld.Append("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tb_orderFuding]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)"); strbld.Append("if (NOT exists ( select * from dbo.syscolumns where name = '" + ColName + "' and id in "); strbld.Append("(select id from dbo.sysobjects where id = object_id(N'[dbo].[tb_orderFuding]') and OBJECTPROPERTY(id, N'IsUserTable') = 1))"); strbld.Append(") "); strbld.Append("ALTER TABLE tb_orderFuding ADD " + ColName + " int NULL"); string sql = strbld.ToString(); int num2 = db.ExecuteNonQuery(sql); } } } } else { //编辑 isok = db.UpdateDataWkt("tb_dishesFuding", dataMap, "where id ='" + strID + "'"); } if (isok) { string script = ""; script += "<script language='javascript'>"; script += "alert('数据保存成功!');"; script += " opener.__doPostBack('" + "btnRefresh" + "','');"; script += " this.close();"; script += "</script>"; Page.RegisterStartupScript("RefreshSourceWindowAndCloseMe", script); } else { string script = ""; script += "<script language='javascript'>"; script += "alert('数据保存失败!');"; script += " opener.__doPostBack('" + "btnRefresh" + "','');"; script += " this.close();"; script += "</script>"; Page.RegisterStartupScript("RefreshSourceWindowAndCloseMe", script); } }
public void ImportClientDbo(System.Data.DataTable dtImportDoc) { //小区名称 楼栋名称 单元名称 门牌号 客户编号 客户姓名 //助记码 联系电话 手机 收费面积 供热状态 客户类型 //工作单位 楼层 温控器MAC 控制器MAC 设备名称 网关名称 var village = RF.Concrete <IHM_VillageRepository>(); var client = RF.Concrete <IHM_ClientInfoRepository>(); var device = RF.Concrete <IHM_DeviceInfoRepository>(); for (int i = 0; i < dtImportDoc.Rows.Count; i++) { var row = dtImportDoc.Rows[i]; var v1 = new HM_Village(); v1.Name = row["小区名称"].ToString(); v1.Type = 1; v1.EnName = ""; v1.Alias = v1.Name; v1.Address = ""; v1.Pinyi = PinYinConverter.GetShortPY(v1.Name); v1.Population = 0; v1.Summary = ""; v1.Office = ""; v1.TotalArea = 0; v1.ParentId = Guid.Empty; v1.NodePath = v1.Name; v1.Level = 1; v1.IsLast = false; v1.OrderBy = i; var model1 = IsVillage(row["小区名称"].ToString(), Guid.Empty); if (model1 != null) { v1 = model1; } else { village.Create(v1); village.Context.Commit(); } var v2 = new HM_Village(); v2.Name = row["楼栋名称"].ToString(); v2.Type = 2; v2.EnName = ""; v2.Alias = v1.Name; v2.Address = ""; v2.Pinyi = PinYinConverter.GetShortPY(v1.Name + v2.Name); v2.Population = 0; v2.Summary = ""; v2.Office = ""; v2.TotalArea = 0; v2.ParentId = v1.ID; v2.NodePath = v1.Name + "/" + v2.Name; v2.Level = 2; v2.IsLast = false; v2.OrderBy = i; var model2 = IsVillage(row["楼栋名称"].ToString(), v1.ID); if (model2 != null) { v2 = model2; } else { village.Create(v2); village.Context.Commit(); } var v3 = new HM_Village(); v3.Name = row["单元名称"].ToString(); v3.Type = 3; v3.EnName = ""; v3.Alias = v3.Name; v3.Address = ""; v3.Pinyi = PinYinConverter.GetShortPY(v1.Name + v2.Name + v3.Name); v3.Population = 0; v3.Summary = ""; v3.Office = ""; v3.TotalArea = 0; v3.ParentId = v2.ID; v3.NodePath = v1.Name + "/" + v2.Name + "/" + v3.Name; v3.Level = 3; v3.IsLast = false; v3.OrderBy = i; var model3 = IsVillage(row["单元名称"].ToString(), v2.ID); if (model3 != null) { v3 = model3; } else { village.Create(v3); village.Context.Commit(); } //客户信息 var hous = new HM_ClientInfo(); hous.Village = v3; hous.Name = dtImportDoc.Columns.Contains("客户姓名") ? row["客户姓名"].GetObjTranNull <string>() : ""; hous.HeatArea = dtImportDoc.Columns.Contains("收费面积") ? row["收费面积"].GetObjTranNull <double>() : 0; hous.RoomNumber = dtImportDoc.Columns.Contains("客户编号") ? row["客户编号"].GetObjTranNull <string>() : ""; hous.Cardno = dtImportDoc.Columns.Contains("门牌号") ? row["门牌号"].GetObjTranNull <string>() : ""; hous.HelpeCode = dtImportDoc.Columns.Contains("助记码") ? row["助记码"].GetObjTranNull <string>() : ""; hous.ClientType = dtImportDoc.Columns.Contains("客户类型") ? row["客户类型"].GetObjTranNull <string>() : ""; hous.Birthday = Convert.ToDateTime("1999-1-1"); hous.Floor = row["楼层"].GetObjTranNull <int>(); hous.IDCard = ""; hous.Phone = dtImportDoc.Columns.Contains("联系电话") ? row["联系电话"].GetObjTranNull <string>() : ""; hous.ZipCode = ""; hous.Email = ""; hous.JobAddress = ""; hous.HomeAddress = ""; client.Create(hous); // 客户设备 var dev = new HM_DeviceInfo(); dev.ClientInfo_ID = hous.ID; dev.ClientInfo_Name = hous.Name; dev.DeviceMac = dtImportDoc.Columns.Contains("温控器MAC") ? row["温控器MAC"].GetObjTranNull <string>() : ""; dev.DeviceNumber = dtImportDoc.Columns.Contains("控制器MAC") ? row["控制器MAC"].GetObjTranNull <string>() : ""; dev.DeviceType = 0; dev.HeatUnitType = HeatUnitType.KWH; dev.IsOpen = true; dev.Remark = ""; device.Create(dev); } client.Context.Commit(); }
public static string GetPinYingFirst(string str) { return(PinYinConverter.GetFirst(str)); }
protected void ExcelIn(string Path) { //导入Excel UserList.Clear(); ErrUserList.Clear(); string companyPostID = CompanyBLL.ReadCompany(CompanyId).Post; List <PostInfo> companyPostList = PostBLL.ReadPostListByPostId(companyPostID); List <PostInfo> companyDepartmentList = PostBLL.ReadParentPostListByPostId(companyPostID); //加载要导入的Excel XlsDocument xls = new XlsDocument(Path);//加载外部Excel //获得Excel中的指定一个工作页 Worksheet sheet = xls.Workbook.Worksheets[0]; //int StyleNum = 0; bool Checked = true; NamePrefix = Prefix.Text.ToLower(); //读取数据 循环每sheet工作页的每一行,不读取前一行 for (int i = 2; i < sheet.Rows.Count; i++) { //int PostId = 0;//题型号 string Department = string.Empty; string PostName = string.Empty; string RealName = string.Empty; string Sex = string.Empty; string UserId = string.Empty; string PassWord = string.Empty; string Mobile = string.Empty; string Email = string.Empty; string StudyPostName = string.Empty; string AccountStyle = string.Empty; UserInfo user = new UserInfo(); Checked = true; //try { //当前行的都不为空时才执行 if (sheet.Rows[ushort.Parse(i.ToString())].CellCount >= 2) { //for (int QuestionLine = 1; QuestionLine <= 5; QuestionLine++) //{ // if ((i + QuestionLine) > (sheet.Rows.Count + 10) || (sheet.Rows[ushort.Parse((i + QuestionLine).ToString())].CellCount < 2)) // { // Checked = false; // break; // } //} if (Checked) { //try { try { Department = sheet.Rows[ushort.Parse(i.ToString())].GetCell(1).Value.ToString().Trim(); PostName = sheet.Rows[ushort.Parse(i.ToString())].GetCell(2).Value.ToString().Trim(); RealName = sheet.Rows[ushort.Parse(i.ToString())].GetCell(3).Value.ToString().Trim().Replace(" ", ""); Sex = sheet.Rows[ushort.Parse(i.ToString())].GetCell(4).Value.ToString().Trim(); Mobile = sheet.Rows[ushort.Parse(i.ToString())].GetCell(5).Value.ToString().Trim(); Email = sheet.Rows[ushort.Parse(i.ToString())].GetCell(6).Value.ToString().Trim(); AccountStyle = sheet.Rows[ushort.Parse(i.ToString())].GetCell(7).Value.ToString().Trim(); StudyPostName = sheet.Rows[ushort.Parse(i.ToString())].GetCell(8).Value.ToString().Trim(); } catch { Checked = false; } try { UserId = sheet.Rows[ushort.Parse(i.ToString())].GetCell(9).Value.ToString(); PassWord = sheet.Rows[ushort.Parse(i.ToString())].GetCell(10).Value.ToString(); } catch { } PostInfo postModel; //部门 if (string.IsNullOrEmpty(Department)) { Checked = false; } else { postModel = PostBLL.ReadPost(companyDepartmentList, Department); if (postModel != null) { user.Department = postModel.PostId; } else { Checked = false; } } if (string.IsNullOrEmpty(PostName)) { Checked = false; } else { user.PostName = PostName; postModel = PostBLL.ReadPost(companyPostList, PostName); if (postModel != null) { user.WorkingPostID = postModel.PostId; } } //姓名 if (string.IsNullOrEmpty(RealName)) { Checked = false; } user.RealName = RealName; //性别 switch (Sex) { case "男": user.Sex = 1; break; case "女": user.Sex = 2; break; default: user.Sex = 1; break; } if (!Regex.IsMatch(Mobile, @"^(1[345789][0-9]{9})$")) { Checked = false; Mobile += "[格式不正确]"; } //if (UserBLL.IsExistMobile(Mobile, int.MinValue)) //{ // Checked = false; // Mobile += "[重复]"; //} user.Mobile = Mobile; if (!Regex.IsMatch(Email, @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*")) { Checked = false; Email += "[格式不正确]"; } user.Email = Email; //帐号类型处理 switch (AccountStyle) { case "考试人员": user.GroupID = 36; break; case "公司管理员": user.GroupID = 37; break; case "集团管理员": user.GroupID = 8; break; case "内训师管理员": user.GroupID = 44; break; default: user.GroupID = 36; break; } if (string.IsNullOrEmpty(StudyPostName)) { Checked = false; } else { postModel = PostBLL.ReadPost(companyPostList, StudyPostName); //PostBLL.ReadPost(StudyPostName, user.Department); if (postModel != null) { user.StudyPostID = postModel.PostId; if (user.WorkingPostID <= 0) { user.WorkingPostID = user.StudyPostID; } } else { Checked = false; user.StudyPostID = 0; } } //生成名字全拼 if (string.IsNullOrEmpty(UserId)) { UserId = PinYinConverter.Get(RealName).ToLower(); } user.UserName = NamePrefix + UserId; //处理密码 if (string.IsNullOrEmpty(PassWord)) { PassWord = "******"; } PassWord = StringHelper.Password(StringHelper.SearchSafe(PassWord), (PasswordType)ShopConfig.ReadConfigInfo().PasswordType); user.UserPassword = PassWord; user.Status = 2; if (!Checked) { ErrUserList.Add(user); //break; } else { UserSearchInfo TestModel = new UserSearchInfo(); TestModel.UserName = user.UserName; if (UserBLL.SearchUserList(TestModel).Count > 0) { user.UserName += "[重名]"; ErrUserList.Add(user); } else { UserList.Add(user); } } } //catch //{ // continue; //} } } } //catch //{ // continue; //} } if (ErrUserList.Count > 0) { base.BindControl(ErrUserList, this.RecordList); ListShow.Style.Add("background", "yellow"); UserOk.Visible = false; } else { base.BindControl(UserList, this.RecordList); ListShow.Style.Add("background", ""); UserOk.Visible = true; } }