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