110,536
社区成员
发帖
与我相关
我的任务
分享
private void btnSelect_Click(object sender, EventArgs e)
{
PAOS.BaseClass.DataCon datacon = new PAOS.BaseClass.DataCon();
PAOS.BaseClass.DataOperate doperate = new PAOS.BaseClass.DataOperate();
DataSet myds = datacon.getds("SELECT employee AS SYSID,description5 as 工厂编号, code AS 工号, name AS 姓名, shname AS 短名, description1 AS 拼音名, username AS 英文, description2 AS 入职日期, description4 AS 离职日期, "
+ " extcode as Extcode, fixshift AS 班次, fixjob AS 工种, dbuser AS 账号, dbpassword AS 登录密码, state AS 一卡通状态, readerpin AS UUCODE, active AS 状态 FROM dbo.base_employees where code like '"+TxtCODE.Text.Trim()+"%'"+"", "base_employees");
dgvPInfo.DataSource = myds.Tables["base_employees"];
}