private static List <deliver> getDelivers(string id)
{
List <deliver> result = new List <deliver>();
string sql = string.Format(@"SELECT PTD.ID,PTD.DELIVERABLE_NAME, PTD.DELIVER_TYPE,
TO_CHAR(PTD.DELIVER_ACUTAL_DATE, 'YYYY-MM-DD') DELIVER_ACUTAL_DATE,
CASE
WHEN PTD.DELIVER_STAUS = '20' THEN
'已提交'
WHEN PTD.DELIVER_STAUS = '30' THEN
'后补充'
ELSE
'未提交'
END AS DELIVER_STAUS_EN,
(SELECT wm_concat(ATTACH_NAME) FROM pt6.sys_attachment where parent_table_id='groupTrailDate123321'
and parent_register_id=PTD.ID)ATTACH_NAMES
FROM pt6.PM_TASK_DELIVER PTD
WHERE PTD.TASK_ID = '{0}'", id);
DataSet ds = OracleHelper.Query(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
deliver item = deliver.Parse(dr);
result.Add(item);
}
return(result);
}
public static deliver Parse(DataRow element)
{
deliver result = new deliver();
result.deliverId = element["ID"].ToString();
result.deliverName = element["DELIVERABLE_NAME"].ToString();
result.attachNames = element["ATTACH_NAMES"].ToString();
result.deliverType = element["DELIVER_TYPE"].ToString();
result.deliverPlanDate = element["DELIVER_ACUTAL_DATE"].ToString();
result.deliverState = element["DELIVER_STAUS_EN"].ToString();
return(result);
}
public static deliver Parse(XElement element)
{
deliver result = new deliver();
result.deliverId = element.Element("deliverId").Value;
result.deliverName = element.Element("deliverName").Value;
result.attachNames = element.Element("attachNames").Value;
result.deliverType = element.Element("deliverType").Value;
result.deliverPlanDate = element.Element("deliverPlanDate").Value;
result.deliverState = element.Element("deliverState").Value;
return(result);
}
