public AscmCuxWipReleaseHeaders(AscmCuxWipReleaseHeaders ascmCuxWipReleaseHeaders)//, long detailCount, long totalNumber { this.releaseHeaderId = ascmCuxWipReleaseHeaders.releaseHeaderId; this.organizationId = ascmCuxWipReleaseHeaders.organizationId; this.createUser = ascmCuxWipReleaseHeaders.createUser; this.createTime = ascmCuxWipReleaseHeaders.createTime; this.modifyUser = ascmCuxWipReleaseHeaders.modifyUser; this.modifyTime = ascmCuxWipReleaseHeaders.modifyTime; this.wipEntityId = ascmCuxWipReleaseHeaders.wipEntityId; this.releaseNumber = ascmCuxWipReleaseHeaders.releaseNumber; this.releaseType = ascmCuxWipReleaseHeaders.releaseType; this.releaseStatus = ascmCuxWipReleaseHeaders.releaseStatus; this.releaseDate = ascmCuxWipReleaseHeaders.releaseDate; //this.detailCount = detailCount; //this.totalNumber = totalNumber; }
//, long detailCount, long totalNumber public AscmCuxWipReleaseHeaders(AscmCuxWipReleaseHeaders ascmCuxWipReleaseHeaders) { this.releaseHeaderId = ascmCuxWipReleaseHeaders.releaseHeaderId; this.organizationId = ascmCuxWipReleaseHeaders.organizationId; this.createUser = ascmCuxWipReleaseHeaders.createUser; this.createTime = ascmCuxWipReleaseHeaders.createTime; this.modifyUser = ascmCuxWipReleaseHeaders.modifyUser; this.modifyTime = ascmCuxWipReleaseHeaders.modifyTime; this.wipEntityId = ascmCuxWipReleaseHeaders.wipEntityId; this.releaseNumber = ascmCuxWipReleaseHeaders.releaseNumber; this.releaseType = ascmCuxWipReleaseHeaders.releaseType; this.releaseStatus = ascmCuxWipReleaseHeaders.releaseStatus; this.releaseDate = ascmCuxWipReleaseHeaders.releaseDate; //this.detailCount = detailCount; //this.totalNumber = totalNumber; }
public void Update(AscmCuxWipReleaseHeaders ascmDeliveryNotify) { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmCuxWipReleaseHeaders>(ascmDeliveryNotify); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmCuxWipReleaseHeaders)", ex); throw ex; } } }
/* * 2014/5/12 by chenyao */ public List<AscmCuxWipReleaseHeaders> GetList(YnPage ynPage, string releaseNumber, string startScheduledStartDate, string endScheduledStartDate, int? statusType) { List<AscmCuxWipReleaseHeaders> list = null; string sql = "select {0} from cux_wip_release_headers wrh,wip_discrete_jobs wdj,wip_entities we,mtl_system_items_b msib"; string where = string.Empty; where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wrh.wip_entity_id = wdj.wip_entity_id"); where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wdj.wip_entity_id = we.wip_entity_id"); where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wdj.primary_item_id = msib.inventory_item_id"); where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wdj.organization_id = 775"); where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wrh.organization_id = 775"); where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wrh.release_type = 'ISSUE'"); if (!string.IsNullOrWhiteSpace(releaseNumber)) where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wrh.release_number = '" + releaseNumber.Trim() + "'"); string whereStartScheduledStartDate = "", whereEndScheduledStartDate = ""; DateTime dtStartScheduledStartDate, dtEndScheduledStartDate; if (!string.IsNullOrEmpty(startScheduledStartDate) && DateTime.TryParse(startScheduledStartDate, out dtStartScheduledStartDate)) { whereStartScheduledStartDate = "wdj.scheduled_start_date >= to_date('" + dtStartScheduledStartDate.ToString("yyyy-MM-dd 00:00") + "', 'yyyy-mm-dd hh24:mi')"; whereEndScheduledStartDate = "wdj.scheduled_start_date < to_date('" + dtStartScheduledStartDate.AddDays(1).ToString("yyyy-MM-dd 00:00") + "', 'yyyy-mm-dd hh24:mi')"; } if (!string.IsNullOrEmpty(endScheduledStartDate) && DateTime.TryParse(endScheduledStartDate, out dtEndScheduledStartDate)) whereEndScheduledStartDate = "wdj.scheduled_start_date < to_date('" + dtEndScheduledStartDate.AddDays(1).ToString("yyyy-MM-dd 00:00") + "', 'yyyy-mm-dd hh24:mi')"; where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereStartScheduledStartDate); where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereEndScheduledStartDate); if (statusType.HasValue) where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, "wdj.status_type = " + statusType.Value); sql += " where " + where; string selectCount = string.Format(sql, "count(1)"); sql = string.Format(sql, "wrh.release_header_id,wrh.release_number,wrh.wip_entity_id,we.wip_entity_name,wdj.scheduled_start_date,wdj.wip_supply_type,wdj.schedule_group_id,wdj.net_quantity,wdj.status_type,wdj.description,msib.segment1"); sql += " order by wrh.release_header_id"; OracleParameter[] commandParameters = new OracleParameter[] { new OracleParameter { ParameterName = "i_sql", OracleDbType = OracleDbType.Varchar2, Size = 2000, Value = sql, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = "i_sql_count", OracleDbType = OracleDbType.Varchar2, Size = 2000, Value = selectCount, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = "i_pagesize", OracleDbType = OracleDbType.Int32, Value = ynPage.pageSize, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = "i_currentpage", OracleDbType = OracleDbType.Int32, Value = ynPage.currentPage, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = "o_totalcount", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.Output }, new OracleParameter { ParameterName = "o_pagecount", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.Output }, new OracleParameter { ParameterName = "o_cursor", OracleDbType = OracleDbType.RefCursor, Direction = ParameterDirection.Output } }; try { ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession(); OracleCommand command = (OracleCommand)session.Connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "cux_ascm_interface_utl.sp_exec_page"; Array.ForEach<OracleParameter>(commandParameters, P => command.Parameters.Add(P)); OracleDataAdapter da = new OracleDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { list = new List<AscmCuxWipReleaseHeaders>(); foreach (DataRow dr in dt.Rows) { AscmCuxWipReleaseHeaders cuxWipReleaseHeaders = new AscmCuxWipReleaseHeaders(); cuxWipReleaseHeaders.releaseHeaderId = Convert.ToInt32(dr["release_header_id"]); cuxWipReleaseHeaders.releaseNumber = dr["release_number"].ToString(); cuxWipReleaseHeaders.wipEntityId = Convert.ToInt32(dr["wip_entity_id"]); cuxWipReleaseHeaders.wipEntityName = dr["wip_entity_name"].ToString(); cuxWipReleaseHeaders.scheduledStartDate = dr["scheduled_start_date"].ToString(); cuxWipReleaseHeaders.wipSupplyType = Convert.ToInt32(dr["wip_supply_type"]); cuxWipReleaseHeaders.scheduleGroupId = Convert.ToInt32(dr["schedule_group_id"]); cuxWipReleaseHeaders.netQuantity = Convert.ToDecimal(dr["net_quantity"]); cuxWipReleaseHeaders.statusType = Convert.ToInt32(dr["status_type"]); cuxWipReleaseHeaders.description = dr["description"].ToString(); cuxWipReleaseHeaders.primaryItemDocNumber = dr["segment1"].ToString(); list.Add(cuxWipReleaseHeaders); } } int totalCount = 0; int.TryParse(commandParameters[4].Value.ToString(), out totalCount); ynPage.SetRecordCount(totalCount); int pageCount = 0; int.TryParse(commandParameters[5].Value.ToString(), out pageCount); ynPage.pageCount = pageCount; } catch (Exception ex) { throw ex; } return list; }