/// <summary>
///
/// </summary>
/// <returns>dic
/// <remarks>key:拼音字母头</remarks>
/// <remarks>value:内容</remarks>
/// </returns>
public IDictionary <string, IList <SystemUser> > GetList()
{
IList <SystemUser> list = _db.GetList <SystemUser>().ToList();
var dic = new Dictionary <string, IList <SystemUser> >();
foreach (var item in list)
{
IList <SystemUser> temp = new List <SystemUser>();
//拼音
var firstLetter = PinYinHelper.MakeSpellCode(item.Name, SpellOptions.FirstLetterOnly).Substring(0, 1);
if (dic.Keys.Contains(firstLetter))
{
dic[firstLetter].Add(item);
}
else
{
temp.Add(item);
dic.Add(firstLetter, temp);
}
}
//排序
dic = dic.OrderBy(d => d.Key).ToDictionary(d => d.Key, d => d.Value);
return(dic);
}
private string getInfos()
{
string sort = Request.Form["sort"];
string order = Request.Form["order"];
string keyword = Request.Form["keyword"];
int year = Convert.ToInt32(Request.Form["year"]);
int month = Convert.ToInt32(Request.Form["month"]);
string res = "F";
UserInfo user = (UserInfo)Session["user"];
if (user != null)
{
DataSet ds = ReimbursementManage.GetInfos(user.userName, keyword, year, month);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = PinYinHelper.SortByPinYin(ds.Tables[0], sort, order);
foreach (DataRow dr in dt.Rows)
{
dr["remark"] = SqlHelper.DesDecrypt(dr["remark"].ToString());
}
res = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt);
}
}
return(res.Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", ""));
}
public static string GetSearched(string searchStr)
{
DataSet ds = RightSrv.GetDptsAndUsers();
if (ds != null && ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("value", Type.GetType("System.String"));
dt.Columns.Add("text", Type.GetType("System.String"));
foreach (DataRow row in ds.Tables[0].Rows)
{
if (PinYinHelper.IsEqual(row[1].ToString(), searchStr) ||
row[1].ToString().Trim().Contains(searchStr)
)
{
dt.Rows.Add(row[0], row[1]);
}
}
foreach (DataRow row in ds.Tables[1].Rows)
{
if (PinYinHelper.IsEqual(row[1].ToString(), searchStr) ||
row[1].ToString().Trim().Contains(searchStr)
)
{
dt.Rows.Add(row[0], row[1]);
}
}
return(JsonHelper.DataTable2Json(dt));
}
return("");
}
private string getDatalist()
{
string res = "";
UserInfo user = (UserInfo)Session["user"];
DataTable dt = NetSalesInfoManage.getInfos(user.userId.ToString());
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, "Hospital", "asc");
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("group", row["Hospital"].ToString());
dict.Add("item", row["Product"].ToString());
dict.Add("id", row["Id"].ToString());
dict.Add("status", row["State"].ToString());
dict.Add("docCode", row["DocCode"].ToString());
dict.Add("time", row["CorrespondingTime"].ToString());
list.Add(dict);
}
res = JsonHelper.SerializeObject(list);
}
return(res);
}
protected string getInfo()
{
string sort = Request.Form["sort"];
string order = Request.Form["order"];
string keyword = Request.Form["keyword"];
string year = Request.Form["year"];
int month = Convert.ToInt32(Request.Form["month"]);
string res = "F";
UserInfo user = (UserInfo)Session["user"];
if (user != null)
{
DataTable dt = MobileReimburseManage.findApprovalRecord(user, keyword, year, month);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
dr["remark"] = SqlHelper.DesDecrypt(dr["remark"].ToString());
}
dt = PinYinHelper.SortByPinYin(dt, sort, order);
res = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt);
}
}
return(res.Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", ""));
}
public static DataTable GetData(string searchString)
{
DataSet ds = OrganizationInfoSrv.GetData();
DataTable dt = null;
if (ds != null)
{
if (string.IsNullOrEmpty(searchString))//搜索字符为空时，不搜索，直接返回
{
return(ds.Tables[0]);
}
dt = ds.Tables[0].Clone();
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row["code"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["name"].ToString(), searchString) ||
PinYinHelper.IsEqual(row["fullName"].ToString(), searchString) ||
row["name"].ToString().Trim().Contains(searchString) ||
row["fullName"].ToString().Trim().Contains(searchString))
{
dt.Rows.Add(row.ItemArray);
continue;
}
}
}
return(dt);
}
private void FindTarget()
{
string name = Request.Form["name"];
string json = "";
string sql = "select distinct wechatUserId,userName from users where isValid='在职' ORDER BY userName DESC";
DataSet ds = SqlHelper.Find(sql);
if (ds != null)
{
DataTable dt = new DataTable();
dt.Columns.Add("value", Type.GetType("System.String"));
dt.Columns.Add("target", Type.GetType("System.String"));
int i = 0;
foreach (DataRow row in ds.Tables[0].Rows)
{
if (PinYinHelper.IsEqual(row["userName"].ToString(), name) ||
row["userName"].ToString().Trim().Contains(name)
)
{
dt.Rows.Add(row["wechatUserId"], row["userName"]);
}
}
json = JsonHelper.DataTable2Json(dt);
}
Response.Write(json);
}
private string GetUsers()
{
string searchStr = Request.Form["searchStr"];
string sql = "select distinct userName from users where isValid='在职'";
DataSet ds = SqlHelper.Find(sql);
if (ds == null && ds.Tables[0].Rows.Count == 0)
{
return("");
}
DataTable dt = new DataTable();
dt.Columns.Add("value", Type.GetType("System.String"));
dt.Columns.Add("text", Type.GetType("System.String"));
foreach (DataRow row in ds.Tables[0].Rows)
{
if (PinYinHelper.IsEqual(row[0].ToString(), searchStr) ||
row[0].ToString().Trim().Contains(searchStr)
)
{
dt.Rows.Add(row[0], row[0]);
}
}
return(JsonHelper.DataTable2Json(dt));
}
private string getDataList()
{
int year = Int32.Parse(Request.Form["year"]);
int month = Int32.Parse(Request.Form["month"]);
string sort = Request.Form["sort"];
string order = Request.Form["order"];
string searchString = Request.Form["searchString"];
string hospital = Request.Form["hospital"];
string product = Request.Form["product"];
string json = "";
DataTable dt = FlowInfoManage.GetMobileInfos(year, month, searchString, hospital, product);
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, sort, order);
json = JsonHelper.DataTable2Json(dt);
}
//JObject res = new JObject();
//res.Add("DataIsArchived", DataIsArchived);
//res["Data"] = JsonHelper.DeserializeJsonToObject<JObject>(json);
//res.Add("Data", JsonHelper.DeserializeJsonToObject<object>(json));
//Dictionary<string, object> resDict = new Dictionary<string, object>();
//resDict.Add("DataIsArchived", DataIsArchived);
//resDict.Add("Data", json);
//json = JsonHelper.SerializeObject(resDict);
return(json.ToString());
}
public void transformCb(string word)
{
/*
* 筛选出中文
*/
Regex reg = new Regex("[\u4e00-\u9fa5]+");
string dealText = "";
foreach (Match v in reg.Matches(word))
{
dealText = dealText + v;
}
char[] arr = dealText.ToCharArray();
string[] aimTextArr = new string[arr.Length];
string[] aimTextPingYingArr = new string[arr.Length];
for (int z = 0; z < arr.Length; z++)
{
aimTextArr[z] = arr[z].ToString();
}
for (int z = 0; z < arr.Length; z++)
{
aimTextPingYingArr[z] = PinYinHelper.ConvertToAllSpell(arr[z].ToString());
}
textArr = aimTextArr;
textPingYinArr = aimTextPingYingArr;
strText = word;
AudioEditManagercs.Instance.TransformAudioPartToWordCallBack();
}
private string getInfos()
{
string date = Request.Form["date"];
string sort = Request.Form["sort"];
string order = Request.Form["order"];
string json = "";
bool DataIsArchived = false;
DataSet ds = FlowInfoManage.GetInfos(date, ref DataIsArchived);
if (ds != null)
{
DataTable dt = PinYinHelper.SortByPinYin(ds.Tables[0], sort, order);
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt, ds.Tables[1]);
}
JObject res = new JObject();
res.Add("DataIsArchived", DataIsArchived);
res["Data"] = JsonHelper.DeserializeJsonToObject <JObject>(json);
//res.Add("Data", JsonHelper.DeserializeJsonToObject<object>(json));
//Dictionary<string, object> resDict = new Dictionary<string, object>();
//resDict.Add("DataIsArchived", DataIsArchived);
//resDict.Add("Data", json);
//json = JsonHelper.SerializeObject(resDict);
return(res.ToString());
}
public JsonResult Upload()
{
var Request = HttpContext.Current.Request;
var Server = HttpContext.Current.Server;
// 文件信息
var file = Request.Files[0];
var fileName = file.FileName;
var fileSize = file.ContentLength;
var fileType = file.ContentType;
var fileExt = Path.GetExtension(fileName);
var fileNameWithoutExt = Path.GetFileNameWithoutExtension(fileName);
// 上传文件
var now = DateTime.Now;
var savePath = $"/Upload/File/{now.ToString("yyyyMMddHHmmss")}";
var physicalPath = Server.MapPath(savePath);
if (!Directory.Exists(physicalPath))
{
Directory.CreateDirectory(physicalPath);
}
file.SaveAs($"{physicalPath}\\{fileName}");
// 保存Mongo
var pinyin = PinYinHelper.GetTotalPinYin(fileNameWithoutExt);
var mongo = new MongoHelper();
var doc = new BsonDocument();
doc["AddTime"] = BsonDateTime.Create(now);
doc["FileName"] = fileName;
doc["FileSize"] = fileSize;
doc["FileType"] = fileType;
doc["FirstPinYin"] = string.Join("", pinyin.FirstPinYin);
doc["Name"] = fileNameWithoutExt;
doc["SaveName"] = fileName;
doc["SavePath"] = savePath;
doc["Thumbnail"] = "";
doc["TotalPinYin"] = string.Join("", pinyin.TotalPinYin);
doc["Url"] = $"{savePath}/{fileName}";
mongo.InsertOne(Constant.FileCollectionName, doc);
return(Json(new
{
Code = 200,
Msg = "上传成功！",
Data = new
{
fileName = fileName,
fileSize = fileSize,
fileType = fileType,
url = $"{savePath}/{fileName}"
}
}));
}
protected string getCenterDataList()
{
int year = Int32.Parse(Request.Form["year"]);
int month = Int32.Parse(Request.Form["month"]);
string dateStr = Request.Form["dateStr"];
string sort = Request.Form["sort"];
string order = Request.Form["order"];
// 读取数据
DataTable dt = SalesReportManage.getCenterData(year, month, dateStr);
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, sort, order);
DataTable footDataTable = generateFooterTable(dt, "Sector");
string json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt, footDataTable);
return(json);
}
else
{
return("error");
}
}
public static DataTable findProductName(string name, string userId)
{
DataSet ds = DemandApplyReportSrv.findProductName(name, userId);
if (ds == null)
{
return(null);
}
DataTable dt = new DataTable();
dt.Columns.Add("value", Type.GetType("System.String"));
dt.Columns.Add("target", Type.GetType("System.String"));
int index = 0;
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
DataRow dr = dt.NewRow();
dr["value"] = row["name"];
dr["target"] = row["name"];
dt.Rows.Add(dr);
}
}
else
{
ds = DemandApplyReportSrv.findProductName(userId);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
foreach (DataRow row in ds.Tables[0].Rows)
{
if (index >= 5)
{
break;
}
if (PinYinHelper.ContainsFirstLetter(row["name"].ToString(), name))
{
DataRow dr = dt.NewRow();
dr["value"] = row["name"];
dr["target"] = row["name"];
dt.Rows.Add(dr);
index++;
}
}
}
return(dt);
}
public void TestGetPinyin_1()
{
Encoding encoding = Encoding.GetEncoding("gb2312");
var result = PinYinHelper.GetPinyin(ConvertEncoding("周王", Encoding.UTF8, encoding), encoding);
Assert.AreEqual("zhou wang", result);
Assert.AreEqual(ConvertEncoding("zhou wang", Encoding.UTF8, encoding), result);
}
public void TestGetInitials_1()
{
Encoding encoding = Encoding.GetEncoding("gb2312");
var result = PinYinHelper.GetInitials(ConvertEncoding("周王", Encoding.UTF8, encoding), encoding);
Assert.AreEqual("ZW", result);
Assert.AreEqual(ConvertEncoding("ZW", Encoding.UTF8, encoding), result);
}
public void PinYinTest()
{
string origin = "苟利国家生死以，岂因祸福避趋之, hello thank you,你好//";
string actual = PinYinHelper.GetPinyin(origin);
string expected = "gouliguojiashengsiyi，qiyinhuofubiquzhi, hello thank you,nihao//";
Assert.AreEqual(expected, actual);
}
private void Getdata2()
{
string date1 = Session["date1"].ToString();
string date2 = Session["date2"].ToString();
int pagenumber = Convert.ToInt32(Session["pagenumber2"]);
int pagesize = Convert.ToInt32(Session["pagesize2"]);
int begin = (pagenumber - 1) * pagesize - 1;
if (begin == -1)
{
begin = 0;
}
DateTime date3 = Convert.ToDateTime(date1);
DateTime date4 = Convert.ToDateTime(date2);
string name = Session["name"].ToString();
string sort = "";
string order = "";
if (Session["sort2"] == null)
{
sort = "EffectiveTime";
order = "desc";
}
else
{
sort = Session["sort2"].ToString();
order = Session["order2"].ToString();
}
string sql = string.Format("select * from accumulate_points where CheckState in('已审核','已拒绝') and EffectiveTime between '{0}-{1}-{2}' and '{3}-{4}-{5}'"
, date3.Year, date3.Month, date3.Day, date4.Year, date4.Month, date4.Day);
string sql2 = "";
if (name != "")
{
sql2 += "and Target in('";
string sql1 = "select distinct userName from v_user_department_post";
DataSet ds1 = SqlHelper.Find(sql1);
foreach (DataRow row in ds1.Tables[0].Rows)
{
if (PinYinHelper.IsEqual(row["userName"].ToString(), name) ||
row["userName"].ToString().Trim().Contains(name)
)
{
sql2 += row["userName"] + "','";
}
}
sql2 = sql2.Substring(0, sql2.Length - 2);
sql2 += ")";
}
sql += sql2 + "order by " + sort + " " + order + " " + string.Format("limit {0},{1};select count(*) from " +
"accumulate_points where CheckState='已审核' and EffectiveTime between '{2}-{3}-{4}' and '{5}-{6}-{7}'"
, begin, pagesize, date3.Year, date3.Month, date3.Day, date4.Year, date4.Month, date4.Day) + sql2;
DataSet ds = SqlHelper.Find(sql);
Object ob = new { total = ds.Tables[1].Rows[0][0], rows = ds.Tables[0] };
string json = JsonHelper.SerializeObject(ob);
Response.Write(json);
}
private void but_Add_Click(object sender, EventArgs e)
{
try
{
if (TB_Name.Text != "" && TB_sl.Text.Trim() != "" && TB_Num.Text.Trim() != "" && TB_ZDXF.Text.Trim() != "")
{
string str_sqll = "select count(*) from tb_DeskType where DT_type='" + TB_Name.Text.Trim() + "'";
int a = db.YZSql(str_sqll);
if (a > 0)
{
MessageBox.Show("此桌台类型存在");
TB_ID.Text = "";
TB_Name.Text = "";
TB_sl.Text = "0";
TB_Num.Text = "0";
TB_ZDXF.Text = "0";
}
else
{
//string s="";
//for(int i=0;i<TB_ID.Text.Length;i++)
//{
// string n=TB_ID.Text.Substring(i,1);
// string f="";
//}
//插入桌台类型
string str_sql = "insert into tb_DeskType values('" + TB_Name.Text.Trim() + "','" + TB_Num.Text.Trim() + "','" + TB_sl.Text.Trim() + "','" + TB_ZDXF.Text.Trim() + "')";
if (db.ExecSQl(str_sql))
{
bool fa = false;
//查询桌台类型编号
str_sql = "select Id from tb_DeskType where DT_type='" + TB_Name.Text.Trim() + "'";
int bh = Convert.ToInt32(db.GetDataFromSQL(str_sql).Tables[0].Rows[0][0].ToString().Trim());
//获取桌台类型的首字母
string py = PinYinHelper.GetFirstPinyin(TB_Name.Text.Trim());
//插入桌台
for (int i = 0; i < Convert.ToInt32(TB_sl.Text.Trim()); i++)
{
str_sql = "insert into tb_Desk values('" + py.Substring(0, 1).ToString().Trim() + (i + 1) + "','" + bh + "','" + "可用" + "')";
fa = db.ExecSQl(str_sql);
}
if (fa)
{
MessageBox.Show("添加成功");
Frm_Zttype_Load(sender, e);
}
}
}
}
else
{
MessageBox.Show("请填写完整");
}
}
catch { }
}
public JsonResult Edit(AnimationEditModel model)
{
var objectId = ObjectId.GenerateNewId();
if (!string.IsNullOrEmpty(model.ID) && !ObjectId.TryParse(model.ID, out objectId))
{
return(Json(new
{
Code = 300,
Msg = "ID is not allowed."
}));
}
if (string.IsNullOrEmpty(model.Name))
{
return(Json(new
{
Code = 300,
Msg = "Name is not allowed to be empty."
}));
}
var mongo = new MongoHelper();
var pinyin = PinYinHelper.GetTotalPinYin(model.Name);
var filter = Builders <BsonDocument> .Filter.Eq("_id", objectId);
var update1 = Builders <BsonDocument> .Update.Set("Name", model.Name);
var update2 = Builders <BsonDocument> .Update.Set("TotalPinYin", pinyin.TotalPinYin);
var update3 = Builders <BsonDocument> .Update.Set("FirstPinYin", pinyin.FirstPinYin);
var update4 = Builders <BsonDocument> .Update.Set("Thumbnail", model.Image);
UpdateDefinition <BsonDocument> update5;
if (string.IsNullOrEmpty(model.Category))
{
update5 = Builders <BsonDocument> .Update.Unset("Category");
}
else
{
update5 = Builders <BsonDocument> .Update.Set("Category", model.Category);
}
var update = Builders <BsonDocument> .Update.Combine(update1, update2, update3, update4, update5);
mongo.UpdateOne(Constant.AnimationCollectionName, filter, update);
return(Json(new
{
Code = 200,
Msg = "Saved successfully!"
}));
}
public JsonResult Edit(PrefabEditModel model)
{
var objectId = ObjectId.GenerateNewId();
if (!string.IsNullOrEmpty(model.ID) && !ObjectId.TryParse(model.ID, out objectId))
{
return(Json(new
{
Code = 300,
Msg = "ID不合法。"
}));
}
if (string.IsNullOrEmpty(model.Name))
{
return(Json(new
{
Code = 300,
Msg = "名称不允许为空。"
}));
}
var mongo = new MongoHelper();
var pinyin = PinYinHelper.GetTotalPinYin(model.Name);
var filter = Builders <BsonDocument> .Filter.Eq("ID", objectId);
var update1 = Builders <BsonDocument> .Update.Set("Name", model.Name);
var update2 = Builders <BsonDocument> .Update.Set("TotalPinYin", pinyin.TotalPinYin);
var update3 = Builders <BsonDocument> .Update.Set("FirstPinYin", pinyin.FirstPinYin);
var update4 = Builders <BsonDocument> .Update.Set("Thumbnail", model.Thumbnail);
UpdateDefinition <BsonDocument> update5;
if (string.IsNullOrEmpty(model.Category))
{
update5 = Builders <BsonDocument> .Update.Unset("Category");
}
else
{
update5 = Builders <BsonDocument> .Update.Set("Category", model.Category);
}
var update = Builders <BsonDocument> .Update.Combine(update1, update2, update3, update4, update5);
mongo.UpdateOne(Constant.PrefabCollectionName, filter, update);
return(Json(new
{
Code = 200,
Msg = "保存成功！"
}));
}
protected string dataGridSort()
{
string data = Request.Form["data"];
string sort = Request.Form["sort"];
string order = Request.Form["order"];
DataTable dt = JsonHelper.DeserializeJsonToObject <DataTable>(data);
dt = PinYinHelper.SortByPinYin(dt, sort, order);
return(JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt));
}
/*
* 将中文字符串转化成拼音数组
* 参数:
* a:中文字符串
* 返回
* 逐子拼音数组
*/
public static string[] GetPingYingArrayFromChinaString(string a)
{
char[] arr = a.ToCharArray();
string[] back = new string[arr.Length];
for (int i = 0; i < arr.Length; ++i)
{
back[i] = PinYinHelper.ConvertToAllSpell(arr[i].ToString());
}
return(back);
}
public JsonResult Edit(EditSceneModel model)
{
var objectId = ObjectId.GenerateNewId();
if (!string.IsNullOrEmpty(model.ID) && !ObjectId.TryParse(model.ID, out objectId))
{
return(Json(new
{
Code = 300,
Msg = "ID不合法。"
}));
}
if (string.IsNullOrEmpty(model.Name))
{
return(Json(new
{
Code = 300,
Msg = "名称不允许为空。"
}));
}
if (model.Name.StartsWith("_"))
{
return(Json(new
{
Code = 300,
Msg = "名称不允许以下划线开头。"
}));
}
var mongo = new MongoHelper();
var pinyin = PinYinHelper.GetTotalPinYin(model.Name);
var filter = Builders <BsonDocument> .Filter.Eq("ID", objectId);
var update1 = Builders <BsonDocument> .Update.Set("Name", model.Name);
var update2 = Builders <BsonDocument> .Update.Set("TotalPinYin", pinyin.TotalPinYin);
var update3 = Builders <BsonDocument> .Update.Set("FirstPinYin", pinyin.FirstPinYin);
var update4 = Builders <BsonDocument> .Update.Set("Thumbnail", model.Image);
var update = Builders <BsonDocument> .Update.Combine(update1, update2, update3, update4);
mongo.UpdateOne(Constant.SceneCollectionName, filter, update);
return(Json(new
{
Code = 200,
Msg = "保存成功！"
}));
}
private void txtTitleSave_Leave(object sender, EventArgs e)
{
try
{
txtChar.Text = PinYinHelper.GetPinYin(txtTitleSave.Text);
}
catch
{
txtChar.Text = txtTitleSave.Text;
}
}
public IActionResult Hanzi2Pinyin(string name)
{
string pinyin = "";
if (!string.IsNullOrEmpty(name))
{
pinyin = PinYinHelper.GetPinyin(name).ToLower().Replace(" ", "-");
}
tip.Status = JsonTip.SUCCESS;
tip.Message = pinyin;
return(Json(tip));
}
private string getInfos()
{
string json = "";
string sort = Request.Form["sort"];
string order = Request.Form["order"];
DataTable dt = SalesTaskInfoManage.getInfos();
dt = PinYinHelper.SortByPinYin(dt, sort, order);
if (dt != null)
{
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt).Trim();
}
return(json);
}
public JsonResult ConvertToPinYin(string value)
{
var result = new JsonResultModel <string> {
ResultState = true
};
if (string.IsNullOrEmpty(value))
{
return(Json(result));
}
value = Server.UrlDecode(value);
result.Body = PinYinHelper.ConvertToPinYin(value);
return(Json(result, JsonRequestBehavior.AllowGet));
}
private static Boolean checkUserOrDepartmentEqual(DataRow row, string searchString)
{
return(PinYinHelper.IsEqual(row["Department"].ToString(), searchString) ||
row["Department"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["Sector"].ToString(), searchString) ||
row["Sector"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["Sales"].ToString(), searchString) ||
row["Sales"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["Supervisor"].ToString(), searchString) ||
row["Supervisor"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["Manager"].ToString(), searchString) ||
row["Manager"].ToString().Trim().Contains(searchString) ||
PinYinHelper.IsEqual(row["Director"].ToString(), searchString) ||
row["Director"].ToString().Trim().Contains(searchString));
}
/*加载数据列表*/
private String getDataList()
{
UserInfo user = (UserInfo)Session["user"];
String type = Request.Params["type"];
DataTable dt = null;
String res = "";
// 查询我提交的
if ("mine".Equals(type))
{
dt = NetSalesApprovalInfoManage.getListOfCommitBySelf(user.userName);
}
else // 查询待我审批的
{
dt = NetSalesApprovalInfoManage.getListOfCommitByOthers(user.userId.ToString());
}
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, "Hospital", "asc");
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("group", row["Hospital"].ToString());
dict.Add("item", row["Product"].ToString());
dict.Add("NetSalesNum", row["NetSalesNumber"].ToString());
dict.Add("sales", user.userName);
// 查询流向数据
string flowNumStr = NetSalesInfoManage.getFlowNumOfReportSales(row["Hospital"].ToString(),
row["Product"].ToString(), user.userName);
if (StringTools.IsInt(flowNumStr))
{
dict.Add("flowNum", flowNumStr);
}
else//返回错误信息
{
dict.Add("flowNum", "0");
}
list.Add(dict);
}
res = JsonHelper.SerializeObject(list);
}
return(res);
}
