private string uploadFile()
{
string res = "读取文件失败！";
DataTable dt = ExcelHelperV2_0.Import(Request);
if (dt != null)
{
res = CostSharingInfoManage.InsertInfos(dt);
}
return(res);
}
private string Add()
{
string res = "添加失败！";
DataSet ds = SqlHelper.GetFiledNameAndComment("cost_sharing");
string[] specils = new string[] { "HospitalId", "ProductId", "SalesId", "SupervisorId", "ManagerId", "DirectorId" };
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);
}
res = CostSharingInfoManage.InsertInfos(VerifyDict(dict));
}
return(res);
}
