/// <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);
}
private void Button_Click_4(object sender, RoutedEventArgs e)
{
CusInfo win6 = new CusInfo();
win6.Show();
}