예제 #1
0
        /// <summary>
        /// 獲得客戶編號和名稱
        /// </summary>
        /// <param name="cusNo"></param>
        /// <param name="delNo"></param>
        /// <returns></returns>
        public List <CusInfo> getCusInfo()
        {
            List <CusInfo> cusInfoList = null;
            StringBuilder  strSql      = new StringBuilder();

            strSql.Append("SELECT CUST.CUST_ACCOUNT_ID, CUST.PARTY_NAME FROM MES_CUSTINFO_V CUST");
            OracleParameter[] parameters =
            {
            };

            DataSet ds = OracleSQLHelper.ExecuteDataset(OracleSQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                cusInfoList = new List <CusInfo>();
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    CusInfo cusInfo = new CusInfo();
                    cusInfo.CusNo   = dr["CUST_ACCOUNT_ID"].ToString();
                    cusInfo.CusName = dr["PARTY_NAME"].ToString();
                    cusInfoList.Add(cusInfo);
                }
            }
            return(cusInfoList);
        }
예제 #2
0
        private void Button_Click_4(object sender, RoutedEventArgs e)
        {
            CusInfo win6 = new CusInfo();

            win6.Show();
        }