public void Import()
{
int totalCount;
List <KehuGridModel> kehuGridModels = this._kehuService.GetKehu(new KehuFilterModel {
keyword = "", size = 100, start = 0
}, out totalCount);
List <ChanpinGridModel> chanpinGridModels = this._chanpinService.GetChanpin(new ChanpinFilterModel {
keyword = "", size = 100, start = 0
}, out totalCount);
MetadataExporter exporter = new MetadataExporter();
List <JObject> kehuJsonList = exporter.Export("71d07482-0b90-408a-a6f0-cbb4847ba533");
List <DingdanDetailsModel> models = new List <DingdanDetailsModel>();
foreach (JObject jObject in kehuJsonList)
{
string kehuName = jObject["kehu"].ToString();
KehuGridModel kehuGridModel = kehuGridModels.Find(k => k.name == kehuName);
if (kehuGridModel == null)
{
kehuGridModel = this.CreateKehu(kehuName);
}
JObject kehuJObject = new JObject();
kehuJObject.Add("id", kehuGridModel.id);
kehuJObject.Add("name", kehuGridModel.name);
jObject["kehu"] = kehuJObject;
jObject["xiadanRiqi"] = jObject["fahuoRiqi"];
string json = JsonConvert.SerializeObject(jObject);
DingdanDetailsModel model = JsonConvert.DeserializeObject <DingdanDetailsModel>(json);
foreach (JObject chanpin in jObject["chanpinGrid"])
{
JObject chanpinObject = new JObject();
ChanpinGridModel chanpinModel = chanpinGridModels.Find(c => c.name == chanpin["name"].ToString());
if (chanpinModel == null)
{
chanpinModel = this.CreateChanpin(chanpin["name"].ToString());
}
chanpinObject.Add("id", chanpinModel.id);
chanpinObject.Add("name", chanpinModel.name);
chanpin["chanpin"] = chanpinObject;
chanpin["shifouKaipiao"] = chanpin["shifouKaipiao"].ToString() == "是";
}
model.mingxiList = JsonConvert.DeserializeObject <List <DingdanMingxiDetailsModel> >(JsonConvert.SerializeObject(jObject["chanpinGrid"]));
models.Add(model);
}
models = models.OrderBy(m => m.xiadanRiqi).ToList();
foreach (DingdanDetailsModel model in models)
{
Thread.Sleep(1000);
this._dingdanService.Create(model);
}
}
public ActionResult EditPost()
{
ControllerResultModel resultModel = new ControllerResultModel();
try
{
DingdanDetailsModel model = JsonConvert.DeserializeObject <DingdanDetailsModel>(Request["argsJson"]);
WebHelper.DingdanService.Change(model);
}
catch (Exception ex)
{
resultModel.result = false;
resultModel.message = ex.Message;
WebHelper.Logger.Error(ex.Message, ex);
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
public ActionResult JisuanShoukuanTicheng()
{
ControllerResultModel resultModel = new ControllerResultModel();
try
{
DingdanDetailsModel dingdanModel = JsonConvert.DeserializeObject <DingdanDetailsModel>(Request["dingdanJson"]);
ShoukuanDetailsModel shoukuanModel = JsonConvert.DeserializeObject <ShoukuanDetailsModel>(Request["shoukuanJson"]);
double ticheng = WebHelper.DingdanService.JisuanTicheng(dingdanModel, shoukuanModel);
resultModel.Add("ticheng", ticheng);
}
catch (Exception ex)
{
resultModel.result = false;
resultModel.message = ex.Message;
WebHelper.Logger.Error(ex.Message, ex);
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
public ActionResult ShengchengChuhuodan(string dingdanId)
{
string path = Server.MapPath("~/锐涂出货申请单.xls");
FileStream stream = System.IO.File.OpenRead(path);
HSSFWorkbook workbook = new HSSFWorkbook(stream);
HSSFSheet sheet = workbook.GetSheetAt(0);
DingdanDetailsModel dingdan = WebHelper.DingdanService.GetDingdan(dingdanId);
HSSFRow dataRow = sheet.GetRow(2);
var cell = dataRow.GetCell(6);
cell.SetCellValue(DateTime.Today.ToString("yyyy 年"));
cell = dataRow.GetCell(7);
cell.SetCellValue(DateTime.Today.ToString("MM 月 dd 日"));
dataRow = sheet.GetRow(3);
cell = dataRow.GetCell(1);
cell.SetCellValue(dingdan.kehu.name);
cell = dataRow.GetCell(5);
cell.SetCellValue(dingdan.shouhuoDizhi);
dataRow = sheet.GetRow(4);
cell = dataRow.GetCell(1);
cell.SetCellValue(dingdan.shouhuoren);
cell = dataRow.GetCell(3);
cell.SetCellValue(dingdan.shouhuorenDianhua);
cell = dataRow.GetCell(7);
if (dingdan.fahuoRiqi.HasValue)
{
cell.SetCellValue(dingdan.fahuoRiqi.Value.ToString("MM 月 dd 日"));
}
int dataRowIndex = 7;
foreach (DingdanMingxiDetailsModel mingxiModel in dingdan.mingxiList)
{
dataRow = sheet.GetRow(dataRowIndex);
cell = dataRow.GetCell(0);
cell.SetCellValue("");
cell = dataRow.GetCell(1);
cell.SetCellValue(mingxiModel.chanpin.name);
cell = dataRow.GetCell(2);
cell.SetCellValue(mingxiModel.xinghao);
cell = dataRow.GetCell(3);
cell.SetCellValue(mingxiModel.danwei);
cell = dataRow.GetCell(4);
cell.SetCellValue(mingxiModel.shuliang);
cell = dataRow.GetCell(5);
cell.SetCellValue(mingxiModel.beizhu);
dataRowIndex++;
}
string tempPath = Server.MapPath(string.Format("~/Temp/{0}.xls", Guid.NewGuid().ToString()));
if (!Directory.Exists(Path.GetDirectoryName(tempPath)))
{
Directory.CreateDirectory(Path.GetDirectoryName(tempPath));
}
Stream newStream = System.IO.File.Open(tempPath, FileMode.Create);
workbook.Write(newStream);
newStream.Close();
stream.Close();
workbook = null;
sheet = null;
return(this.File(tempPath, "application/x-xls", dingdan.danhao + "出货申请单.xls"));
}
