private string Edit() { string res = "更新失败!"; DataSet ds = SqlHelper.GetFiledNameAndComment("cost_sharing"); string[] specils = new string[] { "Hospital", "Product", "Sales", "Supervisor", "Manager", "Director" }; if (ds != null) { Dictionary <string, string> dict = new Dictionary <string, string>(); foreach (DataRow row in ds.Tables[0].Rows) { string field = row["field"].ToString(); if (field == "Id") { continue; } string value = ""; if (specils.Contains(field)) { value = Request.Form[field.Substring(0, field.Length - 2)]; if (string.IsNullOrEmpty(value)) { continue; } string[] strs = value.Split(','); if (strs.Length != 2) { continue; } value = strs[1]; } else if (field == "DepartmentId" || field == "SectorId") { value = Request.Form[field.Substring(0, field.Length - 2)]; if (string.IsNullOrEmpty(value)) { continue; } } else { value = Request.Form[field]; if (string.IsNullOrEmpty(value)) { continue; } } dict.Add(field, value); } string id = Request.Form["Id"]; res = CostSharingInfoManage.UpdateInfos(VerifyDict(dict), id); } return(res); }
private string uploadFile() { string res = "读取文件失败!"; DataTable dt = ExcelHelperV2_0.Import(Request); if (dt != null) { res = CostSharingInfoManage.InsertInfos(dt); } return(res); }
private string getInfos() { string json = ""; string searchString = Request.Form["searchString"]; string sort = Request.Form["sort"]; string order = Request.Form["order"]; DataTable dt = CostSharingInfoManage.getInfos(searchString); dt = PinYinHelper.SortByPinYin(dt, sort, order); if (dt != null) { json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt).Trim(); } return(json); }
private string Import() { string res = "F"; string json = Request.Form["json"]; string index = Request.Form["index"]; Dictionary <string, string> dict = JsonHelper.DeserializeJsonToObject <Dictionary <string, string> >(json); if (!dict["状态"].Contains("已导入")) { dict = CostSharingInfoManage.NewImportInfos(dict, index); } //dict = CostSharingInfoManage.ImportInfos(dict); res = JsonHelper.SerializeObject(dict); return(res); }
private string ShowFile() { string res = "F"; DataTable dt = CostSharingInfoManage.importCostSharing(Request, true); if (dt != null) { dt.Columns.Add("状态"); dt.Columns["状态"].SetOrdinal(0);//调整到第一列 for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["状态"] = "导入失败"; } res = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt); } return(res); }