private void InitSourceType()
{
string sQuery = string.Format("SELECT sourtype,seqnumbr FROM CRSOURTYPE ORDER BY seqnumbr");
DataSet dset = gs.GetDataBySql(sQuery);
if (dset != null && dset.Tables[0].Rows.Count > 0)
{
this.cboSourceType.ItemsSource = dset.Tables[0].DefaultView;
this.cboSourceType.SelectedValuePath = "sourtype";
this.cboSourceType.DisplayMemberPath = "sourtype";
}
}
///
/// 根据传入SQL语句取数据
///
///
///
public DataSet GetDataBySql(string sCommand)
{
try
{
DBOperator db = GetDBOperator(DBName);
return db.ExecuteQuery(sCommand);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}