public JsonResult GetServiceNameByServiceId(string serviceId)
{
NuomiServiceManager manager = new NuomiServiceManager();
var result = manager.GetServiceNameByServiceId(serviceId.Trim());
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult AddNuomiServiceConfig(string nuomiTitle, long nuomiId, string serviceId, string userEmail, string remarks)
{
NuomiServiceManager manager = new NuomiServiceManager();
var user = HttpContext.User.Identity.Name;
var result = manager.AddNuomiServiceConfig(nuomiTitle.Trim(), nuomiId, serviceId.Trim(), userEmail.Trim(), remarks.Trim(), user);
return(Json(new { status = result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _NuomiServiceConfigList(string nuomiTitle, long nuomiId, string serviceId, int isValid, int pageIndex = 1, int pageSize = 20)
{
NuomiServiceManager manager = new NuomiServiceManager();
var result = manager.GetNuomiServicesConfig(nuomiTitle.Trim(), nuomiId, serviceId.Trim(), isValid, pageIndex, pageSize);
ViewBag.TotalCount = (result != null && result.Any()) ? result.FirstOrDefault().Total : 0;
return(View(result));
}
public JsonResult BatchSoleteConfig(string pkidStr)
{
var result = false;
NuomiServiceManager manager = new NuomiServiceManager();
if (!string.IsNullOrEmpty(pkidStr))
{
result = manager.BatchSoleteConfig(pkidStr, HttpContext.User.Identity.Name);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult DelNuomiServiceConfig(int pkid)
{
NuomiServiceManager manager = new NuomiServiceManager();
var user = HttpContext.User.Identity.Name;
var result = manager.DelNuomiServiceConfig(pkid, user);
if (result)
{
return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult EditNuomiServiceConfig(int pkid, string nuomiTitle, long nuomiId, string serviceId, string userEmail, string remarks)
{
NuomiServiceManager manager = new NuomiServiceManager();
var user = HttpContext.User.Identity.Name;
var result = manager.EditNuomiServiceConfig(pkid, nuomiTitle.Trim(), nuomiId, serviceId.Trim(), userEmail.Trim(), remarks.Trim(), user);
if (result)
{
return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult BatchInsertNuomiConfig(string nuomiInfo)
{
var result = false;
NuomiServiceManager manager = new NuomiServiceManager();
if (!string.IsNullOrEmpty(nuomiInfo))
{
var data = JsonConvert.DeserializeObject <List <NuomiServicesConfig> >(nuomiInfo);
if (data != null && data.Any())
{
result = manager.BatchInsertNuomiConfig(data, HttpContext.User.Identity.Name);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult UploadFile()
{
var success = new List <NuomiServicesConfig>();
var error = new List <NuomiServicesConfig>();
var msg = string.Empty;
var userEmail = ConfigurationManager.AppSettings["NuomiUserEmail"].ToString();
NuomiServiceManager manager = new NuomiServiceManager();
var data = new List <NuomiServicesConfig>();
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
DataTable dataTable = null;
string fileExtension = Path.GetExtension(file.FileName); // 文件扩展名
bool isxlsx = fileExtension.Equals(".xlsx");
bool isxls = fileExtension.Equals(".xls");
if (file != null && (isxls || isxlsx))
{
using (Stream writer = file.InputStream)
{
if (isxlsx)
{
dataTable = RenderDataTableForXLSX(writer, 0);
}
if (isxls)
{
dataTable = RenderDataTableForXLS(writer, 0);
}
}
data = ConvertList(dataTable, userEmail);
var allServices = NuomiServiceManager.GetAllShopServices();
var verifyData = manager.VerifyData(data, allServices);
success = verifyData.Item1;
error = verifyData.Item2;
}
else
{
msg = "文件为空或是文件上传格式不正确";
}
}
return(Json(new { SuccessData = success, ErrorData = error, msg = msg }, JsonRequestBehavior.AllowGet));
}