if (Config.DbInfo.DbType.Equals(DBType.SQLServer))

{

    sql = " IF EXISTS (SELECT 1 FROM wifi.imsi_model_status WHERE  device_id = @device_id and wireless='" + row[].GetString() + "') UPDATE wifi.imsi_model_status SET model_status = @model_status,version=@version,serialnumber=@serialnumber, Log_Time=" + SysConst.time_sqlserver + " WHERE device_id = @device_id and wireless='" + row[].GetString() + "' ELSE INSERT INTO wifi.imsi_model_status(Log_Time, device_id, wireless,model_status,version,serialnumber) VALUES(" + SysConst.time_sqlserver + ", @device_id,'" + row[].GetString() + "', @model_status,@version,@serialnumber)";

    cmdParms = new IDataParameter[];

    cmdParms[] = new SqlParameter("@device_id", deviceId);

    cmdParms[] = new SqlParameter("@model_status", row[].GetString());

    cmdParms[] = new SqlParameter("@version", ver);

    cmdParms[] = new SqlParameter("@serialnumber", ser);

    sqlDic.Add(sql, cmdParms);

}

else if (Config.DbInfo.DbType.Equals(DBType.Oracle))

{

    sql = "MERGE INTO wifi.imsi_model_status a USING (select count(*) co from wifi.imsi_model_status WHERE  device_id = :device_id and wireless='" + row[].GetString() + "') b  ON (b.co<>0) WHEN MATCHED THEN UPDATE  SET Log_Time=" + SysConst.time_sql + ",model_status = :model_status,version=:version,serialnumber=:serialnumber WHERE  device_id = :device_id and wireless='" + row[].GetString() + "' WHEN NOT MATCHED THEN INSERT (Log_Time, device_id,wireless, model_status,version,serialnumber) VALUES(" + SysConst.time_sql + ", :device_id, '" + row[].GetString() + "',:model_status,:version,:serialnumber)";

    cmdParms = new IDataParameter[];

    cmdParms[] = new OracleParameter(":device_id", deviceId);

    cmdParms[] = new OracleParameter(":model_status", row[].GetString());

    cmdParms[] = new OracleParameter(":version", ver);

    cmdParms[] = new OracleParameter(":serialnumber", ser);

    sqlDic.Add(sql, cmdParms);

}

if exists (select 1 from Teacher where id='')

    update Teacher set name='lisi',addr='重庆' where Id=''

else

    insert into Teacher(id,name,addr) values(1,'lisi','重庆')

MERGE INTO Teacher USING (select count(1) co from Teacher WHERE id='') on(co<>0)

WHEN MATCHED THEN

  update set name='lisi',addr='重庆' where Id=''

WHEN NOT MATCHED THEN

  insert (id,name,addr) values(1,'lisi','重庆')