//提交保存房间信息 public static string save_room(string infor_str) { try { string[] infor = infor_str.Split('#'); //var db = new BathDbDataContext(connectionString); //var room = db.Room.FirstOrDefault(x => x.name == infor[0]); string cmd_str = @"update [Room] set status='"+infor[14]+"'"; if (infor[1] != "null") { cmd_str += ",openTime='" + infor[1] + "'"; //room.openTime = infor[1]; } if (infor[2] != "null") cmd_str += ",seat='" + infor[2] + "'"; //room.seat = infor[2]; if (infor[3] != "null") cmd_str += ",systemId='" + infor[3] + "'"; //room.systemId = infor[3]; if (infor[4] != "null") cmd_str += ",orderTechId='" + infor[4] + "'"; //room.orderTechId = infor[4]; if (infor[5] != "null") cmd_str += ",menu='" + infor[5] + "'"; //room.menu = infor[5]; if (infor[6] != "null") cmd_str += ",techId='" + infor[6] + "'"; //room.techId = infor[6]; if (infor[7] != "null") cmd_str += ",startTime='" + infor[7] + "'"; //room.startTime = infor[7]; if (infor[8] != "null") cmd_str += ",serverTime='" + infor[8] + "'"; //room.serverTime = infor[8]; if (infor[9] != "null") cmd_str += ",orderTime='" + infor[9] + "'"; //room.orderTime = infor[9]; cmd_str += ",hintPlayed='" + infor[10] + "'"; //room.hintPlayed = infor[10]; if (infor[11] != "null") cmd_str += ",reserveId='" + infor[11] + "'"; //room.reserveId = infor[11]; if (infor[12] != "null") cmd_str += ",reserveTime='" + infor[12] + "'"; //room.reserveTime = infor[12]; if (infor[13] != "null") cmd_str += ",selectId='" + infor[13] + "'"; //room.selectId = infor[13]; //room.status = infor[14]; //db.SubmitChanges(); cmd_str += " where name='" + infor[0] + "'"; var dbLayer = new DBLayer(connectionString); if (!dbLayer.execute_command(cmd_str)) return "false"; return "true"; } catch (System.Exception e) { return "false"; } }
public static string set_log_urgent(string id, string urgent) { string str = "T"; var db = new DBLayer(connectionString); if (!db.execute_command("update [DepartmentLog] set urgent=" + urgent + " where id=" + id)) str = "F"; return str; }