设置TextBox为可以多行显示的属性:TextBox1.Multline=true;
//循环获取TextBox里分行数据——员工工号的值,拼接成字符串
private string EmpNoArr2;
for (int i = 0; i < TxtInputEmpNo.Lines.Length; i++)
{
if (i == 0)
{
EmpNoArr2 = "'" + TxtInputEmpNo.Lines[i].ToString() + "'";
}
else
{
EmpNoArr2 += ",'" + TxtInputEmpNo.Lines[i].ToString() + "'";
}
}
strSelect.Append(" Select EmpNo ,EmpName,Begindate ");
strSelect.Append(" From kq_new_leavereport Where EmpNo in (" + EmpNoArr2 + ") Order by EmpNo");