将表中的某个字段值提取出来赋给变量
//
查询
ID
,将
ProduceOrder
表中的
OriOrderIDs
字段值赋给一个变量
public
string
SearchOriOrderIDs(
string
ProduceOrderID)
{
string
sql =
"select OriOrderIDs from ProduceOrder where ProduceOrderID = '"
+ ProduceOrderID +
"'"
;
Database
db =
DatabaseFactory
.CreateDatabase();
DBCommandWrapper
cmd = db.GetSqlStringCommandWrapper(sql);
DataSet
dt =
new
DataSet
();
dt = db.ExecuteDataSet(cmd);
DataTable
dta = dt.Tables[0];
string
id = dta.Rows[0][0].ToString();
return
id;
}