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;
}
