// 玩家名字是否与搜索框的内容相同
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;
}
}
