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