protected string GetChinesePY(string chineseString) { Encoding gb2312 = Encoding.GetEncoding("GB2312"); string strPY = Pinyin.GetInitials(chineseString, gb2312); return(strPY); }
public ActionResult editSure(string name, string sex, string bir, string joindate, string posi, string tel, string email, int isout, string password, string depart, string EmpID, string Role, string CompanyID) { try { //解密 CompanyID = Base64MIMA.JIE(CompanyID); } catch (Exception) { //跳转错误页面 return(Redirect("/ErrorPage/Index")); } string py = Pinyin.GetInitials(name); string pinyin = Pinyin.GetPinyin(name).Replace(" ", ""); string editsql = string.Format("update dbo.Employee set Name='{0}',Sex={1},Birth='{2}',JoinDate='{3}',EmpTel='{4}',EmpEmail='{5}',IsOut={6},EmpPassword='******',DepartID='{8}',PositionID='{9}',SpellJX='{11}',SpellQP='{12}',RoleID='{13}' where EmpID='{10}' and CompanyID='{14}'", name, sex, bir, joindate, tel, email, isout, password, depart, posi, EmpID, py, pinyin, Role, CompanyID); string edit = sql.EditDataCommand(editsql); if (edit == "0") { return(Content("ok")); } else { return(Content("no")); } }
private void button3_Click(object sender, RibbonControlEventArgs e) { var range = ExcelHelper.SelectRange; if (range != null) { Excel.Range f = ExcelHelper.App.InputBox("选择放置位置", Type: 8); var start = f.Address.Replace("$", "").Split(':')[0]; var data = range.Cast <Excel.Range>().Select((s, i) => { return(Pinyin.GetInitials(s.Value)); }).ToList(); var rows = range.Rows.Count; var cols = range.Columns.Count; var result = new object[rows, cols]; for (int i = 0; i < rows; i++) { for (int j = 0; j < cols; j++) { result[i, j] = data[i]; } } //ws.Range[start].get_Resize(rows, cols).Value2 = s; ExcelHelper.Worksheet.Range[start].get_Resize(range.Rows.Count, range.Columns.Count).Value = result; } }
/// <summary> /// 将汉字转换为拼音字符串 /// </summary> /// <param name="document"></param> /// <param name="everyCharUpper">每一个汉字手写字母是否转换为大写</param> /// <returns></returns> public static string TextConvertChar(this string document, bool everyCharUpper = false) { Encoding enc = Encoding.UTF8; document = document.Trim(); string firstChars = Pinyin.GetInitials(document, enc); //转换为大写字母 string pinying = Pinyin.GetPinyin(document); //这是获取到元素的拼音 if (!everyCharUpper) {//每一个单词的首字母进行大写转换 return(pinying.Replace(" ", string.Empty)); } StringBuilder sb = new StringBuilder(); foreach (string item in pinying.Split(' ')) { if (string.IsNullOrEmpty(item)) { continue; } //首字母进行处理 sb.Append(item.Substring(0, 1).ToUpper()); if (item.Length > 1) { sb.Append(item.Substring(1)); } } return(sb.ToString()); }
/// <summary> /// 汉字转简码 /// </summary> /// <param name="hz"></param> /// <returns></returns> public static string GetPYJM(string hz, Encoding code) { //Encoding gb2312 = Encoding.GetEncoding("GB2312"); string jm = Pinyin.GetInitials(hz, code); return(jm); }
/// <summary> /// 汉字转化为拼音首字母 /// </summary> /// <param name="text">汉字</param> /// <returns>首字母</returns> public static string GetFirstPinyin(string text) { Encoding gb2312 = Encoding.GetEncoding("GB2312"); string s = Pinyin.ConvertEncoding(text, Encoding.UTF8, gb2312); return(Pinyin.GetInitials(s, gb2312).Trim()); }
private void btn_save_Click(object sender, EventArgs e) { try { if (string.IsNullOrWhiteSpace(txt_name.Text.Trim())) { XtraMessageBox.Show("请您输入药品名称!"); return; } var entity = new Domain.Model.Medicine() { Id = detailId, Name = txt_name.Text.Trim(), NameCode = Pinyin.GetInitials(Pinyin.ConvertEncoding(txt_name.Text.Trim(), Encoding.UTF8, Encoding.GetEncoding("GB2312")), Encoding.GetEncoding("GB2312"))?.ToLower(), CommonName = txt_commonName.Text.Trim(), CommonNameCode = string.IsNullOrWhiteSpace(txt_commonName.Text.Trim()) ? "" : Pinyin.GetInitials(Pinyin.ConvertEncoding(txt_commonName.Text.Trim(), Encoding.UTF8, Encoding.GetEncoding("GB2312")), Encoding.GetEncoding("GB2312"))?.ToLower(), JYFWId = lue_ssjyfw.EditValue == null ? 0 : int.Parse(lue_ssjyfw.EditValue.ToString()), BZGG = txt_bzgg.Text.Trim(), UnitId = lue_unit.EditValue == null ? 0 : int.Parse(lue_unit.EditValue.ToString()), TypeId = lue_type.EditValue == null ? 0 : int.Parse(lue_type.EditValue.ToString()), JGFLId = lue_jgfl.EditValue == null ? 0 : int.Parse(lue_jgfl.EditValue.ToString()), SupplierId = lue_gys.EditValue == null ? 0 : int.Parse(lue_gys.EditValue.ToString()), SCCJId = lue_sccj.EditValue == null ? 0 : int.Parse(lue_sccj.EditValue.ToString()), CPZC = txt_cpzc.Text.Trim(), PZWH = date_pzwh.Text.Trim(), IsPrescription = ckb_isPrescription.Checked, Status = 1, }; using (var db = SugarDao.GetInstance()) { if (Convert.ToBoolean(db.InsertOrUpdate(entity))) { string msg = detailId > 0 ? $"【修改成功】 " : $"【新增成功】"; Log.Info(new LoggerInfo() { LogType = LogType.药品信息.ToString(), CreateUserId = UserInfo.Account, Message = msg + $"药品Id:{entity.Id},药品名称:{entity.Name},药品简写:{entity.NameCode},药品通用名称:{entity.CommonName}" + $",药品通用名称简写:{entity.CommonNameCode},经营范围:{lue_ssjyfw.Text},药品规格:{txt_bzgg.Text},药品单位:{lue_unit.Text}" + $",药剂分类:{lue_type.Text},监管分类:{lue_jgfl.Text},供应商:{lue_gys.Text},生产厂家:{lue_sccj.Text},产品注册证批件号:{txt_cpzc.Text.Trim()}" + $",批准文号有效期:{ date_pzwh.Text.Trim()},是否处方药:{(entity.IsPrescription ? "是" : "否")}" }); DialogResult = DialogResult.OK; this.Close(); } else { DialogResult = DialogResult.Cancel; } } } catch (Exception) { throw; } }
private async void button2_Click(object sender, RibbonControlEventArgs e) { var tp = new DxTempTableViewer(); var p = Globals.ThisAddIn.CustomTaskPanes.Add(tp, "转换"); tp.Dock = DockStyle.Fill; p.Width = 600; p.Visible = true; var t = Task.Run(() => { var dt = ExcelHelper.GetDataTable(); dt.Columns.Add("全拼"); dt.Columns.Add("首字母"); if (dt != null) { var i = 0; var total = dt.Rows.Count; foreach (DataRow dr in dt.Rows) { i++; dr["全拼"] = Pinyin.GetPinyin(dr[0].ToString()); dr["首字母"] = Pinyin.GetInitials(dr[0].ToString()); tp.Invoke((MethodInvoker) delegate { tp.TsMsg.Text = $"正在计算第{i}行,共{total}行"; }); } } else { MessageBox.Show("请选择一个以上的单元格"); } return(dt); }); await t; tp.Dt = t.Result; tp.TsMsg.Text = $"数据获取完毕,共计{t.Result.Rows.Count}行"; //t.GetAwaiter().OnCompleted(() => //{ // tp.Invoke((MethodInvoker)delegate // { // tp.Dt = t.Result; // tp.TsMsg.Text = $"数据获取完毕,共计{t.Result.Rows.Count}行"; // }); //}); //Task.Run(() => //{ // Task.WaitAll(t); // tp.Invoke((MethodInvoker)delegate // { // tp.Dt = t.Result; // tp.TsMsg.Text = $"数据获取完毕,共计{t.Result.Rows.Count}行"; // }); //}); }
/// <summary> /// 获取汉语拼音码 /// </summary> /// <param name="strVal"></param> /// <returns></returns> public static string GetPinym(string strVal) { if (string.IsNullOrEmpty(strVal)) return ""; Encoding gb2312 = Encoding.GetEncoding("GB2312"); return Pinyin.GetInitials(strVal, gb2312); }
/// <summary> /// ����ѧУ /// </summary> /// <param name="school">Ҫ���µ�ѧУ</param> /// <returns></returns> public void Update(School school) { EventBus <School> .Instance().OnBefore(school, new CommonEventArgs(EventOperationType.Instance().Update())); school.PinyinName = Pinyin.GetPinyin(school.Name); school.ShortPinyinName = Pinyin.GetInitials(school.Name); schoolRepository.Update(school); EventBus <School> .Instance().OnAfter(school, new CommonEventArgs(EventOperationType.Instance().Update())); }
private void txt_name_EditValueChanged(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(txt_name.Text.Trim())) { Encoding gb2312 = Encoding.GetEncoding("GB2312"); txt_character.Text = Pinyin.GetInitials(Pinyin.ConvertEncoding(txt_name.Text.Trim(), Encoding.UTF8, gb2312), gb2312)? .ToLower(); } }
/// <summary> /// 汉字集合转拼音简码 /// </summary> /// <param name="hz"></param> /// <returns></returns> public static List <string> GetPYJM(List <string> hz, Encoding code) { List <string> pys = new List <string>(); foreach (var item in hz) { string py = Pinyin.GetInitials(item, code); pys.Add(py); } return(pys); }
/// <summary> /// 转换字符串成拼音 /// </summary> /// <param name="str"></param> /// <param name="type">转换为全部小写 1首字母大写 2只取第一个字母</param> /// <returns></returns> public static string GetPinYin(this string str, int type = 1) { if (type == 1) { return(Pinyin.GetPinyin(str)); } else { return(Pinyin.GetInitials(str).ToLower()); } }
public ActionResult AddOrderChannellink(ThirdPartyOrderChannelModel channelModel, List <ThirdPartyOrderChannellinkModel> linkList) { Encoding gb2312 = Encoding.GetEncoding("GB2312"); string s = Pinyin.ConvertEncoding(channelModel.OrderChannel, Encoding.UTF8, gb2312); string orderChannelEng = Pinyin.GetInitials(s, gb2312).Replace("_", ""); foreach (var item in linkList) { item.CreateBy = User.Identity.Name; item.LastUpdateBy = User.Identity.Name; if (!item.AdditionalRequirement.Contains("无")) { if (item.AdditionalRequirement.Contains("IsAggregatePage")) { item.IsAggregatePage = true; } if (item.AdditionalRequirement.Contains("IsAuthorizedLogin")) { item.IsAuthorizedLogin = true; } if (item.AdditionalRequirement.Contains("IsPartnerReceivSilver")) { item.IsPartnerReceivSilver = true; } if (item.AdditionalRequirement.Contains("IsOrderBack")) { item.IsOrderBack = true; } if (item.AdditionalRequirement.Contains("IsViewOrders")) { item.IsViewOrders = true; } if (item.AdditionalRequirement.Contains("IsViewCoupons")) { item.IsViewCoupons = true; } if (item.AdditionalRequirement.Contains("IsContactUserService")) { item.IsContactUserService = true; } if (item.AdditionalRequirement.Contains("IsBackTop")) { item.IsBackTop = true; } } else { continue; } } bool isSuccess = ChannellinkManager.AddOrderChannellink(channelModel, orderChannelEng, linkList); return(Json(new { data = isSuccess })); }
private static string GetSpellCode(string str) { Encoding gb2312 = Encoding.GetEncoding("gb2312"); string strA = Pinyin.ConvertEncoding(str, Encoding.UTF8, gb2312); //首字母 string strB = Pinyin.GetInitials(strA, gb2312).Substring(0, 1); //拼音 //string strC = Pinyin.GetPinyin(str); return(strB.ToUpper()); }
/// <summary> /// 获取首字母 /// </summary> /// <param name="document">汉字列表</param> /// <param name="everyCharUpper">首字母是否大写</param> /// <returns></returns> public static string TextConvertFirstChar(this string document, bool everyCharUpper = false) { Encoding enc = Encoding.UTF8; string pinying = Pinyin.GetInitials(document, enc);//大写的首字母 //首字母进行处理 if (!everyCharUpper) { return(pinying.ToLower()); } return(pinying); }
public static string GetPYString(string text) { string textStr = ""; Encoding gb2312 = Encoding.GetEncoding("GB2312"); if (text.Contains("埼")) { text = text.Replace("埼", "Q"); } //textStr= Pinyin.GetInitials(textStr, gb2312); //return textStr; return(Pinyin.GetInitials(text, gb2312)); }
/// <summary> /// 获取汉语拼音码 /// </summary> /// <param name="strVal"></param> /// <returns></returns> public static string GetPinym(string strVal) { if (string.IsNullOrEmpty(strVal)) { return(""); } Encoding gb2312 = Encoding.GetEncoding("GB2312"); //string s = Pinyin.ConvertEncoding(strVal, Encoding.UTF8, gb2312); //Pinyin.GetInitials(s, gb2312); return(Pinyin.GetInitials(strVal, gb2312)); }
/// <summary> /// 客户名称简写 /// </summary> public void CustomerNameToShorthand() { try { string cc = CustomerDescribe(); string Tsql = "select id,accountName from account where dbcVarchar2 is null or dbcVarchar2 = '' ;"; //string resultjson = xoqlGet(Tsql); string resultjson = sqlGet(Tsql); if (resultjson.Contains("count")) { JObject jo = (JObject)JsonConvert.DeserializeObject(resultjson); int count = Convert.ToInt32(jo["count"].ToString()); if (count > 0) { for (int a = 0; a < count; a++) { string id = jo["records"][a]["id"].ToString(); string accountName = jo["records"][a]["accountName"].ToString(); Encoding gb2312 = Encoding.GetEncoding("GB2312"); string s = Pinyin.ConvertEncoding(accountName, Encoding.UTF8, gb2312); string shortName = Pinyin.GetInitials(s, gb2312); //input格式 / string input = "{" + $"\"id\": {id}" + $",\"dbcVarchar2\": \"{shortName}\"" + "}"; bool fa = CustomerUpdate(input); if (fa) { LogHelper.Info($"{accountName}的简写:{shortName}生成成功!"); } else { LogHelper.Info($"{accountName}的简写:{shortName}生成失败!"); } } } LogHelper.Info($"无需要生成简写的客户信息!"); } } catch (Exception ex) { LogHelper.Error(ex.ToString()); } }
static void Main(string[] args) { string[] maxims = new string[] { "事常与人违,事总在人为", "骏马是跑出来的,强兵是打出来的", "驾驭命运的舵是奋斗。不抱有一丝幻想,不放弃一点机会,不停止一日努力。 ", "如果惧怕前面跌宕的山岩,生命就永远只能是死水一潭", "懦弱的人只会裹足不前,莽撞的人只能引为烧身,只有真正勇敢的人才能所向披靡" }; string[] medicines = new string[] { "聚维酮碘溶液", "开塞露", "炉甘石洗剂", "苯扎氯铵贴", "鱼石脂软膏", "莫匹罗星软膏", "红霉素软膏", "氢化可的松软膏", "曲安奈德软膏", "丁苯羟酸乳膏", "双氯芬酸二乙胺乳膏", "冻疮膏", "克霉唑软膏", "特比奈芬软膏", "酞丁安软膏", "咪康唑软膏、栓剂", "甲硝唑栓", "复方莪术油栓" }; Console.WriteLine("UTF8句子拼音:"); foreach (string s in maxims) { Console.WriteLine("汉字:{0}\n拼音:{1}\n", s, Pinyin.GetPinyin(s)); } Encoding gb2312 = Encoding.GetEncoding("GB2312"); Console.WriteLine("GB2312拼音简码:"); foreach (string m in medicines) { string s = Pinyin.ConvertEncoding(m, Encoding.UTF8, gb2312); Console.WriteLine("药品:{0}\n简码:{1}\n", s, Pinyin.GetInitials(s, gb2312)); } Console.ReadKey(); }
/// <summary> /// 中文转拼音 /// </summary> /// <param name="data"></param> /// <returns></returns> public List <string> GetPYData(string data) { List <string> list = new List <string>(); if (!string.IsNullOrEmpty(data)) { string [] arry = data.Split(';'); foreach (var item in arry) { string str = Pinyin.GetInitials(item).ToUpper(); list.Add(str); } } return(list); }
/// <summary> /// 获取用户 /// </summary> /// <param name="key"></param> /// <returns></returns> public List <Users> findUsers(string key) { var list = SimpleDb.AsQueryable().Where(u => u.userName.Contains(key)).ToList(); if (list.Count != 0) { return(list); } // 如果不是字符串包含 则按拼音首字母或者全拼来进行搜索 var totalList = SimpleDb.AsQueryable().ToList(); list.AddRange(totalList.Where(user => Pinyin.GetInitials(user.userName).ToLower().StartsWith(key) || Pinyin.GetPinyin(user.userName).Replace(" ", "").StartsWith(key))); return(list); }
/// <summary> /// 获取表头的中英对照 /// </summary> /// <param name="dt"></param> /// <param name="ic"></param> /// <returns></returns> public static DataTable getDtCNPy(DataTable dt, int ic) { DataTable dtCNpy = new DataTable(); dtCNpy.Columns.Add("cnC"); dtCNpy.Columns.Add("cnE"); int iflag = 0; for (int i = 0; i < ic; i++) { string strcnC = dt.Columns[i].ColumnName; string strcnE = Pinyin.GetInitials(strcnC); if (dtCNpy.Select("cnE = '" + strcnE + "'").Length > 0) { strcnE += iflag.ToString(); iflag++; } dtCNpy.Rows.Add(strcnC, strcnE); } return(dtCNpy); }
//增加 public ActionResult AddSure(string id, string name, int sex, DateTime bir, DateTime joindate, string tel, string email, int isout, string password, string depart, string posi, string CompanyID, string Role) { try { //解密 CompanyID = Base64MIMA.JIE(CompanyID); //加密 ViewBag.CompanyId = Base64MIMA.JIA(CompanyID); } catch (Exception) { //跳转错误页面 return(Redirect("/ErrorPage/Index")); } string isinsql = string.Format("select EmpID from dbo.Employee where EmpID='{0}' and CompanyID='{1}'", id, CompanyID); DataTable isin = sql.GetDataTableCommand(isinsql); if (isin?.Rows.Count > 0) { return(Content("have")); } else { string py = Pinyin.GetInitials(name); string pinyin = Pinyin.GetPinyin(name).Replace(" ", ""); string addsql = string.Format("INSERT INTO dbo.Employee(EmpID, Name ,Sex ,Birth ,JoinDate ,EmpTel ,EmpEmail ,IsOut ,SpellJX,SpellQP,EmpPassword ,DepartID,PositionID,CompanyID,RoleID)VALUES ('{10}','{0}',{1},'{2}','{3}','{4}','{5}',{6},'{11}','{12}','{7}',{8},{9},'{13}','{14}')", name, sex, bir, joindate, tel, email, isout, password, depart, posi, id, py, pinyin, CompanyID, Role); string add = sql.EditDataCommand(addsql); if (add == "0") { return(Content("ok")); } else { return(Content("no")); } } }
protected void BtnSure_Click(object sender, EventArgs e) { if (inputStart.Value.ToString() == "") { //提示 Response.Write("<script>alert('【表名前缀】不能为空')</script>"); } else if (inputName.Value.ToString() == "") { //提示 Response.Write("<script>alert('【表名】不能为空')</script>"); } else if (txtarea.InnerHtml == "") { //提示 Response.Write("<script>alert('【中文字段部分】不能为空')</script>"); } else { string str = ""; if (AutoCodeCk.Checked == true)//自动编号 { string s = bc.GoToRemoveChar(txtarea.InnerHtml); //转成拼音首字母 str = bc.GoToSpace(Pinyin.GetInitials(s)).ToUpper(); str += "\r\n"; str += txtarea.InnerHtml + "_${RunTime.CurYear}${RunTime.CurMonth}${RunTime.CurDay}{$AutoNum$}"; } else//数据表 { str = GetTable(); } showText.InnerHtml = str; } }
public void Test_Initials(string hanzi, string pinyin) { string converted = Pinyin.GetInitials(hanzi); Assert.IsTrue(converted == pinyin); }
/// <summary> /// 客户名称简写全部 需要分页 /// </summary> public void CustomerNameToShorthandFenye() { try { string cc = CustomerDescribe(); string Tsql = "select id,accountName from account limit 0,300;"; //string resultjson = xoqlGet(Tsql); string resultjson = sqlGet(Tsql); if (resultjson.Contains("count")) { JObject jo = (JObject)JsonConvert.DeserializeObject(resultjson); double count = Convert.ToDouble(jo["count"].ToString()); if (count > 0) { double totalsize = Convert.ToDouble(jo["totalSize"].ToString()); double yeshu = Math.Ceiling(totalsize / count); for (int b = 0; b < yeshu; b++) { Tsql = $"select id,accountName from account limit {b*300},300;"; resultjson = sqlGet(Tsql); if (resultjson.Contains("count")) { jo = (JObject)JsonConvert.DeserializeObject(resultjson); count = Convert.ToDouble(jo["count"].ToString()); if (count > 0) { for (int a = 0; a < count; a++) { string id = jo["records"][a]["id"].ToString(); string accountName = jo["records"][a]["accountName"].ToString(); Encoding gb2312 = Encoding.GetEncoding("GB2312"); string s = Pinyin.ConvertEncoding(accountName, Encoding.UTF8, gb2312); string shortName = Pinyin.GetInitials(s, gb2312); //input格式 / string input = "{" + $"\"id\": {id}" + $",\"dbcVarchar2\": \"{shortName}\"" + "}"; bool fa = CustomerUpdate(input); if (fa) { LogHelper.Info($"{accountName}的简写:{shortName}生成成功!"); } else { LogHelper.Info($"{accountName}的简写:{shortName}生成失败!"); } } } } } LogHelper.Info($"无需要生成简写的客户信息!"); } } } catch (Exception ex) { LogHelper.Error(ex.ToString()); } }
public CustomJsonResult Add(string operater, string merchId, RopPrdProductAdd rop) { CustomJsonResult result = new CustomJsonResult(); if (string.IsNullOrEmpty(rop.Name)) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "商品名称不能为空")); } if (rop.KindIds == null || rop.KindIds.Count == 0) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "至少选择一个商品模块")); } if (rop.SubjectIds == null || rop.SubjectIds.Count == 0) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "至少选择一个商品栏目")); } if (rop.DispalyImgUrls == null || rop.DispalyImgUrls.Count == 0) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "至少上传一张商品图片")); } using (TransactionScope ts = new TransactionScope()) { var prdProduct = new PrdProduct(); prdProduct.Id = GuidUtil.New(); prdProduct.MerchId = merchId; prdProduct.Name = rop.Name; prdProduct.BarCode = rop.BarCode; prdProduct.PinYinName = Pinyin.ConvertEncoding(prdProduct.Name, Encoding.UTF8, Encoding.GetEncoding("GB2312")); prdProduct.PinYinIndex = Pinyin.GetInitials(prdProduct.PinYinName, Encoding.GetEncoding("GB2312")); prdProduct.DispalyImgUrls = rop.DispalyImgUrls.ToJsonString(); prdProduct.MainImgUrl = ImgSet.GetMain(prdProduct.DispalyImgUrls); prdProduct.DetailsDes = rop.DetailsDes; prdProduct.BriefDes = rop.BriefDes; prdProduct.Creator = operater; prdProduct.CreateTime = DateTime.Now; foreach (var sku in rop.Skus) { var prdProductSku = new PrdProductSku(); prdProductSku.Id = GuidUtil.New(); prdProductSku.MerchId = prdProduct.MerchId; prdProductSku.PrdProductId = prdProduct.Id; prdProductSku.Name = prdProduct.Name; prdProductSku.SpecDes = sku.SpecDes; prdProductSku.SalePrice = sku.SalePrice; prdProductSku.Creator = operater; prdProductSku.CreateTime = DateTime.Now; CurrentDb.PrdProductSku.Add(prdProductSku); } if (rop.KindIds != null) { prdProduct.PrdKindIds = string.Join(",", rop.KindIds.ToArray()); foreach (var kindId in rop.KindIds) { var productSkuKind = new PrdProductKind(); productSkuKind.Id = GuidUtil.New(); productSkuKind.PrdKindId = kindId; productSkuKind.PrdProductId = prdProduct.Id; productSkuKind.Creator = operater; productSkuKind.CreateTime = DateTime.Now; CurrentDb.PrdProductKind.Add(productSkuKind); } } if (rop.SubjectIds != null) { prdProduct.PrdSubjectIds = string.Join(",", rop.SubjectIds.ToArray()); foreach (var subjectId in rop.SubjectIds) { var productSkuSubject = new PrdProductSubject(); productSkuSubject.Id = GuidUtil.New(); productSkuSubject.PrdSubjectId = subjectId; productSkuSubject.PrdProductId = prdProduct.Id; productSkuSubject.Creator = operater; productSkuSubject.CreateTime = DateTime.Now; CurrentDb.PrdProductSubject.Add(productSkuSubject); } } CurrentDb.PrdProduct.Add(prdProduct); CurrentDb.SaveChanges(); ts.Complete(); result = new CustomJsonResult(ResultType.Success, ResultCode.Success, "保存成功"); } return(result); }
public CustomJsonResult Edit(string operater, string merchId, RopPrdProductEdit rop) { CustomJsonResult result = new CustomJsonResult(); if (string.IsNullOrEmpty(rop.Id)) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "商品Id不能为空")); } if (string.IsNullOrEmpty(rop.Name)) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "商品名称不能为空")); } if (rop.KindIds == null || rop.KindIds.Count == 0) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "商品模块分类不能为空")); } if (rop.DispalyImgUrls == null || rop.DispalyImgUrls.Count == 0) { return(new CustomJsonResult(ResultType.Failure, ResultCode.Failure, "商品图片不能为空")); } using (TransactionScope ts = new TransactionScope()) { var prdProduct = CurrentDb.PrdProduct.Where(m => m.Id == rop.Id).FirstOrDefault(); prdProduct.Name = rop.Name; prdProduct.PinYinName = Pinyin.ConvertEncoding(prdProduct.Name, Encoding.UTF8, Encoding.GetEncoding("GB2312")); prdProduct.PinYinIndex = Pinyin.GetInitials(prdProduct.PinYinName, Encoding.GetEncoding("GB2312")); prdProduct.BriefDes = rop.BriefDes; prdProduct.DetailsDes = rop.DetailsDes; prdProduct.DispalyImgUrls = rop.DispalyImgUrls.ToJsonString(); prdProduct.Mender = operater; prdProduct.MendTime = DateTime.Now; foreach (var sku in rop.Skus) { var prdProductSku = CurrentDb.PrdProductSku.Where(m => m.Id == sku.Id).FirstOrDefault(); if (prdProductSku != null) { prdProductSku.SpecDes = sku.SpecDes; prdProductSku.SalePrice = sku.SalePrice; prdProductSku.Mender = operater; prdProductSku.MendTime = DateTime.Now; } } var prdProductKinds = CurrentDb.PrdProductKind.Where(m => m.PrdProductId == prdProduct.Id).ToList(); foreach (var prdProductKind in prdProductKinds) { CurrentDb.PrdProductKind.Remove(prdProductKind); } if (rop.KindIds != null) { foreach (var kindId in rop.KindIds) { var prdProductKind = new PrdProductKind(); prdProductKind.Id = GuidUtil.New(); prdProductKind.PrdKindId = kindId; prdProductKind.PrdProductId = prdProduct.Id; prdProductKind.Creator = operater; prdProductKind.CreateTime = DateTime.Now; CurrentDb.PrdProductKind.Add(prdProductKind); } } var prdProductSubjects = CurrentDb.PrdProductSubject.Where(m => m.PrdProductId == prdProduct.Id).ToList(); foreach (var prdProductSubject in prdProductSubjects) { CurrentDb.PrdProductSubject.Remove(prdProductSubject); } if (rop.SubjectIds != null) { foreach (var subjectId in rop.SubjectIds) { var prdProductSubject = new PrdProductSubject(); prdProductSubject.Id = GuidUtil.New(); prdProductSubject.PrdSubjectId = subjectId; prdProductSubject.PrdProductId = prdProduct.Id; prdProductSubject.Creator = operater; prdProductSubject.CreateTime = DateTime.Now; CurrentDb.PrdProductSubject.Add(prdProductSubject); } } CurrentDb.SaveChanges(); ts.Complete(); result = new CustomJsonResult(ResultType.Success, ResultCode.Success, "保存成功"); } return(result); }
// GET: Wo public ActionResult Index(string userId, string counts, string companyId) { log.AppenLog("我看看22"); try { string userID = ""; string CompanyId = ""; string user_ticket = "";//成员票据,通过这个得到登陆进来的人的详情信息 #region 得到userid和公司id //当是从别的页面回来时 if (!string.IsNullOrWhiteSpace(userId)) { userID = Base64MIMA.JIE(userId); } if (!string.IsNullOrWhiteSpace(companyId)) { CompanyId = Base64MIMA.JIE(companyId); } if (userID == "") { //通过code得到userid string code1 = Request["code"]; if (code1 != "") { Tuple <bool, UserInfo> tu2 = BonusHelper.AccessTokenHelper.GetWechatUserInfo2(code1);//第三方应用 if (tu2.Item1 || Session["aaa"] != null) { if (Session["aaa"] == null) { log.AppenLog("if"); userID = tu2.Item2.UserId;//得到userid Session["aaa"] = userID; // c.Value = tu2.Item2; } else { log.AppenLog("else"); userID = Session["aaa"].ToString(); //userid = c.Value; } } try { userID = userID.Replace('"', ' '); userID = userID.Trim(); CompanyId = tu2.Item2.CorpId; user_ticket = tu2.Item2.user_ticket; } catch (Exception ex) { } } else { //code为空,跳到错误页面 return(Redirect("/ErrorPage/Index")); } } #endregion userID = "lzc"; CompanyId = "wx512ad5972960e003"; //加密公司id和userid log.AppenLog("登陆进来userid:" + userId); ViewBag.CompanyID = Base64MIMA.JIA(CompanyId); ViewBag.userID = Base64MIMA.JIA(userID); //工号 ViewBag.SuserId = userID; #region 判断公司是否在有效期 //在:看登陆进来的人是否是某个公司的负责人,如果是的话就把他的联系方式等填到相关公司表里,不是直接进入后台 //不在:提示已经过了有效期,需要联系我们来审核 string sqlstr = string.Format($"exec Proc_Wo 'IsValidComoany','{CompanyId}'"); DataTable dt_IsValidComoany = sql.GetDataTableCommand(sqlstr); if (dt_IsValidComoany?.Rows.Count > 0) { //通过user_ticket得到详细信息 string strResult = AccessTokenHelper.GetUserDetail2(user_ticket); log.AppenLog("页面成员信息:" + strResult); DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(UserDetials)); MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(strResult)); UserDetials obj = (UserDetials)ser.ReadObject(ms); //判断是否是某个公司的负责人 string sqlstr2 = string.Format($"select * from Company where CompanyPrincipal='{userID}'"); DataTable dt2 = sql.GetDataTableCommand(sqlstr2); if (dt2?.Rows.Count > 0) { //是某个公司负责人==>将他的信息放到公司列表里面去 string CompanyPhone = ""; string CompanyEmail = ""; string upCom = ""; for (int i = 0; i < dt2?.Rows.Count; i++) { if (dt2.Rows[i]["CompanyPhone"].ToString() == "" || dt2.Rows[i]["CompanyEmail"].ToString() == "") { CompanyPhone = obj.mobile; CompanyEmail = obj.email; upCom += string.Format($" update Company set CompanyPhone='{CompanyPhone}' where CompanyID={dt2.Rows[i]["CompanyID"].ToString()}"); } } if (upCom != "") { sql.EditDataCommand(upCom); } } //更新对应人的信息 try { string py = Pinyin.GetInitials(obj.name); //简拼 string pinyin = Pinyin.GetPinyin(obj.name).Replace(" ", ""); //全拼 string upEmp = string.Format($"exec Proc_Wo 'UpdateTouXiang','{obj.corpid}','{obj.userid}','{obj.avatar}','{obj.mobile}','{obj.email}','{pinyin}','{py}',{obj.gender}"); log.AppenLog("更新人员信息:" + upEmp); string info_upEmp = sql.EditDataCommand(upEmp); if (info_upEmp != "0") { return(Content("<script>alert('获取个人信息失败');history.go(-1);</script>")); } } catch (Exception ex) { } } else { //return Content("<script>alert('您的使用期限已过,请联系我们!8888888');history.go(-1);</script>"); return(Redirect("/Wo/EndIndex")); } #endregion #region 个人信息与个人奖金 string infosql = string.Format($"exec proc_Main 'SelectEmpDetialWo','{userID}','','{CompanyId}'"); DataSet info = sql.GetDataSetCommand(infosql); if (info?.Tables.Count > 0) { //个人信息 if (info?.Tables[0].Rows.Count > 0) { //是否位超级管理员 if (info.Tables[0].Rows[0]["RoleID"].ToString() == "8EA2CC5C-308D-4538-A9D8-FCAD7CA6FEB0") { ViewBag.chaoji = 1; } else { ViewBag.chaoji = 0; } ViewBag.info = info.Tables[0]; } else { ViewBag.info = null; ViewBag.chaoji = 0; } //个人奖金 if (info?.Tables[1].Rows.Count > 0) { ViewBag.SumMoney = info.Tables[1].Rows[0][0]; } else { ViewBag.SumMoney = "0.00"; } } else { ViewBag.info = null; ViewBag.chaoji = 0; } #endregion #region 部门奖金 string isDepartPri = string.Format($"exec proc_Main 'SelectDepJIangjin','{userID}','','{CompanyId}'"); DataTable dss = sql.GetDataTableCommand(isDepartPri); if (dss?.Rows.Count > 0) { ViewBag.depSumMoney = dss; } else { ViewBag.depSumMoney = null; } //string isDepartPri = string.Format("SELECT DepartID FROM dbo.Depart WHERE DepartPrincipal='{0}'", userID); // string isDepartPri = string.Format("SELECT DepartID FROM dbo.Depart WHERE DepartPrincipal='{0}' AND CompanyID='{1}'", userID, CompanyId); // DataTable dss = sql.GetDataTableCommand(isDepartPri); // if (dss.Rows.Count > 0) // { // //是部门负责人 // //ViewBag.isDepartPri = "youarePri"; // //部门奖金 // string sqlDepart = string.Format(@"SELECT DepartID,DepartName,ISNULL(EarMoney,'0.00') Earmoney,EarMan FROM dbo.Depart d LEFT JOIN //(SELECT SUM(EarMoney) EarMoney ,EarMan FROM dbo.BonusData2 WHERE BonusType=0 AND IsGet=0 GROUP BY EarMan ) // b ON d.DepartID=b.EarMan WHERE DepartPrincipal='{0}' and CompanyID='{1}'", userID, CompanyId); // DataTable DepartName = sql.GetDataTableCommand(sqlDepart); // if (DepartName.Rows.Count > 0) // { // ViewBag.depSumMoney = DepartName; // } // else // { // ViewBag.depSumMoney = null; // } // } // else // { // //ViewBag.isDepartPri = null; // } #endregion #region 奖金项 string isitp = string.Format(@"SELECT A.BonusItemID,A.BIName,RM,IM FROM ( SELECT RuleData.BonusItemID,BIName,SUM(RemainMoney)RM FROM dbo.RuleData INNER JOIN dbo.BonusItem ON BonusItem.BonusItemID = RuleData.BonusItemID WHERE RuleData.BonusItemID IN (SELECT BonusItemID FROM dbo.BonusImpower WHERE BIState=0 AND EmpID='{0}') AND CompanyID='{2}' AND GETDATE()<EndDate GROUP BY RuleData.BonusItemID,BIName) AS A LEFT JOIN (SELECT b2.BonusItemID,BIName,SUM(b1.RemainMoney) IM FROM dbo.BonusImpower b1 INNER JOIN dbo.BonusItem b2 ON b2.BonusItemID = b1.BonusItemID WHERE BIState=0 AND EmpID = '{1}' AND (ImpowerDate >= DATEADD(MM, DATEDIFF(MM, 0, GETDATE()), 0) and IsValid=0) GROUP BY b2.BonusItemID, BIName) AS B ON A.BonusItemID=B.BonusItemID AND A.BIName=B.BIName", userID, userID, CompanyId); DataTable itp = sql.GetDataTableCommand(isitp); if (itp?.Rows.Count > 0) { ViewBag.itp = itp; } else { ViewBag.itp = null; } //自己负责的奖金项 string isitem = string.Format("SELECT dbo.RuleData.BonusItemID,dbo.BonusItem.BIName,SUM(RemainMoney) AllMoney FROM dbo.RuleData INNER JOIN dbo.BonusItem ON BonusItem.BonusItemID = RuleData.BonusItemID WHERE BIState=0 AND CompanyID='{1}' AND BIPrincipal = '{0}' AND CONVERT(VARCHAR(30), GETDATE(), 102) < EndDate GROUP BY dbo.RuleData.BonusItemID, dbo.BonusItem.BIName", userID, CompanyId); DataTable item = sql.GetDataTableCommand(isitem); if (item?.Rows.Count > 0) { for (int i = 0; i < item?.Rows.Count; i++) { Session["shit" + i] = sql.GetDataTableProcedure("proc_BonusData", item.Rows[i]["BonusItemID"].ToString(), "1"); } ViewBag.item = item; } else { ViewBag.item = null; } //查自己有没有奖金发放权限 string sqlsq = string.Format($@" SELECT b2.BonusItemID, BIName, SUM(b1.RemainMoney) IM FROM dbo.BonusImpower b1 INNER JOIN dbo.BonusItem b2 ON b2.BonusItemID = b1.BonusItemID WHERE BIState = 0 AND EmpID = '{userID}' AND(ImpowerDate >= DATEADD(MM, DATEDIFF(MM, 0, GETDATE()), 0) and IsValid = 0) GROUP BY b2.BonusItemID, BIName"); DataTable dtsq = sql.GetDataTableCommand(sqlsq); ViewBag.counts = dtsq.Rows.Count + item.Rows.Count; ViewBag.count = Base64MIMA.JIA((dtsq.Rows.Count + item.Rows.Count).ToString()); #endregion InitJsapi(Base64MIMA.JIA(CompanyId)); } catch (Exception ex) { log.AppenLog("woIndex错误:" + ex.Message); return(Redirect("/ErrorPage/Index")); } return(View()); }