public static DataTable GetEmployeeInfoByWorkID(string sWorkID)
{
var db = DBO.CreateDatabaseKQXT();
using (var conn = db.CreateConnection())
{
conn.Open();
string strUpdateSql = @"select OutID,Name,IDCardNo from Customer where OutID=@sOutID";
try
{
var dbCommandWrapper = db.GetSqlStringCommand(strUpdateSql);
db.AddInParameter(dbCommandWrapper, "@sOutID", DbType.String, sWorkID);
return(db.ExecuteDataSet(dbCommandWrapper).Tables[0]);
}
catch (Exception ex)
{
return(null);
}
}
}
