/// <summary>
/// Get Uda SalesOrderAttr
/// </summary>
/// <param name="dataset">dataset for select condition</param>
/// <returns>dataset</returns>
public DataSet GetUdaSalesOrderAttr(DataSet dataset)
{
//define dataset to receive db data
DataSet dataDs = new DataSet();
//define sql
string sql = "";
try
{
if (dataset != null && (dataset.Tables[0].Rows.Count > 0))
{
sql = "SELECT * FROM POR_SALES_ORDER_ATTR WHERE 1=1 ";
for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
sql += " AND " + dataset.Tables[0].Rows[i][0].ToString();
sql += " =" + dataset.Tables[0].Rows[i][1];
}
sql += " ORDER BY SALES_ORDER_KEY";
}
else
{
sql = "SELECT * FROM POR_SALES_ORDER_ATTR ORDER BY SALES_ORDER_KEY";
}
DataTable dataTable = new DataTable();
dataTable = dbEngine.ExecuteDataSet(sql).Tables[0];
dataTable.TableName = "POR_SALES_ORDER_ATTR";
dataDs.Merge(dataTable, false, MissingSchemaAction.Add);
//add paramter table
SolarViewer.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dataDs, "");
}
catch (Exception ex)
{
SolarViewer.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dataDs, ex.Message);
LogService.LogError("GetUdaSalesOrderAttr Error: " + ex.Message);
}
return(dataDs);
}
