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; }
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); }
// 玩家名字是否与搜索框的内容相同 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); }
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 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 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" })); }
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 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); }
/// <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); }
/// <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); } }
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; } }
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); }
public static string GetPinYing(string str) { return(PinYinConverter.Get(str)); }