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); }
public void BookingEvent(ModelRecord[] objM) { // 更新Room List <string> sqls = new List <string>(); foreach (var ob in objM) { clsSQLBuilder cls = new clsSQLBuilder(); cls.AddField("RECORDID", clsSQLBuilder.FieldType.FD_STRING, ob.RECORDID, false); cls.AddField("ROOMID", clsSQLBuilder.FieldType.FD_STRING, ob.ROOMID, false); cls.AddField("STARTTIME", clsSQLBuilder.FieldType.FD_DATETIME, ob.STARTTIME, false); cls.AddField("ENDTIME", clsSQLBuilder.FieldType.FD_DATETIME, ob.ENDTIME, false); cls.AddField("BOOKTYPE", clsSQLBuilder.FieldType.FD_STRING, ob.BOOKTYPE, false); cls.AddField("UPDATET", clsSQLBuilder.FieldType.FD_DATE, ob.UPDATET, false); cls.AddField("APPLIER", clsSQLBuilder.FieldType.FD_STRING, ob.APPLIER, false); cls.AddField("APPLIEREXT", clsSQLBuilder.FieldType.FD_STRING, ob.APPLIEREXT, false); cls.AddField("APPLIERID", clsSQLBuilder.FieldType.FD_STRING, ob.APPLIERID, false); cls.AddField("RECORDID", clsSQLBuilder.FieldType.FD_STRING, ob.RECORDID, false); sqls.Add(string.Format(@" insert into MBS_RECORD {0}", cls.GetString_Insert())); } DALService.ExecuteBatchNonQuery(sqls.ToArray()); }