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