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