public void Update(AscmMaterialItem ascmMaterialItem)
{
try
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmMaterialItem>(ascmMaterialItem);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmMaterialItem)");
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmMaterialItem)", ex);
throw ex;
}
}
public AscmDeliBatSumDetail GetByBatchId(int batchId)
{
AscmDeliBatSumDetail ascmDeliBatSumDetail = null;
try
{
string containerBindNumber = "select sum(quantity) from AscmContainerDelivery where deliveryOrderBatchId=a.batchId";
string palletBindNumber = "select sum(quantity) from AscmPalletDelivery where deliveryOrderBatchId=a.batchId";
string driverBindNumber = "select sum(quantity) from AscmDriverDelivery where deliveryOrderBatchId=a.batchId";
string receivedQuantity = "select sum(receivedQuantity) from AscmDeliBatOrderLink where batchId=a.batchId";
string sql = "select new AscmDeliBatSumDetail(a,(" + containerBindNumber + "),(" + palletBindNumber + "),(" + driverBindNumber + "),(" + receivedQuantity + ")) from AscmDeliBatSumDetail a ";
sql += " where batchId=" + batchId;
IList <AscmDeliBatSumDetail> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDeliBatSumDetail>(sql);
if (ilist != null && ilist.Count > 0)
{
ascmDeliBatSumDetail = ilist.First();
AscmDeliveryOrderBatch ascmDeliveryOrderBatch = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmDeliveryOrderBatch>(batchId);
ascmDeliBatSumDetail.ascmDeliveryOrderBatch = ascmDeliveryOrderBatch;
AscmMaterialItem ascmMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmMaterialItem>(ascmDeliBatSumDetail.materialId);
ascmDeliBatSumDetail.ascmMaterialItem = ascmMaterialItem;
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDeliBatSumDetail)", ex);
throw ex;
}
return(ascmDeliBatSumDetail);
}
public List <AscmMaterialItem> GetMaterialListByBatch(int batchId)
{
List <AscmMaterialItem> list = null;
try
{
string sort = " order by id ";
//if (!string.IsNullOrEmpty(sortName))
//{
// sort = " order by " + sortName.Trim() + " ";
// if (!string.IsNullOrEmpty(sortOrder))
// sort += sortOrder.Trim();
//}
string sql = "from AscmDeliveryOrderDetail where mainId in (select id from AscmDeliveryOrderMain where batchId =" + batchId + ")";
string where = "", whereQueryWord = "";
//if (!string.IsNullOrEmpty(queryWord))
// whereQueryWord = " (name like '%" + queryWord.Trim() + "%' or description like '%" + queryWord.Trim() + "%')";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
//where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereOther);
if (!string.IsNullOrEmpty(where))
{
sql += " and " + where;
}
//IList<AscmDeliveryOrderDetail> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmDeliveryOrderDetail>(sql + sort);
IList <AscmDeliveryOrderDetail> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmDeliveryOrderDetail>(sql + sort);
if (ilist != null)
{
List <AscmDeliveryOrderDetail> listAscmDeliveryOrderDetail = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmDeliveryOrderDetail>(ilist);
//SetMain(list);
SetMaterial(listAscmDeliveryOrderDetail);
//SetNotifyDetail(list);
list = new List <AscmMaterialItem>();
foreach (AscmDeliveryOrderDetail ascmDeliveryOrderDetail in listAscmDeliveryOrderDetail)
{
AscmMaterialItem ascmMaterialItem = list.Find(p => p.id == ascmDeliveryOrderDetail.materialId);
if (ascmMaterialItem == null)
{
ascmMaterialItem = ascmDeliveryOrderDetail.ascmMaterialItem;
ascmMaterialItem.deliveryQuantity = 0;
list.Add(ascmMaterialItem);
}
ascmMaterialItem.deliveryQuantity += ascmDeliveryOrderDetail.deliveryQuantity;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public AscmMaterialItem Get(int id)
{
AscmMaterialItem ascmMaterialItem = null;
try
{
ascmMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmMaterialItem>(id);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmMaterialItem)", ex);
throw ex;
}
return(ascmMaterialItem);
}
public List <AscmMaterialItem> GetWarehouseMaterialSumList(int materialId)
{
List <AscmMaterialItem> listAscmMaterialItem = null;
try
{
AscmMaterialItem ascmMaterialItem = Get(materialId);
if (ascmMaterialItem == null)
{
throw new Exception("获取物料失败");
}
string totalNumber = "select quantity from AscmLocationMaterialLink where warelocationId=a.id and materialid=" + materialId;
string warehouseDes = "select description from AscmWarehouse where id=a.warehouseId";
string sql = "select new AscmWarelocation(a,(" + totalNumber + "),(" + warehouseDes + ")) from AscmWarelocation a";
string where = "";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "a.id in(select warelocationId from AscmLocationMaterialLink where materialid=" + materialId + ")");
if (!string.IsNullOrEmpty(where))
{
sql += " where " + where;
}
IList <AscmWarelocation> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>(sql);
if (ilist != null)
{
listAscmMaterialItem = new List <AscmMaterialItem>();
var groupByWarehouse = ilist.GroupBy(P => P.warehouseId);
foreach (IGrouping <string, AscmWarelocation> ig in groupByWarehouse)
{
AscmMaterialItem _ascmMaterialItem = ascmMaterialItem.GetOwner();
_ascmMaterialItem.warehouseName = ig.Key;
_ascmMaterialItem.warehouseDes = ig.First().warehouseDes;
_ascmMaterialItem.totalNumber = ig.Sum(P => P.totalNumber);
_ascmMaterialItem.id = ascmMaterialItem.id;
_ascmMaterialItem.docNumber = ascmMaterialItem.docNumber;
_ascmMaterialItem.unit = ascmMaterialItem.unit;
_ascmMaterialItem.description = ascmMaterialItem.description;
listAscmMaterialItem.Add(_ascmMaterialItem);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listAscmMaterialItem);
}
public void SetMaterial(List <AscmWmsPreparationDetail> list)
{
if (list == null || list.Count == 0)
{
return;
}
var materialIds = list.Select(P => P.materialId).Distinct();
var count = materialIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += materialIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmMaterialItem where id in (" + ids + ")";
IList <AscmMaterialItem> ilistMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialItem>(sql);
if (ilistMaterialItem != null && ilistMaterialItem.Count > 0)
{
List <AscmMaterialItem> listMaterialItem = ilistMaterialItem.ToList();
foreach (AscmWmsPreparationDetail preparationDetail in list)
{
AscmMaterialItem materialItem = listMaterialItem.Find(P => P.id == preparationDetail.materialId);
if (materialItem != null)
{
preparationDetail.ascmMaterialItem = materialItem;
preparationDetail.materialDocNumber = materialItem.docNumber;
preparationDetail.materialName = materialItem.description;
preparationDetail.materialUnit = materialItem.unit;
}
}
}
}
ids = string.Empty;
}
}
}
public void SetMaterial(List <AscmDeliveryOrderBatch> list)
{
if (list == null || list.Count == 0)
{
return;
}
var materialIds = list.Select(P => P.materialIdTmp).Distinct();
var count = materialIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += materialIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string hql = "from AscmMaterialItem where id in (" + ids + ")";
IList <AscmMaterialItem> ilistMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialItem>(hql);
if (ilistMaterialItem != null && ilistMaterialItem.Count > 0)
{
List <AscmMaterialItem> listMaterialItem = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmMaterialItem>(ilistMaterialItem);
foreach (AscmDeliveryOrderBatch deliveryOrderBatch in list)
{
AscmMaterialItem materialItem = listMaterialItem.Find(P => P.id == deliveryOrderBatch.materialIdTmp);
if (materialItem != null)
{
deliveryOrderBatch.ascmMaterialItem = materialItem;
}
}
}
}
ids = string.Empty;
}
}
}
public void SetMaterial(List <AscmWmsContainerDelivery> list)
{
if (list != null && list.Count > 0)
{
var materialIds = list.Select(P => P.materialId).Distinct();
var count = materialIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += materialIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmMaterialItem where id in (" + ids + ")";
IList <AscmMaterialItem> ilistMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialItem>(sql);
if (ilistMaterialItem != null && ilistMaterialItem.Count > 0)
{
List <AscmMaterialItem> listMaterialItem = ilistMaterialItem.ToList();
foreach (AscmWmsContainerDelivery containerDelivery in list)
{
AscmMaterialItem materialItem = listMaterialItem.Find(P => P.id == containerDelivery.materialId);
if (materialItem != null)
{
containerDelivery.materialDocNumber = materialItem.docNumber;
containerDelivery.materialName = materialItem.description;
}
}
}
}
ids = string.Empty;
}
}
}
}
private void SetMaterial(List <AscmLocationMaterialLink> list)
{
if (list != null && list.Count > 0)
{
var materialIds = list.Select(P => P.pk.materialId).Distinct();
var count = materialIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += materialIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmMaterialItem where id in (" + ids + ")";
IList <AscmMaterialItem> ilistMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialItem>(sql);
if (ilistMaterialItem != null && ilistMaterialItem.Count > 0)
{
List <AscmMaterialItem> listMaterialItem = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmMaterialItem>(ilistMaterialItem);
foreach (AscmLocationMaterialLink locationMaterialLink in list)
{
AscmMaterialItem materialItem = listMaterialItem.Find(P => P.id == locationMaterialLink.pk.materialId);
if (materialItem != null)
{
locationMaterialLink.materialDocNumber = materialItem.docNumber;
locationMaterialLink.materialDescription = materialItem.description;
}
}
}
}
ids = string.Empty;
}
}
}
}
public void SetMaterial(List <AscmWipRequirementOperations> list)
{
if (list != null && list.Count > 0)
{
var inventoryItemIds = list.Select(P => P.inventoryItemId).Distinct();
var count = inventoryItemIds.Count();
string ids = string.Empty;
for (int i = 0; i < count; i++)
{
if (!string.IsNullOrEmpty(ids))
{
ids += ",";
}
ids += inventoryItemIds.ElementAt(i);
if ((i + 1) % 500 == 0 || (i + 1) == count)
{
if (!string.IsNullOrEmpty(ids))
{
string sql = "from AscmMaterialItem where id in (" + ids + ")";
IList <AscmMaterialItem> ilistAscmMaterialItem = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialItem>(sql);
if (ilistAscmMaterialItem != null && ilistAscmMaterialItem.Count > 0)
{
List <AscmMaterialItem> listAscmMaterialItem = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmMaterialItem>(ilistAscmMaterialItem);
foreach (AscmWipRequirementOperations wipRequirementOperations in list)
{
AscmMaterialItem ascmMaterialItem = listAscmMaterialItem.Find(P => P.id == wipRequirementOperations.inventoryItemId);
if (ascmMaterialItem != null)
{
wipRequirementOperations.ascmMaterialItem = ascmMaterialItem;
}
}
}
}
ids = string.Empty;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
YnFrame.Dal.Entities.YnUser ynUser = YnFrame.Web.FormsAuthenticationService.GetInstance().GetTicketUserData();
if (ynUser == null)
{
throw new Exception("用户错误！");
}
AscmUserInfo ascmUserInfo = AscmUserInfoService.GetInstance().Get(ynUser.userId);
string supplierName = "";
if (ascmUserInfo.extExpandType == "erp")
{
AscmUserInfoService.GetInstance().SetSupplier(ascmUserInfo);
if (ascmUserInfo.ascmSupplier != null)
{
supplierName = ascmUserInfo.ascmSupplier.name;
}
}
//提取数据
List <AscmMaterialItem> sumList = new List <AscmMaterialItem>();
//最后一个装箱
AscmMaterialItem lastDetail = new AscmMaterialItem();
string ids = Request.QueryString["ids"];
string unitQuantitys = Request.QueryString["unitQuantitys"];
string totalNumbers = Request.QueryString["totalNumbers"];
bool isUnitPrint = Boolean.Parse(Request.QueryString["isUnitPrint"]);
string[] listId = ids.Split(',');
string[] listUnitQuantity = unitQuantitys.Split(',');
string[] listTotalNumber = totalNumbers.Split(',');
List <AscmMaterialItem> list = new List <AscmMaterialItem>();
for (int i = 0; i < listId.Count(); i++)
{
AscmMaterialItem ascmMaterialItem = AscmMaterialItemService.GetInstance().Get(Int32.Parse(listId[i]));
AscmContainerUnitQuantity ascmContainerUnitQuantity = AscmContainerUnitQuantityService.GetInstance().Get(Int32.Parse(listUnitQuantity[i]));
ascmMaterialItem.container = ascmContainerUnitQuantity.container;
ascmMaterialItem.unitQuantity = ascmContainerUnitQuantity.unitQuantity;
ascmMaterialItem.containerUnitQuantityId = ascmContainerUnitQuantity.id;
ascmMaterialItem.totalNumber = Decimal.Parse(listTotalNumber[i]);
list.Add(ascmMaterialItem);
}
if (!string.IsNullOrEmpty(ids))
{
if (list != null && list.Count() > 0)
{
foreach (AscmMaterialItem ascmMaterialItem in list)
{
//条码
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
if (ascmMaterialItem.docNumber != null)
{
#region Code128
MideaAscm.Code.BarCode128 barCode128 = new Code.BarCode128();
barCode128.TitleFont = new System.Drawing.Font("宋体", 10);
barCode128.HeightImage = 50;
System.Drawing.Bitmap bitmap = barCode128.GetCodeImage(ascmMaterialItem.docNumber, ascmMaterialItem.docNumber, Code.BarCode128.Encode.Code128B);
bitmap.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Gif);
bitmap.Dispose();
#endregion
}
ascmMaterialItem.materialBarcode = memoryStream.ToArray();
//如果是总数打印，单元数=总数
if (!isUnitPrint)
{
ascmMaterialItem.unitQuantity = ascmMaterialItem.totalNumber;
}
decimal totalNumber = ascmMaterialItem.totalNumber; //总数量
decimal unitQuantity = ascmMaterialItem.unitQuantity; //单元数
//decimal unitQuantity = 10;
decimal count = decimal.Truncate(totalNumber / unitQuantity); //箱数量>=0
decimal rest = totalNumber % unitQuantity; //剩余数量>=0
//设置装箱数 2015.3.26
//总数 < 单元数 ，仅有一个箱子,总数 = 剩余数量
if (count == 0)
{
count = 1;
}
else
{
//有剩余数量，多出一箱
if (rest != 0)
{
count = count + 1;
}
}
for (int i = 0; i < count; i++)
{
//最后一个为剩余数量
if (i == count - 1 && rest != 0)
{
lastDetail.materialBarcode = ascmMaterialItem.materialBarcode;
lastDetail.docNumber = ascmMaterialItem.docNumber;
lastDetail.description = ascmMaterialItem.description;
lastDetail.unit = ascmMaterialItem.unit;
lastDetail.unitQuantity = rest;
sumList.Add(lastDetail);
}
else
{
sumList.Add(ascmMaterialItem);
}
}
}
}
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("SupplierMaterialReport.rdlc");
ReportDataSource rds1 = new ReportDataSource();
rds1.Name = "DataSet1";
rds1.Value = sumList;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds1);
string companpyTitle = "美的中央空调";
string title = companpyTitle + "供应商送货物料条码";
ReportParameter[] reportParameters = new ReportParameter[] {
new ReportParameter("ReportParameter_SupplierName", supplierName)
};
ReportViewer1.LocalReport.SetParameters(reportParameters);
ReportViewer1.LocalReport.Refresh();
}
}
public ContentResult MaterialStockFormatSave(AscmMaterialItem ascmMaterialItem_Model, int? id)
{
JsonObjectResult jsonObjectReuslt = new JsonObjectResult();
string userName = string.Empty;
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
}
try
{
AscmMaterialItem ascmMaterialItem = null;
if (!id.HasValue)
throw new Exception("未选择或获取物料信息！");
ascmMaterialItem = AscmMaterialItemService.GetInstance().Get(id.Value);
ascmMaterialItem.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmMaterialItem.modifyUser = userName;
ascmMaterialItem.zMtlCategoryStatus = ascmMaterialItem_Model.zMtlCategoryStatus;
ascmMaterialItem.dMtlCategoryStatus = ascmMaterialItem_Model.dMtlCategoryStatus;
ascmMaterialItem.wMtlCategoryStatus = ascmMaterialItem_Model.wMtlCategoryStatus;
AscmMaterialItemService.GetInstance().Update(ascmMaterialItem);
jsonObjectReuslt.result = true;
jsonObjectReuslt.message = "";
jsonObjectReuslt.id = ascmMaterialItem.id.ToString();
jsonObjectReuslt.entity = ascmMaterialItem;
}
catch (Exception ex)
{
jsonObjectReuslt.result = false;
jsonObjectReuslt.message = ex.Message;
}
string sReturn = JsonConvert.SerializeObject(jsonObjectReuslt);
return Content(sReturn);
}
public ContentResult BatchMaterialStockFormatSave(AscmMaterialItem ascmMaterialItem_Model)
{
string userName = string.Empty;
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
}
JsonObjectResult jsonObjectReuslt = new JsonObjectResult();
List<AscmMaterialItem> list = null;
try
{
if (string.IsNullOrEmpty(ascmMaterialItem_Model.sDocnumber) || string.IsNullOrEmpty(ascmMaterialItem_Model.eDocnumber))
throw new Exception("编码段不能为空！");
string whereOther = "", whereQueryWord = "";
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.wipSupplyType.ToString()) && ascmMaterialItem_Model.wipSupplyType.ToString() != "0")
{
whereQueryWord = "wipSupplyType = " + ascmMaterialItem_Model.wipSupplyType.ToString();
whereOther = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(whereOther, whereQueryWord);
}
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.sDocnumber) && !string.IsNullOrEmpty(ascmMaterialItem_Model.eDocnumber))
{
whereQueryWord = "docNumber >= '" + ascmMaterialItem_Model.sDocnumber + "'";
whereOther = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(whereOther, whereQueryWord);
whereQueryWord = "docNumber <= '" + ascmMaterialItem_Model.eDocnumber + "'";
whereOther = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(whereOther, whereQueryWord);
}
list = AscmMaterialItemService.GetInstance().GetList(null, "", "", "", whereOther, false);
if (list != null && list.Count > 0)
{
foreach (AscmMaterialItem ascmMaterialItem in list)
{
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.zMtlCategoryStatus))
{
ascmMaterialItem.zMtlCategoryStatus = ascmMaterialItem_Model.zMtlCategoryStatus;
}
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.dMtlCategoryStatus))
{
ascmMaterialItem.dMtlCategoryStatus = ascmMaterialItem_Model.dMtlCategoryStatus;
}
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.wMtlCategoryStatus))
{
ascmMaterialItem.wMtlCategoryStatus = ascmMaterialItem_Model.wMtlCategoryStatus;
}
ascmMaterialItem.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmMaterialItem.modifyUser = userName;
}
AscmMaterialItemService.GetInstance().Update(list);
}
jsonObjectReuslt.result = true;
jsonObjectReuslt.message = "批量维护成功！";
}
catch (Exception ex)
{
jsonObjectReuslt.result = false;
jsonObjectReuslt.message = ex.Message;
}
string sReturn = JsonConvert.SerializeObject(jsonObjectReuslt);
return Content(sReturn);
}
public ContentResult MaterialItemSave(AscmMaterialItem ascmMaterialItem_Model, int? id)
{
JsonObjectResult jsonObjectReuslt = new JsonObjectResult();
try
{
string userName = string.Empty;
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
}
AscmMaterialItem ascmMaterialItem = null;
if (id.HasValue)
{
ascmMaterialItem = AscmMaterialItemService.GetInstance().Get(id.Value);
ascmMaterialItem.modifyUser = userName;
ascmMaterialItem.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
else
{
ascmMaterialItem = new AscmMaterialItem();
int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmMaterialSubCategory");
ascmMaterialItem.id = ++maxId;
ascmMaterialItem.createUser = userName;
ascmMaterialItem.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmMaterialItem.modifyUser = userName;
ascmMaterialItem.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
if (ascmMaterialItem == null)
throw new Exception("保存物料子类信息失败 ！");
ascmMaterialItem.zMtlCategoryStatus = ascmMaterialItem_Model.zMtlCategoryStatus;
ascmMaterialItem.dMtlCategoryStatus = ascmMaterialItem_Model.dMtlCategoryStatus;
ascmMaterialItem.wMtlCategoryStatus = ascmMaterialItem_Model.wMtlCategoryStatus;
if (id.HasValue)
AscmMaterialItemService.GetInstance().Update(ascmMaterialItem);
else
AscmMaterialItemService.GetInstance().Save(ascmMaterialItem);
jsonObjectReuslt.result = true;
jsonObjectReuslt.message = "";
jsonObjectReuslt.id = ascmMaterialItem.id.ToString();
jsonObjectReuslt.entity = ascmMaterialItem;
}
catch (Exception ex)
{
jsonObjectReuslt.result = false;
jsonObjectReuslt.message = ex.Message;
}
string sReturn = JsonConvert.SerializeObject(jsonObjectReuslt);
return Content(sReturn);
}
public void Update(AscmMaterialItem ascmMaterialItem)
{
try
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmMaterialItem>(ascmMaterialItem);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmMaterialItem)");
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmMaterialItem)",ex);
throw ex;
}
}
public ContentResult BatchStockFormatSave(AscmMaterialItem ascmMaterialItem_Model)
{
JsonObjectResult jsonObjectReuslt = new JsonObjectResult();
string userName = string.Empty;
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
}
try
{
if (string.IsNullOrEmpty(ascmMaterialItem_Model.sDocnumber) || string.IsNullOrEmpty(ascmMaterialItem_Model.eDocnumber))
throw new Exception("编码段不能为空！");
string sql = "from AscmMaterialItem";
string where = "", whereQueryWord = "";
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.wipSupplyType.ToString()) && ascmMaterialItem_Model.wipSupplyType.ToString() != "0")
{
whereQueryWord = "wipSupplyType = " + ascmMaterialItem_Model.wipSupplyType.ToString();
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.sDocnumber) && !string.IsNullOrEmpty(ascmMaterialItem_Model.eDocnumber))
{
whereQueryWord = "docNumber >= '" + ascmMaterialItem_Model.sDocnumber + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
whereQueryWord = "docNumber <= '" + ascmMaterialItem_Model.eDocnumber + "'";
where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord);
}
if (!string.IsNullOrEmpty(where))
sql += " where " + where;
IList<AscmMaterialItem> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmMaterialItem>(sql);
List<AscmMaterialItem> newlist = null;
if (ilist != null && ilist.Count > 0)
{
newlist = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmMaterialItem>(ilist);
foreach (AscmMaterialItem ascmMaterialItem in newlist)
{
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.zMtlCategoryStatus))
{
ascmMaterialItem.zMtlCategoryStatus = ascmMaterialItem_Model.zMtlCategoryStatus;
}
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.dMtlCategoryStatus))
{
ascmMaterialItem.dMtlCategoryStatus = ascmMaterialItem_Model.dMtlCategoryStatus;
}
if (!string.IsNullOrEmpty(ascmMaterialItem_Model.wMtlCategoryStatus))
{
ascmMaterialItem.wMtlCategoryStatus = ascmMaterialItem_Model.wMtlCategoryStatus;
}
ascmMaterialItem.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmMaterialItem.modifyUser = userName;
}
AscmMaterialItemService.GetInstance().Update(newlist);
}
jsonObjectReuslt.result = true;
jsonObjectReuslt.message = "批量维护成功！";
}
catch (Exception ex)
{
jsonObjectReuslt.message = ex.Message;
throw ex;
}
string sReturn = JsonConvert.SerializeObject(jsonObjectReuslt);
return Content(sReturn);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
YnFrame.Dal.Entities.YnUser ynUser = YnFrame.Web.FormsAuthenticationService.GetInstance().GetTicketUserData();
if (ynUser == null)
throw new Exception("用户错误！");
AscmUserInfo ascmUserInfo = AscmUserInfoService.GetInstance().Get(ynUser.userId);
string supplierName = "";
if (ascmUserInfo.extExpandType == "erp")
{
AscmUserInfoService.GetInstance().SetSupplier(ascmUserInfo);
if (ascmUserInfo.ascmSupplier != null)
supplierName = ascmUserInfo.ascmSupplier.name;
}
//提取数据
List<AscmMaterialItem> sumList = new List<AscmMaterialItem>();
//最后一个装箱
AscmMaterialItem lastDetail = new AscmMaterialItem();
string ids = Request.QueryString["ids"];
string unitQuantitys = Request.QueryString["unitQuantitys"];
string totalNumbers = Request.QueryString["totalNumbers"];
bool isUnitPrint =Boolean.Parse(Request.QueryString["isUnitPrint"]);
string[] listId = ids.Split(',');
string[] listUnitQuantity = unitQuantitys.Split(',');
string[] listTotalNumber = totalNumbers.Split(',');
List<AscmMaterialItem> list = new List<AscmMaterialItem>();
for (int i = 0; i < listId.Count(); i++)
{
AscmMaterialItem ascmMaterialItem = AscmMaterialItemService.GetInstance().Get(Int32.Parse(listId[i]));
AscmContainerUnitQuantity ascmContainerUnitQuantity = AscmContainerUnitQuantityService.GetInstance().Get(Int32.Parse(listUnitQuantity[i]));
ascmMaterialItem.container = ascmContainerUnitQuantity.container;
ascmMaterialItem.unitQuantity = ascmContainerUnitQuantity.unitQuantity;
ascmMaterialItem.containerUnitQuantityId = ascmContainerUnitQuantity.id;
ascmMaterialItem.totalNumber = Decimal.Parse(listTotalNumber[i]);
list.Add(ascmMaterialItem);
}
if (!string.IsNullOrEmpty(ids))
{
if (list != null && list.Count() > 0)
{
foreach (AscmMaterialItem ascmMaterialItem in list)
{
//条码
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
if (ascmMaterialItem.docNumber != null)
{
#region Code128
MideaAscm.Code.BarCode128 barCode128 = new Code.BarCode128();
barCode128.TitleFont = new System.Drawing.Font("宋体", 10);
barCode128.HeightImage = 50;
System.Drawing.Bitmap bitmap = barCode128.GetCodeImage(ascmMaterialItem.docNumber, ascmMaterialItem.docNumber, Code.BarCode128.Encode.Code128B);
bitmap.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Gif);
bitmap.Dispose();
#endregion
}
ascmMaterialItem.materialBarcode = memoryStream.ToArray();
//如果是总数打印，单元数=总数
if (!isUnitPrint)
ascmMaterialItem.unitQuantity = ascmMaterialItem.totalNumber;
decimal totalNumber = ascmMaterialItem.totalNumber;//总数量
decimal unitQuantity = ascmMaterialItem.unitQuantity;//单元数
//decimal unitQuantity = 10;
decimal count = decimal.Truncate(totalNumber / unitQuantity);//箱数量>=0
decimal rest = totalNumber % unitQuantity;//剩余数量>=0
//设置装箱数 2015.3.26
//总数 < 单元数 ，仅有一个箱子,总数 = 剩余数量
if (count == 0)
{
count = 1;
}
else
{
//有剩余数量，多出一箱
if (rest != 0) count = count + 1;
}
for (int i = 0; i < count; i++)
{
//最后一个为剩余数量
if (i == count - 1 && rest != 0)
{
lastDetail.materialBarcode = ascmMaterialItem.materialBarcode;
lastDetail.docNumber = ascmMaterialItem.docNumber;
lastDetail.description = ascmMaterialItem.description;
lastDetail.unit = ascmMaterialItem.unit;
lastDetail.unitQuantity = rest;
sumList.Add(lastDetail);
}
else
{
sumList.Add(ascmMaterialItem);
}
}
}
}
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("SupplierMaterialReport.rdlc");
ReportDataSource rds1 = new ReportDataSource();
rds1.Name = "DataSet1";
rds1.Value = sumList;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds1);
string companpyTitle = "美的中央空调";
string title = companpyTitle + "供应商送货物料条码";
ReportParameter[] reportParameters = new ReportParameter[] {
new ReportParameter("ReportParameter_SupplierName",supplierName )
};
ReportViewer1.LocalReport.SetParameters(reportParameters);
ReportViewer1.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
YnFrame.Dal.Entities.YnUser ynUser = YnFrame.Web.FormsAuthenticationService.GetInstance().GetTicketUserData();
if (ynUser == null)
{
throw new Exception("用户错误！");
}
AscmUserInfo ascmUserInfo = AscmUserInfoService.GetInstance().Get(ynUser.userId);
string supplierName = "";
if (ascmUserInfo.extExpandType == "erp")
{
AscmUserInfoService.GetInstance().SetSupplier(ascmUserInfo);
if (ascmUserInfo.ascmSupplier != null)
{
supplierName = ascmUserInfo.ascmSupplier.name;
}
}
//if (ascmUserInfo.extExpandType != "erp")
// throw new Exception("供应商用户错误！");
//AscmUserInfoService.GetInstance().SetSupplier(ascmUserInfo);
//if (ascmUserInfo.ascmSupplier == null)
// throw new Exception("供应商用户错误！");
//提取数据
int id = 0;
List <AscmMaterialItem> list = new List <AscmMaterialItem>();
if (!string.IsNullOrEmpty(Request.QueryString["id"]) && int.TryParse(Request.QueryString["id"], out id))
{
AscmMaterialItem ascmMaterialItem = AscmMaterialItemService.GetInstance().Get(id);
if (ascmMaterialItem != null)
{
//条码
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
if (ascmMaterialItem.docNumber != null)
{
#region Code128
MideaAscm.Code.BarCode128 barCode128 = new Code.BarCode128();
barCode128.TitleFont = new System.Drawing.Font("宋体", 10);
barCode128.HeightImage = 50;
System.Drawing.Bitmap bitmap = barCode128.GetCodeImage(ascmMaterialItem.docNumber, ascmMaterialItem.docNumber, Code.BarCode128.Encode.Code128B);
bitmap.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Gif);
bitmap.Dispose();
#endregion
}
ascmMaterialItem.materialBarcode = memoryStream.ToArray();
list.Add(ascmMaterialItem);
}
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("MaterialReport.rdlc");
ReportDataSource rds1 = new ReportDataSource();
rds1.Name = "DataSet1";
rds1.Value = list;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds1);
string companpyTitle = "美的中央空调";
string title = companpyTitle + "供应商送货物料条码";
ReportParameter[] reportParameters = new ReportParameter[] {
new ReportParameter("ReportParameter_SupplierName", supplierName)
};
ReportViewer1.LocalReport.SetParameters(reportParameters);
ReportViewer1.LocalReport.Refresh();
}
}
