Sqlsugar 无实体取任意表的数据及另存到它表中

private async void button1_Click(object sender, EventArgs e)
{
	var ww = SqlSugarHelper.SqlSugarClient.Queryable<dynamic>().AS("t_sourcedata").Where("emp_code=@aa and recodate='2022-10-10'", new { aa = "103" })
		.Select("recodate,recotime, card_no, clockid, emp_code")
		.ToDataTable();

	dataGridViewEx1.DataSource = ww;


	int result = await SqlSugarHelper.SqlSugarClient.Fastest<DataTable>().AS("zz_temp221001").BulkCopyAsync("zz_temp221001", ww);

	MessageBox.Show("test OK");
}

posted on 2022-10-27 10:12  manber  阅读(662)  评论(0编辑  收藏  举报

导航