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