public AscmDeliBatOrderLink(AscmDeliBatOrderLink deliBatOrderLink, string wipEntityName, int wipEntityStatus, string materialDocNumber, string materialName, string materialUnit) { this.id = deliBatOrderLink.id; this.organizationId = deliBatOrderLink.organizationId; this.createUser = deliBatOrderLink.createUser; this.createTime = deliBatOrderLink.createTime; this.modifyUser = deliBatOrderLink.modifyUser; this.modifyTime = deliBatOrderLink.modifyTime; this.batchId = deliBatOrderLink.batchId; this.batchBarCode = deliBatOrderLink.batchBarCode; this.batchDocNumber = deliBatOrderLink.batchDocNumber; this.warehouseId = deliBatOrderLink.warehouseId; this.mainId = deliBatOrderLink.mainId; this.deliveryQuantity = deliBatOrderLink.deliveryQuantity; this.receivedQuantity = deliBatOrderLink.receivedQuantity; this.batchComments = deliBatOrderLink.batchComments; this.wipEntityId = deliBatOrderLink.wipEntityId; this.materialId = deliBatOrderLink.materialId; this.wipEntityName = wipEntityName; this.wipEntityStatus = wipEntityStatus; this._materialDocNumber = materialDocNumber; this._materialName = materialName; this._materialUnit = materialUnit; }
public AscmDeliBatOrderLink(AscmDeliBatOrderLink deliBatOrderLink, string wipEntityName, int wipEntityStatus, string materialDocNumber, string materialName, string materialUnit) { this.id = deliBatOrderLink.id; this.organizationId = deliBatOrderLink.organizationId; this.createUser = deliBatOrderLink.createUser; this.createTime = deliBatOrderLink.createTime; this.modifyUser = deliBatOrderLink.modifyUser; this.modifyTime = deliBatOrderLink.modifyTime; this.batchId = deliBatOrderLink.batchId; this.batchBarCode = deliBatOrderLink.batchBarCode; this.batchDocNumber = deliBatOrderLink.batchDocNumber; this.warehouseId = deliBatOrderLink.warehouseId; this.mainId = deliBatOrderLink.mainId; this.deliveryQuantity = deliBatOrderLink.deliveryQuantity; this.receivedQuantity = deliBatOrderLink.receivedQuantity; this.batchComments = deliBatOrderLink.batchComments; this.wipEntityId = deliBatOrderLink.wipEntityId; this.materialId = deliBatOrderLink.materialId; this.wipEntityName = wipEntityName; this.wipEntityStatus = wipEntityStatus; this._materialDocNumber = materialDocNumber; this._materialName = materialName; this._materialUnit = materialUnit; }
public void Delete(AscmDeliBatOrderLink ascmDeliBatOrderLink) { try { YnDaoHelper.GetInstance().nHibernateHelper.Delete<AscmDeliBatOrderLink>(ascmDeliBatOrderLink); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmDeliBatOrderLink)", ex); throw ex; } }
public void Update(AscmDeliBatOrderLink ascmDeliBatOrderLink) { try { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmDeliBatOrderLink>(ascmDeliBatOrderLink); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmDeliBatOrderLink)", ex); throw ex; } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmDeliBatOrderLink)", ex); throw ex; } }
public List<AscmDeliBatOrderLink> GetListByBatch(int batchId) { List<AscmDeliBatOrderLink> list = null; try { List<AscmDeliveryOrderDetail> listDeliOrderDetail = AscmDeliveryOrderDetailService.GetInstance().GetListByBatch(batchId); if (listDeliOrderDetail != null) { string ids = ""; foreach (AscmDeliveryOrderDetail ascmDeliveryOrderDetail in listDeliOrderDetail) { if (ids != "") ids += ","; ids += ascmDeliveryOrderDetail.id; } if (!string.IsNullOrEmpty(ids)) { string sql = "from AscmDeliBatOrderLink "; string where = ""; where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, " id in(" + ids + ")"); if (!string.IsNullOrEmpty(where)) sql += " where " + where; IList<AscmDeliBatOrderLink> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmDeliBatOrderLink>(sql); if (ilist != null && ilist.Count > 0) { list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmDeliBatOrderLink>(ilist); foreach (AscmDeliBatOrderLink deliBatOrderLink in list) { AscmDeliveryOrderDetail deliveryOrderDetail = listDeliOrderDetail.Find(P => P.id == deliBatOrderLink.id); deliBatOrderLink.ascmDeliveryOrderDetail = deliveryOrderDetail; deliBatOrderLink.batchId = batchId; deliBatOrderLink.batchBarCode = deliveryOrderDetail.mainBatchBarCode; deliBatOrderLink.batchDocNumber = deliveryOrderDetail.mainBatchDocNumber; deliBatOrderLink.warehouseId = deliveryOrderDetail.warehouseId; deliBatOrderLink.mainId = deliveryOrderDetail.mainId; } } else { list = new List<AscmDeliBatOrderLink>(); foreach (AscmDeliveryOrderDetail deliveryOrderDetail in listDeliOrderDetail) { AscmDeliBatOrderLink ascmDeliBatOrderLink = new AscmDeliBatOrderLink(); ascmDeliBatOrderLink.id = deliveryOrderDetail.id; ascmDeliBatOrderLink.ascmDeliveryOrderDetail = deliveryOrderDetail; ascmDeliBatOrderLink.batchId = batchId; ascmDeliBatOrderLink.batchBarCode = deliveryOrderDetail.mainBatchBarCode; ascmDeliBatOrderLink.batchDocNumber = deliveryOrderDetail.mainBatchDocNumber; ascmDeliBatOrderLink.warehouseId = deliveryOrderDetail.warehouseId; ascmDeliBatOrderLink.mainId = deliveryOrderDetail.mainId; ascmDeliBatOrderLink.deliveryQuantity = deliveryOrderDetail.deliveryQuantity; ascmDeliBatOrderLink.receivedQuantity = deliveryOrderDetail.deliveryQuantity; list.Add(ascmDeliBatOrderLink); } } } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmDeliBatOrderLink)", ex); throw ex; } return list; }
public OracleParameter[] GetSysReceiveParams(List<AscmDeliBatOrderLink> listDeliBatOrderLink, AscmDeliBatOrderLink ascmDeliBatOrderLink, string userId,out string paramsKey) { //注意MES存储过程中要求字符串数组长度一致,并且一一对应 string[] headIds = listDeliBatOrderLink.Select(P => P.mainId.ToString()).ToArray(); string[] lineIds = listDeliBatOrderLink.Select(P => P.id.ToString()).ToArray(); string[] itemlocs = new string[lineIds.Length]; string[] recqtys = listDeliBatOrderLink.Select(P => P.receivedQuantity.ToString()).ToArray(); string[] mrecqtys = listDeliBatOrderLink.Select(P => P.deliveryQuantity.ToString()).ToArray(); string[] priorities = new string[lineIds.Length]; string[] istries = new string[lineIds.Length]; string[] tryitemdesc = new string[lineIds.Length]; //为数组元素指定默认值 for (int i = 0; i < lineIds.Length; i++) { itemlocs[i] = ""; priorities[i] = "IQC_Normal"; istries[i] = "N"; tryitemdesc[i] = ""; } StringBuilder strKey = new StringBuilder(); foreach (var item in headIds) { strKey.Append(item + ","); } foreach (var item in lineIds) { strKey.Append(item + ","); } paramsKey = strKey.ToString(); return new OracleParameter[] { //库存组织 new OracleParameter{ ParameterName = "i_org_id", OracleDbType = OracleDbType.Int32, Value = orgId, Direction = ParameterDirection.Input }, //送货批条码号 new OracleParameter{ ParameterName = "i_batch_bar_code", OracleDbType = OracleDbType.Varchar2, Size = 80, Value = ascmDeliBatOrderLink.batchBarCode, Direction = ParameterDirection.Input }, //自动返还,默认值FALSE new OracleParameter{ ParameterName = "i_autoreturnitem", OracleDbType = OracleDbType.Varchar2, Size = 80, Value = "FALSE", Direction = ParameterDirection.Input }, //收货仓库编码 new OracleParameter{ ParameterName = "i_inv_code", OracleDbType = OracleDbType.Varchar2, Size = 80, Value = ascmDeliBatOrderLink.warehouseId, Direction = ParameterDirection.Input }, //是否外租仓,默认值N new OracleParameter{ ParameterName = "i_isrentedinv", OracleDbType = OracleDbType.Varchar2, Size = 80, Value = "N", Direction = ParameterDirection.Input }, //是否外检合格,默认值N new OracleParameter{ ParameterName = "i_ischeckedokinvendor", OracleDbType = OracleDbType.Varchar2, Size = 80, Value = "N", Direction = ParameterDirection.Input }, //送货单备注 new OracleParameter{ ParameterName = "i_memo", OracleDbType = OracleDbType.Varchar2, Size = 240, Value = "", Direction = ParameterDirection.Input }, //送货单头ID(字符串数组) new OracleParameter{ ParameterName = "i_headid", OracleDbType = OracleDbType.Varchar2, Value = headIds, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //送货单行ID(字符串数组) new OracleParameter{ ParameterName = "i_lineid", OracleDbType = OracleDbType.Varchar2, Value = lineIds, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //位置,支持多位置存储,多位置存储时用英文逗号隔开(字符串数组) new OracleParameter{ ParameterName = "i_itemloc", OracleDbType = OracleDbType.Varchar2, Value = itemlocs, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //实收数量(字符串数组),不可为空 new OracleParameter{ ParameterName = "i_recqty", OracleDbType = OracleDbType.Varchar2, Value = recqtys, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //送货数量,根据多位置一一对应,当非多位置存储时默认为0(字符串数组) new OracleParameter{ ParameterName = "i_mrecqty", OracleDbType = OracleDbType.Varchar2, Value = mrecqtys, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //紧急程度,默认值为:IQC_Normal(字符串数组) new OracleParameter{ ParameterName = "i_priority", OracleDbType = OracleDbType.Varchar2, Value = priorities, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //试流,默认值为:N(字符串数组) new OracleParameter{ ParameterName = "i_istry", OracleDbType = OracleDbType.Varchar2, Value = istries, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //试流物料,默认值为空(字符串数组) new OracleParameter{ ParameterName = "i_tryitemdesc", OracleDbType = OracleDbType.Varchar2, Value = tryitemdesc, Direction = ParameterDirection.Input, CollectionType = OracleCollectionType.PLSQLAssociativeArray }, //用户名称 new OracleParameter{ ParameterName = "i_user_code", OracleDbType = OracleDbType.Varchar2, Size = 80, Value = userId, Direction = ParameterDirection.Input }, //返回参(值为0时表示成功) new OracleParameter{ ParameterName = "o_ret_code", OracleDbType = OracleDbType.Varchar2, Size = 4000, Direction = ParameterDirection.Output }, //返回参(错误信息) new OracleParameter{ ParameterName = "o_ret_msg", OracleDbType = OracleDbType.Varchar2, Size = 4000, Direction = ParameterDirection.Output } }; }