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");
}