/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//仓库名称、仓库归属、仓库属性、仓库区域、仓库地址、管理员、联系方式。
//StorageName,ProcessFactoryName,StorageAttributeText,AreaCode,StorageAdd,UserName,Tel
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "StorageName", "仓库名称" },
{ "ProcessFactoryName", "仓库归属" },
{ "StorageAttributeText", "仓库属性" },
{ "AreaCode", "仓库区域" },
{ "StorageAdd", "仓库地址" },
{ "UserName", "管理员" },
{ "Tel", "联系方式" },
};
var request = JsonEx.JsonToObj <StorageRequest>(jsonData);
var data = _storage.GetExportList(request);
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "仓库管理", "");
return(File(fileStream, "application/vnd.ms-excel", "仓库管理.xls"));
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//原材料编号、原材料名称、规格型号、钢筋类型、单位、单位重量、备注
//MaterialCode,MaterialName,SpecificationModel,RebarTypeNew,MeasurementUnitNew,MeasurementUnitZl,Remarks
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "MaterialCode", "原材料编号" },
{ "MaterialName", "原材料名称" },
{ "SpecificationModel", "规格型号" },
{ "RebarTypeNew", "钢筋类型" },
{ "MeasurementUnitNew", "单位" },
{ "MeasurementUnitZl", "单位重量" },
{ "Remarks", "备注" },
};
var request = JsonEx.JsonToObj <RawMarchivesRequest>(jsonData);
var data = _rawArchivesImp.GetExportList(request);
string hzzfc = "";
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "原材料档案", hzzfc);
return(File(fileStream, "application/vnd.ms-excel", "原材料档案.xls"));
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//盘点单编号、加工厂名称、盘点日期、仓库类型、账存总量（吨）、盘盈/盘亏（吨）,备注
//TakNum,FactoryName,TakDay,WarehouseTypeName,TotalInventory,TotalEarnOrLos,Remarks
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "TakNum", "盘点单编号" },
{ "FactoryName", "加工厂名称" },
{ "TakDay", "盘点日期" },
{ "WarehouseTypeName", "仓库类型" },
{ "TotalInventory", "账存总量（吨）" },
{ "TotalEarnOrLos", "盘盈/盘亏（吨）" },
{ "Remarks", "备注" },
};
var request = JsonEx.JsonToObj <StockTakingRequest>(jsonData);
var data = _StockTaking.GetExportList(request);
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "材料库存盘点", "");
return(File(fileStream, "application/vnd.ms-excel", "材料库存盘点.xls"));
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//检查编号、加工厂名称、检查类型、参与人员、检查人、检查时间、问题描述
//SafeCheckCode,ProcessFactoryName,CheckTypeName,PartInUsers,CheckUserName,CheckTime,Remark
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "SafeCheckCode", "检查编号" },
{ "ProcessFactoryName", "加工厂名称" },
{ "CheckTypeName", "检查类型" },
{ "PartInUsers", "参与人员" },
{ "CheckUserName", "检查人" },
{ "CheckTime", "检查时间" },
{ "Remark", "问题描述" },
};
var request = JsonEx.JsonToObj <SafeCheckRequest>(jsonData);
var data = _safeCheck.GetExportList(request);
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "安全检查", "");
return(File(fileStream, "application/vnd.ms-excel", "安全检查.xls"));
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//车辆编号、车牌号、行驶证号、车辆型号、车辆使用状态、所属单位、所属加工厂
//CarCode,CarCph,DrivingLicenseNum,CarXh,CarStartName,SupplierName,ProcessFactoryName
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "CarCode", "车辆编号" },
{ "CarCph", "车牌号" },
{ "DrivingLicenseNum", "行驶证号" },
{ "CarXh", "车辆型号" },
{ "CarStartName", "车辆使用状态" },
{ "SupplierName", "所属单位" },
{ "ProcessFactoryName", "所属加工厂" },
};
var request = JsonEx.JsonToObj <CarInfoRequest>(jsonData);
var data = _carInfo.GetExportList(request);
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "车辆信息管理", "");
return(File(fileStream, "application/vnd.ms-excel", "车辆信息管理.xls"));
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
var request = JsonEx.JsonToObj <SampleOrderRequest>(jsonData);
request.IsOutPut = true;
var ret = _sampleOrder.GetDataListForPage(request);
decimal hj = 0;
var data = (DataTable)ret.rows;
if (data.Rows.Count > 0)
{
hj = Convert.ToDecimal(data.Compute("sum(WeightSum)", "true"));
}
string hzzfc = "总量合计:" + hj + "(kg)";
List <SampleOrderExcel> dataList = ModelConvertHelper <SampleOrderExcel> .ToList(data);
var fileStream = ExcelHelper.EntityListToExcelStream <SampleOrderExcel>(dataList, "原材料取样订单", hzzfc);
return(File(fileStream, "application/vnd.ms-excel", "原材料取样订单.xls"));
}
public ActionResult SubmitForm(string model, string type)
{
try
{
var inOrderModel = JsonEx.JsonToObj <TbEarlyWarningSetUp>(model);
if (type == "add")
{
var data = _earlyWarningNews.Insert(inOrderModel);
return(Content(data.ToJson()));
}
else
{
var data = _earlyWarningNews.Update(inOrderModel);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public object Get(string key)
{
try
{
dynamic value = _client.Get(key);
if (value == null)
{
return(null);
}
value = value.ToString();
return(JsonEx.Deserialize(value));
}
catch (Exception ex)
{
//exception should be logged
return(null);
}
}
async Task UpdateReportedPropertiesWhenTwinStoreHasTwinAsync(string id, TwinCollection reported, bool cloudVerified)
{
using (await this.twinLock.LockAsync())
{
IEntityStore <string, TwinInfo> twinStore = this.TwinStore.Expect(() => new InvalidOperationException("Missing twin store"));
await twinStore.Update(
id,
u =>
{
string mergedJson = JsonEx.Merge(u.Twin.Properties.Reported, reported, /*treatNullAsDelete*/ true);
var mergedProperty = new TwinCollection(mergedJson);
if (!cloudVerified)
{
ValidateTwinCollectionSize(mergedProperty);
}
u.Twin.Properties.Reported = mergedProperty;
Events.UpdatedCachedReportedProperties(id, u.Twin.Properties.Reported.Version, cloudVerified);
return(u);
});
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
var request = JsonEx.JsonToObj <FPiCiXQPlan>(jsonData);
request.IsOutPut = true;
var ret = _fbnpBus.GetAllOrBySearch(request);
decimal zzl = 0;
var data = (DataTable)ret.rows;
if (data.Rows.Count > 0)
{
zzl = Convert.ToDecimal(data.Compute("sum(BatchPlanTotal)", "true"));
}
string hzzfc = "合计总量(KG):" + zzl;
List <FactoryBatchNeedPlanExcel> dataList = ModelConvertHelper <FactoryBatchNeedPlanExcel> .ToList(data);
var fileStream = ExcelHelper.EntityListToExcelStream <FactoryBatchNeedPlanExcel>(dataList, "加工厂批次需求计划", hzzfc);
return(File(fileStream, "application/vnd.ms-excel", "加工厂批次需求计划.xls"));
}
/// <summary>
/// 新增、修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="itemModel">明细信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string type)
{
try
{
var PlanModel = JsonEx.JsonToObj <TbSafeDatumManage>(model);
if (type == "add")
{
var data = _sdmlogic.Insert(PlanModel);
return(Content(data.ToJson()));
}
else
{
var data = _sdmlogic.Update(PlanModel);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult CapacitySubmitForm(string model, string type)
{
try
{
var capacityModel = JsonEx.JsonToObj <TbCapacityFilling>(model);
if (type == "add")
{
var data = _workOrderLogic.InsertCapacity(capacityModel);
return(Content(data.ToJson()));
}
else
{
var data = _workOrderLogic.UpdateCapacity(capacityModel);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var carInfoModel = JsonEx.JsonToObj <TbCarInfo>(model);
var carInfoItem = JsonEx.JsonToObj <List <TbCarInfoDetail> >(itemModel);
if (type == "add")
{
var data = _carInfo.Insert(carInfoModel, carInfoItem);
return(Content(data.ToJson()));
}
else
{
var data = _carInfo.Update(carInfoModel, carInfoItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public async Task UpdateDesiredProperties(string id, TwinCollection patch)
{
Events.UpdatingDesiredProperties(id);
Preconditions.CheckNotNull(patch, nameof(patch));
Option <Twin> storedTwin = await this.Get(id);
if (storedTwin.HasValue)
{
await this.twinEntityStore.Update(
id,
twinInfo =>
{
twinInfo.Twin
.ForEach(
twin =>
{
TwinProperties twinProperties = twin.Properties ?? new TwinProperties();
TwinCollection desiredProperties = twinProperties.Desired ?? new TwinCollection();
if (desiredProperties.Version + 1 == patch.Version)
{
string mergedDesiredPropertiesString = JsonEx.Merge(desiredProperties, patch, /* treatNullAsDelete */ true);
twinProperties.Desired = new TwinCollection(mergedDesiredPropertiesString);
twin.Properties = twinProperties;
Events.MergedDesiredProperties(id);
}
else
{
Events.DesiredPropertiesVersionMismatch(id, desiredProperties.Version, patch.Version);
}
});
return(twinInfo);
});
}
else
{
Events.NoTwinForDesiredPropertiesPatch(id);
}
}
/// <summary>
/// 修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="itemModel">明细信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string detail, string detail2, string type)
{
try
{
Object data = new Object();
var supplyList = JsonEx.JsonToObj <TbSupplyList>(model);
if (type == "Detail")//点击的供货按钮
{
var supplyLDetail = JsonEx.JsonToObj <List <TbSupplyListDetail> >(detail);
var supplyLDetail2 = JsonEx.JsonToObj <List <TbSupplyListDetailHistory> >(detail2);
data = _suplistLogic.Update(supplyList, supplyLDetail, supplyLDetail2);
}
else
{ //点击的供货完成
var suplistLogic = PM.DataAccess.DbContext.Db.Context.From <TbSupplyListDetail>()
.Select(TbSupplyListDetail._.All)
.Where(p => p.BatchPlanNum == supplyList.BatchPlanNum).ToList();
if (suplistLogic.Count > 0)
{
for (int i = 0; i < suplistLogic.Count; i++)
{
suplistLogic[i].HasSupplier = suplistLogic[i].BatchPlanQuantity;
//suplistLogic[i].ThisTimeCount = suplistLogic[i].BatchPlanQuantity;
}
}
var suplistLogich = PM.DataAccess.DbContext.Db.Context.From <TbSupplyListDetailHistory>()
.Select(TbSupplyListDetailHistory._.All)
.Where(p => p.BatchPlanNum == supplyList.BatchPlanNum).ToList();
var modeld = MapperHelper.Map <TbSupplyListDetail, TbSupplyListDetail>(suplistLogic);
var modeldh = MapperHelper.Map <TbSupplyListDetailHistory, TbSupplyListDetailHistory>(suplistLogich);
data = _suplistLogic.Update(supplyList, modeld, modeldh);
}
return(Content(data.ToJson()));
}
catch (Exception ex)
{
return(Content(ex.ToString()));;
}
}
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var inOrderModel = JsonEx.JsonToObj <TbDistributionDeclare>(model);
var inOrderItem = JsonEx.JsonToObj <List <TbDistributionDeclareItem> >(itemModel);
if (type == "add")
{
var data = _distributionDeclare.Insert(inOrderModel, inOrderItem);
return(Content(data.ToJson()));
}
else
{
var data = _distributionDeclare.Update(inOrderModel, inOrderItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
// This method updates local state and should be called only after acquiring twinLock
async Task ApplyPatchAsync(TwinCollection desiredProperties, TwinCollection patch)
{
try
{
string mergedJson = JsonEx.Merge(desiredProperties, patch, true);
desiredProperties = new TwinCollection(mergedJson);
Events.LogDesiredPropertiesAfterPatch(desiredProperties);
if (this.CheckIfTwinSignatureIsValid(desiredProperties))
{
this.desiredProperties = Option.Some(desiredProperties);
await this.UpdateDeploymentConfig(desiredProperties);
Events.DesiredPropertiesPatchApplied();
}
}
catch (Exception ex) when(!ex.IsFatal())
{
this.deploymentConfigInfo = Option.Some(new DeploymentConfigInfo(desiredProperties?.Version ?? 0, ex));
Events.DesiredPropertiesPatchFailed(ex);
// Update reported properties with last desired status
}
}
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var sampleOrderModel = JsonEx.JsonToObj <TbSampleOrder>(model);
var sampleOrderItem = JsonEx.JsonToObj <List <TbSampleOrderItem> >(itemModel);
if (type == "add")
{
var data = _sampleOrder.Insert(sampleOrderModel, sampleOrderItem);
return(Content(data.ToJson()));
}
else
{
var data = _sampleOrder.Update(sampleOrderModel, sampleOrderItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var StockTakingModel = JsonEx.JsonToObj <TbStockTaking>(model);
var StockTakingItem = JsonEx.JsonToObj <List <TbStockTakingItem> >(itemModel);
if (type == "add")
{
var data = _StockTaking.Insert(StockTakingModel, StockTakingItem);
return(Content(data.ToJson()));
}
else
{
var data = _StockTaking.Update(StockTakingModel, StockTakingItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 新增、修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="itemModel">明细信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var monthDemandPlanModel = JsonEx.JsonToObj <TbRawMaterialMonthDemandPlan>(model);
var monthDemandPlanItem = JsonEx.JsonToObj <List <TbRawMaterialMonthDemandPlanDetail> >(itemModel);
if (type == "add")
{
var data = _rawMonthDemPlanLogic.Insert(monthDemandPlanModel, monthDemandPlanItem);
return(Content(data.ToJson()));
}
else
{
var data = _rawMonthDemPlanLogic.Update(monthDemandPlanModel, monthDemandPlanItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
///// <summary>
///// 各站点发料数量分析
///// </summary>
///// <returns></returns>
//public ActionResult GetSiteAnalysis(PageSearchRequest psr)
//{
// var data = _sdzLogic.GetSiteAnalysis(psr);
// return Content(data.ToJson());
//}
///// <summary>
///// 各加工类型发料数量分析
///// </summary>
///// <returns></returns>
//public ActionResult GetMachiningTypeAnalysis(PageSearchRequest psr)
//{
// var data = _sdzLogic.GetMachiningTypeAnalysis(psr);
// return Content(data.ToJson());
//}
#endregion
#region 新增/编辑数据
/// <summary>
/// 新增、修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var SOModel = JsonEx.JsonToObj <TbSignforDuiZhang>(model);
var SOModelItem = JsonEx.JsonToObj <List <TbSignforDuiZhangDetail> >(itemModel);
if (type == "add")
{
var data = _sdzLogic.Insert(SOModel, SOModelItem);
return(Content(data.ToJson()));
}
else
{
var data = _sdzLogic.Update(SOModel, SOModelItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage SubmitForm([FromBody] JObject jdata)
{
string modelstr = jdata["model"] == null ? "" : jdata["model"].ToString();
string type = jdata["type"] == null ? "" : jdata["type"].ToString();
if (string.IsNullOrWhiteSpace(modelstr) || string.IsNullOrWhiteSpace(type))
{
return(AjaxResult.Error("参数错误").ToJsonApi());
}
var model = JsonEx.JsonToObj <TbSafeDatumManage>(modelstr);
if (type == "add")
{
var data = _sdmLogic.Insert(model, true);
return(data.ToJsonApi());
}
else
{
var data = _sdmLogic.Update(model, true);
return(data.ToJsonApi());
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//检查编号、加工厂名称、消防设施是否齐全、消防标语是否齐全、消防通道是否畅通、消防管道是否达到要求、检查人、检查时间、问题描述
//CheckCode,ProcessFactoryName,FireImplement,FireSlogan,FirePassageway,FirePiping,CheckUserNames,CheckDate,ProblemDescription
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "CheckCode", "检查编号" },
{ "ProcessFactoryName", "加工厂名称" },
{ "FireImplement", "消防设施是否齐全" },
{ "FireSlogan", "消防标语是否齐全" },
{ "FirePassageway", "消防通道是否畅通" },
{ "FirePiping", "消防管道是否达到要求" },
{ "CheckUserNames", "检查人" },
{ "CheckDate", "检查时间" },
{ "ProblemDescription", "问题描述" },
};
var request = JsonEx.JsonToObj <FireInspectionRequest>(jsonData);
var data = _fireInspection.GetExportList(request);
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "消防检查", "");
return(File(fileStream, "application/vnd.ms-excel", "消防检查.xls"));
}
/// <summary>
/// 新增、修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="itemModel">明细信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var PlanModel = JsonEx.JsonToObj <TbPersonnelWorkDayConsume>(model);
var PlanItem = JsonEx.JsonToObj <List <TbPersonnelWorkDayConsumeItem> >(itemModel);
if (type == "add")
{
var data = _pwdcBus.Insert(PlanModel, PlanItem);
return(Content(data.ToJson()));
}
else
{
var data = _pwdcBus.Update(PlanModel, PlanItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//检查编号、加工厂名称、外电防护与配电线路、接地与防雷、配电室与自备电源、配电箱与开关箱、检查人、检查时间、问题描述
//CheckCode,ProcessFactoryName,epod,gorlp,drorps,dorsb,CheckUserNames,CheckDate,ProblemDescription
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "CheckCode", "检查编号" },
{ "ProcessFactoryName", "加工厂名称" },
{ "epod", "外电防护与配电线路" },
{ "gorlp", "接地与防雷" },
{ "drorps", "配电室与自备电源" },
{ "dorsb", "配电箱与开关箱" },
{ "CheckUserNames", "检查人" },
{ "CheckDate", "检查时间" },
{ "ProblemDescription", "问题描述" },
};
var request = JsonEx.JsonToObj <InterimUseElectricCheckRequest>(jsonData);
var data = _iueclogic.GetExportList(request);
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "临时用电检查", "");
return(File(fileStream, "application/vnd.ms-excel", "临时用电检查.xls"));
}
public HttpResponseMessage SubmitForm([FromBody] JObject jdata)
{
try
{
string modelstr = jdata["model"] == null ? "" : jdata["model"].ToString();
string orderstr = jdata["orderModel"] == null ? "" : jdata["orderModel"].ToString();
string itemstr = jdata["itemModel"] == null ? "" : jdata["itemModel"].ToString();
if (string.IsNullOrWhiteSpace(modelstr))
{
return(AjaxResult.Error("参数错误").ToJsonApi());
}
var model = JsonEx.JsonToObj <TbDistributionEnt>(modelstr);
var order = JsonEx.JsonToObj <List <TbDistributionEntOrder> >(orderstr);
var items = JsonEx.JsonToObj <List <TbDistributionEntItem> >(itemstr);
model.InsertTime = DateTime.Now;
var data = _deBus.Insert(model, order, items, true);
return(data.ToJsonApi());
}
catch (Exception)
{
return(AjaxResult.Error("操作失败").ToJsonApi());
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ProjectCode"></param>
/// <returns></returns>
public ActionResult OutputExcel(string jsonData)
{
//材料名称、规格型号、钢筋类型、计量单位、库存重量（kg）、动态库存重量合计（kg）、分部名称、工区名称、仓库名称
//MaterialName,SpecificationModel,RebarTypeText,MeasurementUnitText,SurplusNumber,PassCount,BranchName,WorkAreaName,StorageName
//导出数据列
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "MaterialName", "材料名称" },
{ "SpecificationModel", "规格型号" },
{ "RebarTypeText", "钢筋类型" },
{ "MeasurementUnitText", "计量单位" },
{ "SurplusNumber", "库存重量(kg)" },
{ "PassCount", "动态库存重量合计(kg)" },
{ "BranchName", "分部名称" },
{ "WorkAreaName", "工区名称" },
{ "StorageName", "仓库名称" },
};
var request = JsonEx.JsonToObj <RawMaterialStockRequest>(jsonData);
var data = _rawMaterialStock.GetExportList(request);
string hzzfc = "";
var fileStream = ExcelHelper.ExportToMemoryStream(cellheader, data, "", "", "原材料库存", hzzfc);
return(File(fileStream, "application/vnd.ms-excel", "原材料库存.xls"));
}
/// <summary>
/// 新增、修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="itemModel">明细信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var siteDiscCargoModel = JsonEx.JsonToObj <TbSiteDischargeCargo>(model);
var siteDiscCargoItem = JsonEx.JsonToObj <List <TbSiteDischargeCargoDetail> >(itemModel);
if (type == "add")
{
var data = _siteDiscCargoLogic.Insert(siteDiscCargoModel, siteDiscCargoItem);
return(Content(data.ToJson()));
}
else
{
var data = _siteDiscCargoLogic.Update(siteDiscCargoModel, siteDiscCargoItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
public object Get(string key)
{
try
{
dynamic value = _database.StringGet(key);
if (string.IsNullOrEmpty(value))
{
return(null);
}
value = value.ToString();
return(JsonEx.Deserialize(value));
}
catch (Exception ex)
{
//exception should be logged
return(null);
}
}
/// <summary>
/// 新增、修改数据提交
/// </summary>
/// <param name="model">主表信息</param>
/// <param name="itemModel">明细信息</param>
/// <param name="type">类型</param>
/// <returns></returns>
public ActionResult SubmitForm(string model, string itemModel, string type)
{
try
{
var workOrderModel = JsonEx.JsonToObj <TbWorkOrder>(model);
var workOrderItem = JsonEx.JsonToObj <List <TbWorkOrderDetail> >(itemModel);
if (type == "add")
{
var data = _workOrderLogic.Insert(workOrderModel, workOrderItem);
return(Content(data.ToJson()));
}
else
{
var data = _workOrderLogic.Update(workOrderModel, workOrderItem);
return(Content(data.ToJson()));
}
}
catch (Exception)
{
throw;
}
}
