/// <summary> /// 根據條件,查詢並回客服補書訂單資訊(含明細) /// </summary> /// <param name="ParameterList"></param> /// <returns>回傳查詢結果</returns> public DataSet QueryCRMOrderByFind(ArrayList ParameterList) { try { int i_Id = 0; string s_Log_User = string.Empty; DataSet ds_Return = new DataSet(); DataTable dt_Return_Main = new DataTable(); DataTable dt_Return_Detl = new DataTable(); DBO.VDS_CRM_ORDER_MAINDBO VCOM = new VDS_CRM_ORDER_MAINDBO(ref USEDB); DBO.VDS_CRM_ORDER_DETLDBO VCOD = new VDS_CRM_ORDER_DETLDBO(ref USEDB); dt_Return_Main = VCOM.QUERY_CRMORDERBYFIND_MAIN(ParameterList); if (dt_Return_Main.Rows.Count > 0) { i_Id = int.Parse(dt_Return_Main.Rows[0]["ID"].ToString()); s_Log_User = ParameterList[6].ToString(); ParameterList.Clear(); ParameterList.Add(i_Id); ParameterList.Add(s_Log_User); dt_Return_Detl = VCOD.QUERY_CRM041_DETL(ParameterList); } dt_Return_Main.TableName = "VDS_CRM_ORDER_MAIN"; dt_Return_Detl.TableName = "VDS_CRM_ORDER_DETL"; ds_Return.Tables.Add(dt_Return_Main.Copy()); ds_Return.Tables.Add(dt_Return_Detl.Copy()); dt_Return_Main.Clear(); dt_Return_Detl.Clear(); dt_Return_Main.Dispose(); dt_Return_Detl.Dispose(); return ds_Return; } catch (Exception ex) { throw GetNewException(ex); } }