/// <summary>
/// 发送临时订单
/// </summary>
/// <param name="tempOrderList"></param>
/// <returns></returns>
public static bool SendTempOrder(List <TempOrderVo> tempOrderList)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
List <string> parameterList = new List <string>();
foreach (TempOrderVo vo in tempOrderList)
{
string sql = mySqlclient.GenerateInsertSql(vo);
parameterList.Add(sql);
sql = "update room set RoomStatus='占用' where RoomId=" + vo.RoomID + ANDCOMPANYID;
parameterList.Add(sql);
sql = "update staffwork set StaffStatus='工作中' , RoomId=" + vo.RoomID + " where StaffID='" + vo.StaffID + "'" + ANDCOMPANYID;
parameterList.Add(sql);
}
return(mySqlclient.ExecuteTransaction(parameterList));
}
