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));
}
