// 操作 public int DeleteBookingData(string recordid, string userid) { string sql = string.Format(@" delete MBS_RECORD t where recordid = '{0}' and applierid = '{1}' and starttime > sysdate ", recordid, userid); return(DALService.ExecuteNonQuery(sql)); }
public bool UpdateMRRoom(ModelMR mr) { clsSQLBuilder cls = new clsSQLBuilder(); cls.AddField("ACCESSRIGHT", clsSQLBuilder.FieldType.FD_STRING, mr.ACCESSRIGHT, true); cls.AddField("CNPC", clsSQLBuilder.FieldType.FD_STRING, mr.CNPC, true); cls.AddField("EQIPMENT", clsSQLBuilder.FieldType.FD_STRING, mr.EQIPMENT, true); cls.AddField("EXT", clsSQLBuilder.FieldType.FD_STRING, mr.EXT, true); // cls.AddField("FLOOR", clsSQLBuilder.FieldType.FD_STRING, mr.FLOOR, true); cls.AddField("IMGPATH", clsSQLBuilder.FieldType.FD_STRING, mr.IMGPATH, true); cls.AddField("IP", clsSQLBuilder.FieldType.FD_STRING, mr.IP, true); cls.AddField("MAXP", clsSQLBuilder.FieldType.FD_NUMBER, mr.MAXP.ToString(), true); cls.AddField("MINP", clsSQLBuilder.FieldType.FD_NUMBER, mr.MINP.ToString(), true); cls.AddField("POSTPERIOD", clsSQLBuilder.FieldType.FD_NUMBER, mr.POSTPERIOD.ToString(), true); cls.AddField("PLANT", clsSQLBuilder.FieldType.FD_STRING, mr.PLANT.ToString(), true); cls.AddField("ROOMABBR", clsSQLBuilder.FieldType.FD_STRING, mr.ROOMABBR.ToString(), true); cls.AddField("ROOMID", clsSQLBuilder.FieldType.FD_STRING, mr.ROOMID.ToString(), false); cls.AddField("ROOMNAME", clsSQLBuilder.FieldType.FD_STRING, mr.ROOMNAME.ToString(), true); cls.AddField("SITE", clsSQLBuilder.FieldType.FD_STRING, mr.SITE.ToString(), true); cls.AddField("SITEID", clsSQLBuilder.FieldType.FD_STRING, GetSiteid(mr.SITE, mr.PLANT, mr.FLOOR), true); string sqls = string.Format(@"MERGE INTO {0} USING DUAL ON (ROOMID = '{1}') WHEN MATCHED THEN UPDATE SET {2} WHEN NOT MATCHED THEN INSERT {3}" , "MBS_ROOM " , mr.ROOMID , cls.GetString_Update() , cls.GetString_Insert() ); DALService.ExecuteNonQuery(sqls); return(true); }